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. … Read More
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
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!
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
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: Auto Close: this will cause the execution window to close on … Read More
Build Enterprise BI & CPM solutions within minutes with Kepion Modeler.