Business Rules

Process or Deploy OLAP database in SQL Rule

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 database: Same as Process action in SSAS. … Read More

Process MOLAP Partition in SQL Rule

MOLAP partition is ideal to store static data. It offers excellent performance because the data is pre-loaded when the cube is built. However, unlike ROLAP partition, MOLAP partition doesn’t display real time data from the database unless we perform a process action. Therefore, when we update data in any … Read More

Data Spread Demo

With the help of the capability to run rules on selected cell, we can now perform data spread, allocation, and adjustment easily in the form.  Check out this demo video!  

Run Rules on Selected Cells

Users can now run complex business rules on any selected data cells from a form.  A popular scenario that uses this functionality is allocating data at different levels of aggregation.  Here, in our sample application we illustrate the use for this case.  In the application, we provide two methods to allocate data: Set a … Read More

Dashboard Rule Component

You can configure one or more SQL rules to run independently on a dashboard by using the Dashboard Rule Component. Each dashboard rule component can be associated with its own action button, SQL rule and execution behavior.  The configurable behaviors include: Rule: you can select from all the SQL rules … Read More