Infrastructure

Kepion SQL Standard Support

Kepion supports SQL Standard edition. However, there are a few differences in functionality between SQL Standard and SQL Enterprise. We will explore below what those differences mean when designing applications in Kepion. Feature Name Enterprise Edition Business Intelligence Edition Standard Edition Semi-additive Measures Yes Yes No Hierarchies Yes Yes … Read More

Deploy Application through SQL Agent Job

When you need to schedule a cube deployment or deploy the cube after data loading, SQL Agent Job is the tool to use. Here is how the job step should be configured in SQL Agent Job. Here is the code.  You just need to change the <DatabaseID> to your … Read More

Add Script to Kepion Default Web Page

You can enter a custom script to the Kepion default webpage (e.g. set up Google Analytics tracking) by using the Web Page->HEAD module.  Include your script by typing into the HEAD text box and click Save.  For example: Once saved, you can hit F5 to reload the page in IE.  … 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

Azure + SQL Server Performance Best Practice

A recent article by Jason Roth from Microsoft details out the best practices for hosting Azure + SQL Server.  Following the recommendations below can help the performance characteristics of any Kepion implementation on Azure.  For the full article, click here. Quick Checklist The following is a quick check list … Read More