Model hierarchies
IBM® Cognos® Dynamic Cubes supports level-based hierarchies and parent-child hierarchies. A single level-based hierarchy is automatically added when you create a dimension. You can also create multiple level-based hierarchies in a dimension.
For more information, see Dimensions and Hierarchies.
Complete the hierarchy definition using the properties listed in the following table:
| Property | Description |
|---|---|
| Name | The hierarchy name shown in the IBM Cognos studios. If the project supports multiple locales, there can be versions of the name in all supported languages. |
| Comment | A comment or description of the hierarchy. Comments are not visible in the IBM Cognos studios. |
| Multiple root members | False (default) - the hierarchy uses a single root member at the top of the hierarchy. Selecting this option creates the All level at the top of the hierarchy. You can change the default caption of the top level by editing the Root Caption property. True - the hierarchy contains multiple root members. Selecting this option deletes the All level that is automatically created at the top of the hierarchy. If a hierarchy is single root, Cognos Cube Designer generates the root member. Because all members must belong to a level, the root member is in the All level. |
| Add Relative Time Members | False (default) - If the hierarchy belongs to a Time dimension, relative time members are not added to the hierarchy. True - If the hierarchy belongs to a Time dimension, relative time members are added to the hierarchy. For more information, see Defining a relative time dimension. |
| Default Member | The member value to use when evaluating member expressions, where no value is specified for a hierarchy. If the default member is empty, the root member of the hierarchy is used. To set a default member, drag the required member from the Members folder in the Project Explorer tree. |
| Root Caption | The caption of the root member at the top of the hierarchy shown in the IBM Cognos studios. If the project supports multiple locales, there can be versions of the caption in all supported languages. |
| Parent-Child | False - Indicates that the hierarchy does not use a parent-child structure. This property cannot be edited. |
| Show Extraneous Padding Members | False (default) - collapse multiple paths of padding members under a single member into a single path. True - show multiple paths of padding members for a single member. For more information, see Extraneous padding members. Important: Padding members are not supported for DMR modeling.
|
| Caption of Padding Members | The caption to use for padding members in the hierarchy. Empty (default) - use a Null caption. Parent's caption - use the caption of the parent. For more information, see Padding members. Important: Padding members are not supported for DMR modeling.
|