Introduction
SQL rules enable you to deploy or process OLAP databases. Let's take a look at where you can configure these options with SQL rules in the Modeler module.
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 many 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 be an application admin or system admin 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 must 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.