Kepion users can manage their actual and calculated data in the Data node in your Application's Models. In this overview, we will explain the data management functionality and options offered by Kepion's Modeler.
Each Model has a Data node, which you can access by expanding the Model and selecting Data. This page is a hub that allows you to manage all the data partitions within a Model.
By default, all Models have a Rule and a Writeback partition in the CoreMG Measure Group. The Rule partition stores only data generated by the Data Rule Editor; the Writeback Partition stores only data inputted to Forms.
|Partition||Name of partition|
|Records||Number of records|
|Annotate||Check to enable annotations for the partition's records|
|Disabled||Check to disable the partition|
1. Select Add.
2. Configure the partition:
Name: Desired name of partition.
Measure Group: Target Measure Group.
Storage Mode: ROLAP or MOLAP.
Tip: Learn more about Measure Groups and Storage Modes here.
3. Select Save to add partition.
1. Select the checkbox(es) of the target partitions and click Remove.
2. Select OK to confirm removal.
You can view and manage the data in each partition by selecting the partition from the left navigation:
You should land on the Data tab:
The Data tab shows the partition's records in a data table.
You can also take various actions to manage your data:
|Refresh||Refreshes the data table|
|Import||Import data via .csv files to the partition. Refer to this article for more information.|
|Export||Export data as .csv file|
|Delete||Delete the records currently displayed|
|Display||View the records by MemberId, Member Label, or Member Name|
|Show data errors||Enable to show only data errors|
Note: The Rule partition has only the Refresh, Export, and Display actions.
You can filter columns on the data table to narrow down the displayed results.
1. Hover over the target column and select (Filter symbol).
2. Select the Members to be displayed in the data table and click OK.
You can remove all Filters at once by selecting the icon in the top left of the data table.
The Settings tab provides options to adjust the partition and boost performance.
|Storage Mode||Select ROLAP or MOLAP|
|Table or View||Select to change the data sourc|
|Notification Table||Select to change the data source for the partition's notifications|
|Description||Enter a description of the partition|
The Performance section offers different options to boost performance depending on the partition's storage mode. Refer to our Performance Tuning Guide for more in-depth information on this section.