Getting Started FAQ

Author: Ian Britz

If you're new to Kepion, you probably have many questions. Refer to this FAQ to find answers to the common questions we get from new users. 

 

 

Why is Kepion running slowly?

Many factors impact the performance of a Kepion Application. To name just a few: 

 

• Hardware specifications
• Amount of data and how it's been stored
• Rule and Form configuration

 

Take a look at our Performance Tuning Guide for helpful tips for optimizing an Application, and review the technical specifications to make sure your hardware meets the minimum requirements.

 

 

Why isn't my App on the Apps page?

The two most common reasons are:

 

• You haven't been added as a contributor to the App
• The App has expired

 

 

Why can't I turn my Application online?

If this happens after migrating an Application from another environment, it may be a version mismatch issue. Another possible cause is that the Application no longer exists in the database, or has been renamed. Try accessing the SQL Server through SQL Server Management Studio (SSMS) and confirm that the Application you're trying to bring online still exists in the database.

 

 

How do I request new features?

Feedback and feature requests from partners and customers help us determine what to prioritize for the future. The best place to submit a feature request is our community forum. All submissions are public, so you can peruse what others have suggested and vote on the features you'd like us to prioritize. If the feature request is related to a specific business use case or contains otherwise sensitive information, you can request one through a support ticket.

 

 

Why is my cell not "inputtable?"

The reasons could include:

 

• A Dimension Member is not on the lowest level.
• You don't have permission to write to the Dimension or Model.
• The App has been locked.
• The App has write restrictions enabled.
• A cell attribute has disallowed input.
• The Form has been set to read-only.

 

Take a look at this guide to diagnose and resolve your issue. 

 

 

Why does my text input disappear when I post?

You likely need to turn on the Query includes annotation and text cells option under the Advanced Settings in a Form.

 

 

How do I change default cell colors?

You can configure this under the Advanced Settings tab in your Forms. Disable colors using the checkboxes, or click the color boxes to change the colors.

 

 

 

How do I change the icon for my app?

You can configure this in the Dashboard Editor, under the Settings tab.

 

 

What's the difference between View and Action Rules?

View Rules generate SQL Views, which are virtual tables. Views are dynamic and update automatically as the data changes.

 

Action Rules are updated on demand, and allow you to INSERT or DELETE the records in a partition. Action Rules are typically preferred when the resulting values need to be referenced in other rules.

 

 

When should I use SQL vs MDX?

Kepion uses a SQL Database and an OLAP Database for each Application. The SQL database holds all of the data and configurations for the Application, while the OLAP Database contains OLAP Cubes, which are aggregations of the data.

 

To put it simply: 

 

When you want to manipulate table data, use SQL.

When you want to manipulate data in the cube, use MDX.

 

Note: SQL is highly preferred when possible, as MDX tends to imping one performance.

 

 

How do I get access to sample Applications?

Submit a support request and we'll get you set up with the necessary permissions.

 

 

My question isn't answered in the Support Center

Leave a comment below or submit a support request!