Avatar

Kepion Support

  • Total activity 924
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 3 users
  • Votes 63
  • Subscriptions 454

Articles

Votes on activity by Kepion Support Sort by votes Recent activity 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...