Hierarchy Properties

This dialog box is displayed when you view the properties of a hierarchy in a multidimensional model.

A hierarchy is a way to organize data at different levels of aggregation. Hierarchies are used to define data aggregation; for example, in a Time dimension, a hierarchy might be used to aggregate data from days to months to quarters to years. Hierarchies are also used to define a navigational drill path. In a relational table, hierarchies can be defined as part of a dimension object.

For more information about working with multidimensional data, see Oracle OLAP User's Guide and the online help for Analytic Workspace Manager.

General

Name: Name of the hierarchy.

Value Based Hierarchy: Controls whether this is a value-based hierarchy, that is, a hierarchy defined only by the parent-child relationships among dimension members. The dimension members at a particular distance from the base level do not form a meaningful group for analysis, so the levels are not named.

Time Based Hierarchy: Controls whether this is a time-based hierarchy, that is, a hierarchy composed of time-related levels such as Month, Quarter, and Year.

Ragged Hierarchy: Controls whether this is a ragged hierarchy, that is, a hierarchy in which leaf nodes can be located at different levels.

Default Hierarchy: Controls whether this is the default hierarchy for the dimension.

Levels

Lists levels associated with the hierarchy. To view or edit a level definition, double-click its item. (See also Level Properties.)

Rollup Links

Lists rollup links associated with the hierarchy. To view or edit a rollup link definition, double-click its item. (See also Rollup Link Properties.)

Oracle Names

Short Name: Short descriptive name that can be used by applications instead of the long name.

Long Name: Long descriptive name, typically used for display.

Plural Name: Plural name (for reporting purposes). For example: Myhierarchies if the Short Name is Myhierarchy

Description

Description of the hierarchy.

Comments, Notes, Responsible Parties, Documents, Summary

See Common Information in Dialog Boxes.