Kepion Support
- Total activity 953
- Last activity
- Member since
- Following 0 users
- Followed by 3 users
- Votes 63
- Subscriptions 470
Articles
Votes on activity by Kepion Support Sort by votes-
Convert Database between SQL Versions
Introduction In this article, we will show you how to restore a backup database from a higher/newer version of SQL Server. While the example below restores a SQL Server 2017 database to a SQL Serve...
Process OLAP Database with SQL Agent Job
The Modeler allows you to process Application objects (e.g., databases, cubes, partitions, and Dimensions) through the UI when needed. If a process task needs to be scheduled, we can use a SQL Agen...
MDX Training - Basics I
Multidimensional Expressions (MDX) is a language for querying and scripting cube data in SSAS Databases. Cubes provide access to aggregated data through MDX. Just as a table is organized by columns...
Configure Multiple Fiscal Calendars
By default, Kepion comes configured with two calendar definitions: Annual and Fiscal. While the Annual Calendar definition always begins on January 1st and ends on December 31st, the Fiscal Calenda...
Session 2 - Identifying Dimensions
Overview In this session, you will identify the dimensions and hierarchies driving the forms we defined. This process is broken down into three steps: Create a list of potential dimensions. Dete...
Part 9 - Data Rules
Introduction In part 9 of the Modeler Tutorial, let's create two Data Rules (Calculate OPEX and Calculate Net Income) to calculate the values in the Reporting Model. Kepion's Data Rule Editor simpl...
Become a Kepion certified professional
Overview To become a Kepion Certified Professional, you must successfully complete the Kepion Certification Exam. But before you attempt the exam, we strongly recommend you go through the prerequis...
Part 2 - Dimensions
Introduction In part 2 of the Modeler Tutorial, we'll create the fundamental building blocks of our Application: Dimensions. Dimensions are tables used to organize and filter data. For example, a G...
Create and Manage Key Performance Indicators (KPI)
Introduction Forms allow you to create and manage Key Performance Indicators (KPI). Simply go to the Form Editor in the Modeler and right-click the cell where you would like to define the KPI. ...
Determine Dashboard Size
Introduction When designing a Dashboard, the first decision you need to make is its size. A poorly sized Dashboard can, for example, lead to excessive scrollbars within one page. Our target is to m...