Defining a level

In IBM® Cognos® Cube Designer, you define levels to model the relationships in a hierarchy.

For each level, you assign or create attributes, map them to the relational data source, identify level keys and, optionally, define a sort order. You can also hide the attribute in the published package if required.

Procedure

  1. From the Project Explorer tree, select a dimension, and click New level new level icon.
  2. To access the level editor, right-click the level in the Project Explorer tree, and select Open Editor.
  3. To create an attribute, click New Attribute new attribute icon.
    Tip: To give the new attribute a more meaningful name, right-click it and select Rename.
  4. To map a table column to the new attribute, select the required column from the Data Source Explorer tree and drop it onto the Mapping column.
    Tip: You can also create attributes by dropping table columns to the Attribute column.
  5. Select the attributes assigned to Member Caption and, if required, Member Description.
    For more information about these special attributes, see Attributes.
  6. You can define the Level Unique Key one of two ways:
    • If the level unique key is a single attribute, select the Level Unique Key check box for the attribute.
    • If the level unique key is a composite key, click Level Key level key button. For more information, see Defining a level unique key.
  7. If required, specify the member sort order. For more information, see Defining the member sort order.
  8. To hide an attribute in the published package, change the Visible property to false.
  9. To assign the level to a hierarchy, select the level and drop it onto the hierarchy in the Project Explorer tree.
    Tip: You can also assign levels by dropping them into the hierarchy editor.
  10. Expand the hierarchy in the Project Explorer tree and, if necessary, modify the order of the levels as they appear under the hierarchy.