Skip Headers
Previous
Previous
 
Next
Next

Create/Edit Cube Dimension: Hierarchies

Hierarchies identify the parent-child relationships among dimension members. For example, in a Time calendar hierarchy, a year is the parent of four quarters, and a quarter is the parent of three months. Hierarchies are used for aggregating and selecting data.

Hierarchies are usually based on levels (level-based), but may be based just on the parent-child relationships (value-based).

Hierarchies

Lists the defined hierarchies.

add icon

Click the Add icon to add a new hierarchy.

delete icon

Click the Delete icon to delete the selected hierarchy.

Click a value to edit it.

Default: Identifies the default hierarchy for querying cubes with this dimension. This option is selected automatically for the first hierarchy that you create. For a dimension with multiple hierarchies, select the hierarchy that will be used most frequently for analysis.

Name: The object names of hierarchies defined for this dimension. When you add a hierarchy, it appears with a default name, labels, and description.

Short Label: A short descriptive name for display where space is limited, which can contain mixed case, spaces, and symbols.

Long Label: A long descriptive name for display, which can contain mixed case, spaces, and symbols.

Description: Additional descriptive text, which can contain mixed case, spaces, and symbols.

Hierarchy Properties

These properties identify characteristics of the data. If the data does not conform to the specified characteristics, errors may occur when the data is loaded into the cube.

Type: Select the hierarchy type appropriate for the dimension:

Data Constraints: Select the type of constraint appropriate for your data:

Available Levels: Displays a list of all levels defined for the dimension but not selected for this level-based hierarchy. Use the shuttle keys to move selected levels between Available Levels and Selected Levels.

Selected Levels: Displays a list of the levels selected for this level-based hierarchy. This list must be ordered from the highest level of aggregation to the lowest level of aggregation. A hierarchy can have a maximum of 126 levels.

To reorder the list, select a level and use the arrows to move it up or down.

The following is an example of correctly ordered levels for a Calendar hierarchy:

YEAR
  QUARTER
  MONTH
  DAY

Related Topics

"About Hierarchies"

"Creating Hierarchies"