1. Right-click the name of the
Stratum.Connector for Viewer SQL Server database
in the main window, and
select Parameters.
2. Use tabs in the Parameter Settings window to customize the following properties.
Process Log Verbosity – By default, set to Diagnostic, which means information about the databases and servers in your implementation will be retrieved and displayed in the processing logs when you initiate a Stratum.Connector for Viewer process. Diagnostic information retrieval can be disabled by selecting Minimal or Normal.
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.
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 for Viewer, you will need to enter a key using this property.
Note: Keys are required for licensed copies of Stratum.Connector for Viewer. If you receive a message about a missing or invalid key, contact Silvon Support at (800) 474-5866 or product.support.usa@silvon.com.
Stop processing on key errors - Select if you want Stratum.Connector for Viewer 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 even if key errors are found.
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.
Override Key Error Log File - Use to customize the location and name of the log file that captures key errors. Select the checkbox and then specify a location. A log file is created whether or not you choose to stop processing for key errors.
Process Type - Use this and other Batch Process settings to set up default parameters for use when Stratum.Connector for Viewer updates are processed in batch. 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 optionally override these default settings – a list of relevant batch command parameters to use for that purpose is provided in the topic Batch Command Parameters for Silvon.Connector.exe.
Email Properties - Use these fields to control the email that will be generated by the batch process. The email notifies recipients that a process occurred. Recipients can review a log file attached to the email for information about the process such as whether or not it completed successfully. If you enter multiple email addresses in the From or To field, use commas or semi-colons to separate the addresses.
SMTP Server Name - Use this field to determine how Stratum.Connector for Viewer will deliver Batch Process emails -- either using the SMTP configurations for the server where Stratum.Connector for Viewer 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).
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.