Advanced Modeling

How to Update Filter Selection in Saved User Apps?

When user first open/start a dashboard, form filters are initialized to the default members which are setup in the Modeler. Once that app is saved, all filter selections are saved and will be associated with that app going forward. The saved filter settings for an app are stored to … Read More

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