The option “Discard user formula” allows submissions to automatically discard user entered formulas upon workflow save. This feature can be useful when managing multiple users who are inputting on the same slice of data. By automatically discarding formulas on save, it avoids formulas from being inconsistent between the users.
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
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
Build Enterprise BI & CPM solutions within minutes with Kepion Modeler.