Creating a Dimension with Unbalanced Hierarchies

In this exercise, you will use the following input file to create a dimension with unbalanced hierarchies.

TOTAL,NORTH,TK1,G1
TOTAL,NORTH,TK1,G2
TOTAL,NORTH,TK1,G3
TOTAL,NORTH,TK1,G4
TOTAL,NORTH,TK2,G5
TOTAL,NORTH,TK2,G6
TOTAL,SOUTH,TK3,G7
TOTAL,SOUTH,TK3,G8
TOTAL,SOUTH,TK3,G9
TOTAL,SOUTH,TK4,G10
TOTAL,SOUTH,TK4,G11
TOTAL,SOUTH,TK4,G12
TOTAL,TK5,G13
TOTAL,TK5,G14
TOTAL,TK6,G15
TOTAL,TK6,G16
TOTAL,TK6,G17
TOTAL,G18
TOTAL,G19

The final result will look like this:

image of a cascading dimension listing with n-level items and consolidtions

To begin creating the dimension:

Procedure

  1. In the left pane of the Server Explorer, right-click the Processes icon and select Create New Process.

    The TurboIntegrator window opens.

  2. Select the Text Data Source Type.
  3. Click Browse next to the Data Source Name field and select unbalanced.csv in your TI_data directory.
  4. Leave all other options on the Data Source tab at their default settings.
  5. Click Preview to view the first ten records in the data source.