Business Intelligence Tutorial

Creating hierarchies

In this exercise, you will create a hierarchy in the Markets dimension.

  1. Select the Market dimension in the field on the left side of the Define Hierarchy page and click Add Hierarchy. The Add Hierarchy window is displayed.
  2. In the Name field, type Region-City exactly as shown here (without spaces) and click Done. Notice that columns in the Market dimension are now displayed in the Dimension Columns field on Define Hierarchy page.
  3. Select the Region column in the Dimension Columns field and click the right arrow button. The Region column is added to the Parent/Child Relationship field.
  4. Select the City column in the Dimension Columns field and click the right arrow button. The City column is displayed as a child of Region column in the Parent/Child Relationship field. The window looks like this:
    Define Hierarchy page
  5. Click Next and the Preview Hierarchies page is displayed.


[ Top of Page | Previous Page | Next Page | Table of Contents ]