Defining a hierarchy

In IBM® Cognos® Cube Designer, a single level-based hierarchy is automatically added when you create a dimension. You can also create multiple level-based hierarchies in a dimension.

Procedure

  1. From the Project Explorer tree, select the dimension you want to work with.
    • To create a new hierarchy, click New Hierarchy New Hierarchy icon.
    • To access the hierarchy editor, right-click a hierarchy that belongs to the dimension and select Open Editor.
  2. Complete or modify the hierarchy definition using the Properties tab. Identify the Default Member and Root Caption if required.
  3. Set the Show Extraneous Padding Members and Caption of Padding Members if required.

    For more information, see Padding members.

  4. If an All level is not required, set the Multiple Root Members property to true.
  5. To add levels to the hierarchy, drag levels from the Levels folder to the hierarchy.