Submit a request

Data Overview

Avatar
Kepion Support
  • Updated

Introduction

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. 

 

DataNodes.png

 

 

Data Node

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. 

 

DataNavigation.png

 

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.

 

Columns

Column Function
Partition Name of partition
Records Number of records
Annotate Check to enable annotations for the partition's records
Disabled Check to disable the partition

 

Actions

Add

1. Select Add. 

 

ActionAddPartition.png

 

2. Configure the partition:

 

Name: Desired name of partition.

Measure Group: Target Measure Group.

Storage Mode: ROLAP or MOLAP.

 

AddPartition.png

 

Tip: Learn more about Measure Groups and Storage Modes here. 

 

3. Select Save to add partition. 

 

Remove

1. Select the checkbox(es) of the target partitions and click Remove. 

 

Remove.png

 

2. Select OK to confirm removal. 

 

RemoveOK.png

 

 

Partitions

You can view and manage the data in each partition by selecting the partition from the left navigation:

 

Partition.png

 

You should land on the Data tab: 

 

PartitionData.png

 

Data 

The Data tab shows the partition's records in a data table.

 

Actions

You can also take various actions to manage your data: 

 

Action Function
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. 

 

Filter

You can filter columns on the data table to narrow down the displayed results. 

 

1. Hover over the target column and select Filter.svg (Filter symbol). 

 

FilterColumn.png

 

2. Select the Members to be displayed in the data table and click OK. 

 

FilterSelection.png

 

You can remove all Filters at once by selecting the icon in the top left of the data table. 

 

EraseFilters.png

 

Settings

The Settings tab provides options to adjust the partition and boost performance. 

 

SettingsTab.png

 

Data Management

Field Function
Storage Mode Select ROLAP or MOLAP
Table or View Select Edit.svg to change the data sourc
Notification Table Select Edit.svg to change the data source for the partition's notifications
Description Enter a description of the partition

 

Performance

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. 

Related articles