in the main window, and
select Parameters.1. Right-click the name of the
Stratum.Connector SQL Server database in the main window, and
select Parameters.
2. Use tabs in the Parameter Settings window to customize the following properties. To learn more about Email settings in this window, watch this Email Notifications Video.
Enable Group By for Detail Flip-up Views – Controls whether or not the Stratum server database engine will apply an aggregation on the result set and send less data to the Analysis Services server to process. The option is enabled by default.
Automatically Select New Dimensions - Enable this option if you want all dimensions that are added after the initial Analysis Services database set up to be automatically selected for all applicable measure groups. The selections pertain to the Measure Group Selection window and will be made for you once the database is processed again.
Add Missing Members for User Controlled Data - Controls if Connector processes will check for and add missing Master File records that are needed to support user controlled data functionality such as Stratum.Viewer’s Data Import. If your company has implemented user controlled data functionality, enable this parameter. If not, then this parameter can be disabled. By default, the parameter is enabled.
Note: This parameter only applies to Stratum Server SQL Server implementations.
Currency Dimension Name - Use to customize the name of that dimension.
Registration Key - If a valid key is not associated with your copy of Stratum.Connector, you will need to enter a key using this property.
Default Process Type - This setting controls the default process type that will be initiated when Stratum.Connector updates are processed in batch and a process type is not specified. Batch processes are typically executed on a nightly basis in order to update the Analysis Services database and cube with the most recent data from Stratum.Server. While setting up a batch process, you can override this default – see the topic
Note: Keys are required for licensed copies of Stratum.Connector. If you receive a message about a missing, invalid, or expired key, contact Silvon Support at (800) 474-5866 or CustomerSupport@silvon.com.
Process Pending User Controlled Attribute Update – Properties in this section determine how pending changes for attributes added or edited in Stratum.Viewer are treated by Limited and Standard processes. These attributes are known as User Controlled Attributes. Setting a process type to No means it will not process any pending changes. Setting a process type to Yes means pending changes will be processed. The process will check for pending changes then switch to a Full process if changes are found so all changes can be processed.
Note: Only set the properties to Yes in situations where it is okay if the Limited or Standard process is switched to Full process (a Full process means users won’t be able to access views in Stratum.Viewer until after the process is completed).
Stop Processing On Key Errors - Select if you want Stratum.Connector to stop processing the Analysis Services database when it finds a dimension value (members) in the Stratum.Server database for which no Master File information exists. If you leave this checkbox de-selected, processing will continue until the Key Error Limit is reached.
Key Error Limit - Use to specify how many key errors can occur before database processing will be stopped. For example 0 (zero), 10, 20, etc. This field is enabled only if the stop processing option has been selected.
SMTP Server Name - Use this field to determine how Stratum.Connector will deliver emails -- either using the SMTP configurations for the server where Stratum.Connector resides (localhost) or by another SMTP server that you specify (enter the server name in a format that will be recognized by your network, such as the server name or IP address).
Email From Address - Specify the email address that will act as the “From” sender for Connector emails.
Email Notification Properties - Specify the To Address, Subject, and Body properties for each of the different email notifications that Connector sends out. The type of email sent depends on the outcome of the Connector process (see below). If you enter multiple email addresses in a To field, use commas or semi-colons to separate the addresses. By default, the relevant log file for the process will be attached to the email unless you select No for an email’s Attach Process Log property.
Process Complete - Cube Available: The email is sent when a process completes and the database is available.
Note: When a Limited or Trickle process completes but encounters an error that prevents the cube from being updated, the cube remains available to users. In this case, Connector will append a ‘Process failed with an error’ note to the Subject of your email message to indicate that while the cube is available, the updates failed.
Process Complete - Cube Locked: The email is sent when a process completes, but the database is locked.
Key Errors Occurred: The email is sent when key errors occurred and were logged during the processing of the database.
User Controlled Attribute Update Notification: The email is sent when a Stratum.Viewer user has added, made changes to, or deleted a User Controlled Attribute via that application’s User Controlled Attribute Maintenance functionality. The email tells the recipient a Full process may be required in Connector to process the changes.
Process Log Verbosity - By default, this is set to Normal, which means your logs will include process start and finish times as well as details about what objects were processed. If you need more detailed information, change this option to Debug. In that case, more detailed information will be included in the processing logs.
Override Locations - Optionally change the location of any of the three types of log files listed in this tab. By default, log files are stored in the Log folder of the Stratum.Connector main application folder. You can separately control the location of the Process Log (log for Full, Standard, Trickle, and so forth), Key Error Log, and Post Process Temp log. To change any of these properties, select the checkbox for that log then enter the desired location and name.
3. Save 
the
changes and close 
the window.
4. If you are setting up the database for the first time, continue with any remaining steps for setting up the application -- see Quick Start - Initial Setup of Application and Data. If you are editing the database, see Quick Start - When to use a Full, Limited, Post, Standard, or Trickle Process to determine what type of database process to run after making your changes.