Dimension Split

Owned by Migration
Last updated: Nov 21, 2014 by Andy Heller (Deactivated)
3 min read

Introduction

A Dimension Split is a concept used for Free Models that allows you to split an OLAP dimension into two or more CXO-Cockpit dimensions. Typical examples of dimensions that need to be split are:

  • A Period dimension that contains both periodic and accumulated members. CXO-Cockpit requires a separate View dimension, so this dimension should be split into Period and View.
  • A Time dimension that contains years and months. CXO-Cockpit requires a separate Year dimension, so this dimension should be split into Period and Year.

CONTENT

The second example is illustrated in the following figure:

Set up a Dimension Split

In order to set up a valid Dimension Split you will have to complete 4 steps

  1. Create a new dimension split based on a dimension of the source system
  2. Add the destination dimensions
  3. Split the source members to target members of each destination dimension
  4. Map the destination dimensions to valid CXO-Cockpit dimensions

Create a Dimension Split

The Dimension Splits can be opened through the System Settings in the Design Studio. In the dimension split /wiki/spaces/CXO53/pages/19727119 you can simply add a new dimension split. Specify the source dimension you would like to split.

Setup Destination Dimensions

You can add the destination dimensions. Typically these are 2 dimensions, but it is also possible to split to more then 2 dimensions.

Split the Members

Every source member can now be split to a member of the destination dimensions. You can decide to leave certain members unsplit, but once you specify a new member, you will need to split this member for any combination with the other dimension. For example: If you split 2008 for all period members, and you want to split 2009.Jan as well, you will have to split all period members for 2009 as well.

Map the split dimensions to CXO-Cockpit dimensions

Once a dimension is correctly split it can be mapped. In the example above the Time.H1 dimension was split to Year and Period. In the screenshot below you can see how the Year is mapped to the CXO-Cockpit dimension YER and Period is mapped to PER. Read more about mapping in the Dimension Mapping article.