Home > Data Modeler Dialog Boxes > 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