Hierarchies (PDM)

A hierarchy defines a path for navigating through the attributes in a dimension when drilling down or rolling up through the data. For example, a time dimension with the attributes Year, Quarter, Month, Week, Day may have a default hierarchy listing all these periods in order and a second hierarchy which includes only Year, Month, and Week.

Creating a Hierarchy

You can create a hierarchy from the property sheet of, or in the Browser under, a dimension.
  • Open the Attributes tab in the property sheet of a dimension, select the attributes you want to include in your dimension and then click the Create Hierarchy tool.

  • Open the Hierarchies tab in the property sheet of a dimension, click the Add a Row tool, then click the Properties tool and add your attributes manually.

  • Right-click a dimension in the Browser, and select New > Hierarchy.

Hierarchy Properties

To view or edit a hierarchy's properties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.

The General tab contains the following properties:

Property

Description

Name/Code/Comment

Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field.

Stereotype

Extends the semantics of the object. You can enter a stereotype directly in this field, or add stereotypes to the list by specifying them in an extension file.

Dimension

Specifies the parent dimension of the hierarchy.

Keywords

Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas.

The following tabs are also available: