Process or Deploy OLAP database in SQL Rule
By Joyce Zhou - Jun 08, 2017
In a Kepion SQL rule, there are multiple options available to update OLAP database.
In PROCESS tab, there is a Process OLAP database option.
In ADVANCED tab, modeler can choose to deploy security, deploy to OLAP, or deploy selected cubes.
- Process OLAP databases: Same as Process action in SSAS. 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 lot of dimensions/hierarchies and MOLAP partitions, we recommend using this action instead of processing each hierarchy and partition one by one. This is because the former processes objects in parallel, whereas the latter, in sequence. Please note, users need to have application administrator and/or model designer privilege 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 user dashboard.
- Deploy to OLAP: Same as the deploy action in Modeler. If you need to run any deployment script in the rule, you can use this action. Please note, users need to have application administrator and/or model designer privilege 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, application variables are used in MDX rule, and the application variables get updated in the SQL rule, then you may need to process the cube in order to update the application variable values in the cube.