Defining a parent-child hierarchy

In IBM® Cognos® Cube Designer, you can model commonly used parent-child hierarchies at the project level and reference them in one or more dynamic cubes. You can also model parent-child hierarchies within a specific dynamic cube.

Procedure

  1. Select the location from which you want create the parent-child hierarchy:
    • To create a shared parent-child hierarchy at the project level, select Model from the Project Explorer tree.
    • To create a parent-child hierarchy that this automatically linked to a dynamic cube, select the cube from the Project Explorer tree.

      The parent-child hierarchy is also shared at the project level.

  2. Click New Parent-Child Dimension new parent child hierarchy icon.

    A new parent-child dimension is created with a parent-child hierarchy.

  3. Edit the dimension properties in the parent-child Properties pane.
  4. Open the parent-child hierarchy editor.
  5. From the Project Explorer tree, drag table columns to the Attribute column to create the hierarchy attributes.
  6. Select the attributes assigned to the Parent key and Child key.

    These attributes are mandatory.

  7. Select the attributes assigned to the Member Caption, and Member Description.

    The Member Caption attribute is mandatory.

  8. If required, specify the member sort order. For more information, see Defining the member sort order.
  9. Complete the parent-child hierarchy definition using parent-child hierarchy editor Properties pane.
  10. If required, edit the properties of the attributes using the attribute editor Properties pane.