Creating a parent-child hierarchy

If your model requires multiple hierarchies, you can create additional parent-child hierarchies. When you create a dimension, a parent-child hierarchy is created automatically. This hierarchy is used as the default hierarchy.

To create a parent-child hierarchy:

  1. To edit the properties of a dimension, right-click the dimension in the tree and select Properties.
  2. Click the Hierarchies tab.
  3. Click Create Hierarchy on the toolbar and select Parent Child Hierarchy from the menu.
    The Parent Child Hierarchy dialog opens.
  4. Specify this information:
    Name
    Specify the name of the parent-child hierarchy.
    Description
    Specify a description for the parent-child hierarchy.
    Default member
    Specify the element that is used as default element for the hierarchy. Each hierarchy has a default member. If not explicitly selected or defined, the default member is the first element in the top level of the hierarchy. Applications selects this element automatically.
  5. To save the hierarchy, click OK.
    The new hierarchy is displayed in the list.
  6. Select the default hierarchy from the Default Hierarchy drop-down list.
    This selection is only relevant if you create multiple hierarchies. The default hierarchy cannot be deleted.
  7. To save the dimension properties, click OK.