A Full, Standard, Post, Limited, or Diagnostic process can be initiated using the right click menu of the Analysis Services database in the Stratum.Connector for Viewer application. Any of those process types also can be initiated by including the Stratum.Connector for Viewer application file* as part of a batch command. A Trickle process can only be initiated that way. The batch command can be run a variety of ways including through scheduled tasks set up in third-party scheduling tools or SSIS Scripts.
*Note: The application file is an executable file named Silvon.Connector.exe. It resides in the main folder of the application directory to which Stratum.Connector for Viewer was originally installed.
Keep in mind these requirements when using the parameters:
Specify the main parameters in the order of /batch /ProcessType: /ProcessBy:.
A space must be used between each parameter.
Remember to use a colon (:) after the names of all parameter types below other than the /batch command parameter.
If any values for your parameters contain spaces, you will need to enclose the parameter and its values in double quotes. For example, "/MailBody: Here is the Connector log for the most recent Limited Process."
If you use the /MailTo: parameter and specify multiple email addresses, use semi-colons to separate the addresses.
Main Parameter |
Purpose |
Required? |
/batch |
Tells Analysis Services to run the Stratum.Connector.exe in batch. |
Yes |
/ProcessType:ProcessTypeEnum |
Specifies the type of process that the batch process will run. Valid values for ProcessTypeEnum are: 0 – Full 1 – Standard 2 – Post 3 – Diagnostic 4 – Limited 5 – Trickle |
Yes |
/ProcessBy:MeasureGroupId |
This parameter only pertains to a process type 5 – Trickle process. It is the ID of the measure group(s) to be processed. |
Yes - The MeasureGroupId is required for process type 5 – Trickle process. Use semi-colons (;) as a separator to process more than one MeasureGroupId. For example, /ProcessBy:1;4;8, will process all years for measure groups 1,4, and 8. |
/ProcessBy:MeasureGroupId(YearValue) |
This additional YearValue option only pertains to process type 5 – Trickle process and implementations with Enterprise Edition of Analysis Services. YearValue represents the year(s) of the measure group to be processed. |
No - If you have the Enterprise Edition of Analysis Services, you can optionally specify what year(s) (YearValue) will be processed for the identified measure group. Use commas (,) as separators to specify multiple years. For example, /ProcessBy:1(2016,2017);4(2016,2017);22 will process years 2016 and 2017 for measure group 1, years 2016 and 2017 for measure group 4, and all years for measure group 22. All years will be processed if you do not use the (YearValue) part of the parameter. |
Optional Parameters |
Purpose |
Required? |
Parameters for overriding properties specified in the Batch Process tab of the Parameters window of Stratum.Connector for Viewer. · /MailFrom:FromEmailAddress · /MailTo:ToEmailAddress · /MailSubject:EmailSubjectText · /MailBody:EmailBodyText · /MailSmtpServer:SmtpServer |
The parameters control the email that is sent after each batch process. The email notifies recipients that a process occurred and includes the process log file. | No - By default, email properties will be controlled by settings in the Batch Process tab of the Parameter Settings window in Stratum.Connector for Viewer. Only use these parameters if you want to override the settings in that window. If you use the /MailTo: parameter and specify multiple email addresses, use semi-colons to separate the addresses. If any values for the Mail parameters contain spaces, you will need to enclose the parameter and its values in double quotes. For example: “/MailSubject: Full Nightly Process” |
/LogVerbosity:LogVerbosityEnum |
Controls the level of detail for the information written to the processing log. 0 – Minimal 1 – Normal 2 – Diagnostic Setting 2 – Diagnostic is recommended. |
No - By default, this log file setting is controlled by a setting in the General tab of the Parameter Settings window of Stratum.Connector for Viewer. Only use this parameter if you want to override the setting in that window. |
Your batch command will need to reference the path to and name of the Silvon.Connector.exe file. For example, C:\Program Files\Silvon Software\Stratum Connector for Viewer\Silvon.Connector.exe\.
Example |
Description |
C:\Program Files\Silvon Software\Stratum Connector for Viewer\Silvon.Connector.exe /batch /ProcessType:4 |
Runs a Limited process. |
C:\Program Files\Silvon Software\Stratum Connector for Viewer\Silvon.Connector.exe /batch /ProcessType:5 /ProcessBy:1 |
Runs a Trickle process for all years for measure group 1. |
C:\Program Files\Silvon Software\Stratum Connector for Viewer\Silvon.Connector.exe /batch /ProcessType:5 /ProcessBy:3(2016);5(2015,2016) |
Runs a Trickle process for year 2016 of measure group 3 and years 2015 and 2016 of measure group 5. Note: Specifying a specific year is only supported if you are running Enterprise Edition of Analysis Services. |