Business Intelligence Tutorial
In this exercise, you will create a hierarchy in the Markets
dimension.
- 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.
- 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.
- 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.
- 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:

- Click Next and the Preview Hierarchies page is
displayed.
[ Top of Page | Previous Page | Next Page | Table of Contents ]