Using Script Extensions from Content

Scripts can be associated to content and its processing steps.

E.g. a SQL script can be run before or after a dimension tree is processed. An XMLA script can be run after an SSAS database is processed.

Data Source tables, Dimensions and Modules has a [Script Extensions] tab.

To add a new script, you must first select an existing script in the overview list at the right side. By default local scripts (e.g. scripts added to a dimension) are listed. Click on [Load All Solution Scripts] to get all of the scripts in the solution.

 

PS6_ScriptExtensions_Part1_SalesEx.PNG

 

After a script is selected, double click the script or click the [Add] button. A new section with the script is then added, and you have to select when to run the script and optionally what sub type to run on (see Using XMLA Script). 
You can set the script association to be 'Enabled' and 'Stop on error' to checked/unchecked.

For Data Source Tables you attach scripts to run before or after processing (or before/after a specified reload method).

For Dimensions, you can only associate SQL scripts to run before or after processing.



See also:

Using XMLA Script