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 application. Any of those process types also can be initiated by including the Stratum.Connector 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 was originally installed.
Keep in mind these requirements when using the parameters:
Specify the main parameters in the order of /batch /ProcessType:
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, “/CubeLockedEmailBody: Here is the Connector log for the most recent Limited process”.
If you use any of the EmailToAddress parameters and specify multiple email addresses, use semi-colons to separate the addresses. For example, if you use the /CubeLockedEmailToAddress 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 Emails Parameters |
Purpose |
Required? |
This set of parameters and the next three sets are for overriding properties specified in the Emails tab of the Parameter Settings window of Stratum.Connector.
|
The parameters control the From address for the emails sent after each batch process and the server that manages the emails. |
No - By default, they are controlled from the Emails tab of the Parameter Settings window. Only use these parameters if you want to override the settings in that window. |
These parameters are for emails resulting from a completed process, where the cube is available after the process.
|
The email notifies recipients that a process completed and the cube is available. The email usually includes the process log file unless Connector was directed to exclude it. Valid values for the log file parameter are: 0 – Attach log file to email 1 – Do not attach log file |
No – See note above. If you use the EmailToAddress parameter and specify multiple email addresses, use semi-colons to separate the addresses. If any values for the Email parameters contain spaces, you will need to enclose the parameter and its values in double quotes. For example: “/CubeAvailableEmailSubject: Full Nightly Process Completed OK” |
These parameters are for emails resulting from a completed process, where the process locked the database.
|
The email notifies recipients that a process completed but it locked the database. The email usually includes the process log file unless Connector was directed to exclude it. Valid values for the log file parameter are: 0 – Attach log file to email 1 – Do not attach log file |
No – See first Emails note above. If you use the EmailToAddress parameter and specify multiple email addresses, use semi-colons to separate the addresses. If any values for the Email parameters contain spaces, you will need to enclose the parameter and its values in double quotes. For example: “/CubeLockedEmailSubject: Full Nightly Process Resulted In Locked Cube” |
These parameters are for emails about key errors that occurred during a process.
|
The email notifies recipients about the key error status for a process. The email usually includes the key errors log file unless Connector was directed to exclude it. Valid values for the log file parameter are: 0 – Attach log file to email 1 – Do not attach log file |
No – See first Emails note above. If you use the EmailToAddress parameter and specify multiple email addresses, use semi-colons to separate the addresses. If any values for the Email parameters contain spaces, you will need to enclose the parameter and its values in double quotes. For example: “/KeyErrorEmailSubject: Key Error Results” |
Optional Log Files Parameters |
Purpose |
Required? |
/LogVerbosity:LogVerbosityEnum |
Controls the level of detail for the information written to the processing log. 0 – Normal 1 – Debug Setting ‘0’ is recommended. |
No - By default, it is controlled from the Log Files tab of the Parameter Settings window. Only use this parameter if you want to override the setting in that window. |
/ProcessLogFolder:ProcessLogFolder |
Controls the location of the main log file for a batch process. |
No – See note above. |
/KeyErrorLogFolder:KeyErrorLogFolder |
Controls the location of the key error log file for a batch process. |
No - See first Log Files note above. |
/PostProcessTempFolder:PostProcessTempFolder |
Controls the location of the temporary text file created for the Post Process phase (MembersN table updates) of a batch process. |
No - See first Log Files note above. |
Optional Key Error Parameters |
Purpose |
Required? |
This parameter and the next one are for overriding properties specified in the Key Errors tab of the Parameter Settings window of Stratum.Connector. /StopProcessOnKeyErrors:StopProcessOnKeyErrorsEnum |
Determines if key errors will stop the batch process. Valid values are: 0 – Continue process on key errors 1 – Stop process on key errors |
No - By default, it is controlled from the Key Errors tab of the Parameter Settings window. Only use this parameter if you want to override the setting in that window. |
/KeyErrorLimit:KeyErrorLimit |
Determines how many key errors are permitted before batch processing will be stopped. Specify the limit value. This setting is only considered if the StopProcessOnKeyErrors parameter is set to 1. |
No – See note above. |
Optional General Parameters |
Purpose |
Required? |
This parameter and the next one are for overriding properties specified in the General tab of the Parameter Settings window of Stratum.Connector. /UseGroupBy:UseGroupByEnum |
Only applicable to a Full process. Determines if an aggregation is applied to the result set during processing. Valid values are: 0 – No, do not perform aggregation 1 – Yes, perform aggregation |
No - By default, it is controlled from the General tab of the Parameter Settings window. Only use this parameter if you want to override the setting in that window. |
/AddNewDimensions:AddNewDimensionsEnum |
Only applicable to a Full process. Determines if newly added dimensions will be selected for valid measure groups. Valid values are: 0 – Add newly added dimensions to measure groups 1 – Do not add newly added dimensions to measure groups |
No – See note above. |
Optional Planning Writeback Parameter For Trickle Processes |
Purpose |
Required? |
/ProcessWriteback:ProcessWritebackEnum |
This parameter only pertains to a process type 5 – Trickle process. Use it to direct a Trickle process type to process the Analysis Service’s Writeback Partitions for the specified measure group(s). 0 – No, do not process the Analysis Services Writeback Partitions. This is the default. 1 – Yes, do process the Analysis Services Writeback Partitions. |
No – If not used, a Trickle process won’t process the Analysis Services Writeback Partitions for the specified measure group(s). No is the default behavior for a Trickle process. Set the parameter to 1 if you want the Analysis Services Writeback Partitions for the specified measure group(s) to be processed. |
Data Import Parameter |
Purpose |
Required? |
/AddMissingMemberForUCD:AddMissingMembersForUserControlledData |
Determines if Connector will check user controlled data to determine if there are any missing Master File records. It there are, they will be automatically added to the appropriate Master Files. Applicable to all types of Connector processes and supports user controlled data functionality such as Stratum.Viewer’s Data Import. Valid values are: 0 – Do not check for missing Master File members 1 – Check for missing Master File members |
No - By default, it is controlled from the General tab of the Parameter Settings window. Only use this parameter if you want to override the setting in that window. If Data Import functionality is being used, make sure the parameter is selected in Connector or this batch command parameter is set to 1. |
Master Data Import Parameters |
Purpose |
Required? |
/LimitedProcessPendingUpdates:LimitedProcessUCAUpdatesEnum |
This parameter only pertains to a process type 4 – Limited. Use it to direct a Limited process to check for then process any pending changes related to User Controlled Attributes such as new or edited User Controlled Attributes. Valid values for LimitedProcessUCAUpdatesEnum are: 0 – No, do not process pending changes for User Controlled Attributes. 1 – Yes, process pending changes for User Controlled Attributes. |
No - By default, it is controlled from the General tab of the Parameter Settings window. Only use this parameter if you want to override the setting in that window. Only set this to Yes in situations where it is okay if the Limited 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). |
/StandardProcessPendingUpdates:StandardProcessUCAUpdatesEnum |
This parameter only pertains to a process type 1 – Standard. Use it to direct a Standard process to check for then process any pending changes related to User Controlled Attributes such as new or edited User Controlled Attributes. Valid values for StandardProcessUCAUpdatesEnum are: 0 – No, do not process pending changes for User Controlled Attributes. 1 – Yes, process pending changes for User Controlled Attributes. |
No - By default, it is controlled from the General tab of the Parameter Settings window. Only use this parameter if you want to override the setting in that window. Only set this to Yes in situations where it is okay if the 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). |
Discontinued Parameters |
Purpose |
Required? |
As of Version 6.8, the following parameters from prior versions of Connector are no longer valid:
|
N/A |
N/A – if you have batch processes that you set up prior to 6.8 that used these parameters and plan to use them for 6.8 processing, then adjust the email parameters based on the current applicable set noted earlier in this table. |
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. |