Introduction
In a SQL Rule, there are multiple options available to update the OLAP Database. Let's take a look at where you can configure these options in the Modeler.
Options
In the Process tab of a SQL Rule, there is a Process OLAP database option.
In the Advanced tab, you can choose to Deploy Security, Deploy to OLAP, or deploy selected cubes in the Deploy MDX section.
- Process OLAP database: Same as the Process action in the SSAS server. It processes all Data Partitions, Dimensions, and Hierarchies in the Application so that all data will be up-to-date. When the rule updates a large number of Dimensions/Hierarchies and MOLAP partitions, we recommend using this action instead of processing each hierarchy and partition individually. This is because the former processes objects in parallel, whereas the latter does so in sequence.
Note: Users need to have Application Administrator and/or Model Designer privileges in order to trigger this action.
- Deploy Security: Use this action if the Rule updates any security table (e.g., Permissions, Member access, Model access, etc.) and the changes need to be up-to-date in the user's Dashboard.
- Deploy to OLAP: Same as the Deploy action in the Modeler. If you need to run any deployment script in the Rule, use this action.
Note: Users need to have Application Administrator and/or Model Designer privileges in order to trigger this action.
- Deploy selected cubes: This action is used to ensure the MDX script within the Model is updated. For example, when Application Variables are used in an MDX Rule and updated in the SQL Rule, you may need to process the cube in order to update the Application Variable values.