Kepion Support
- Total activity 779
- Last activity
- Member since
- Following 0 users
- Followed by 3 users
- Votes 63
- Subscriptions 365
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...
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...
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...
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. ...
MDX Training - Basics III
In this tutorial (part III of our MDX training series), we will cover calculations/operations. In MDX, we can define basic calculations using simple operators (+, -, *, /): [Account].[Account].[S...
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...
Session 3 - Identifying Models, Rules, and Apps
Overview In this session, we’ll walk-through the final three steps of our Architecture Design process. First, we'll determine how many Models to build. Then we’ll define the Rules we need to config...
Introduction to Training Videos
Overview Welcome to the Kepion Training Video Series. In this series, we'll walk-through the steps to build a sample Revenue Planning Application together. We'll also explore all of the key compone...
Part 5 - Forms II
Introduction In part 5 of our Modeler Tutorial, let's move on to creating the Forms for the Expense and Reporting Models. Operating Expense Form The Operating Expense Form tracks costs relate...