Advanced Modeling

Performance Tuning for Huge Writeback Partition

Too many records in writeback partition will impact both form and rule performance. When you have a huge writeback partition, the first thing we recommend is try to archive historic planning data to a MOLAP partition. If all records are active, we are going to apply the following method. … Read More

Power BI and Value Attributes

When connecting to Kepion cubes from Power BI, you may notice attributes ending with a “value”.  Some of the “value” attributes are necessary, as they may relate to the Time dimension.  However, for most dimensions, the “value” attributes may seem extraneous. To remove the “value” attributes, go into Modeler … Read More

Improve Performance by Configuring Partition Mode and Interval

If you have a partition storing more than 20 million rows or over 250 MB in size, you can configure partition mode and partition interval setting in PERFORMANCE tab of the partition to improve performance. You can choose to partition the data by a certain “criteria” and by a certain … Read More

Using Import and Export in Migration

Import and export are very useful when migrating changes from development to production.  This article covers a few critical perspectives of using import and export during the migration process. How to manage dimension MemberIDs? Have any new dimension members been created in DEV? §  If so, these members may have a … Read More

Import and Export Functionality

Import and export functionality is supported in multiple areas within Kepion Modeler. Dimension Data New members will be added. Attributes of existing members (with the same MemberId) will be updated. Partition Data Can choose to append to existing or override existing at import Form Can export/import multiple forms in the … Read More