Standard Form Hierarchies - OLAP

The following objects support dimension hierarchies:

  • Hierlist dimension
  • Member_parentrel relation
  • Member_gid variable
  • Member_inhier variable

The values of the member_parentrel relation, member_gid variable, and member_inhier variable can be different for different hierarchies, so the hierlist dimension is used to define these objects.

Hierlist Dimension

A hierlist dimension stores the names of the hierarchies defined for a particular dimension. The names of the hierarchies are acquired from the OLAP Catalog. This text dimension typically has a name of dimdef_HIERLIST.

Contents of a Hierlist Dimension

Example shows the contents of CUSTOMER_HIERLIST in the GLOBAL analytic workspace.

Example GLOBAL Hierlist Dimension for CUSTOMER

Properties of a Hierlist Dimension

Table describes the OLAP DML properties of a hierlist dimension.

Hierlist Dimension Properties

Hierlist Dimension Properties

Member_Parentrel Relation

A member_parentrel relation defines the hierarchical relationship among dimension members by identifying the parent of each member. This relation provides the essential hierarchical support for the dimension. This information is acquired from the relational dimension table. The parent relation is named dimdef_PARENTREL.

Contents of a Member_Parentrel Relation

A member_parentrel relation is a type of self-relation, in which the only valid values are dimension members. Example shows the member_parentrel relation for the CHANNEL dimension in the GLOBAL analytic workspace. The relation defines a two-level hierarchy in which 1 is the parent of 2, 3, and 4.

CHANNEL Member_Parentrel Relation in GLOBAL

Properties of a Member_Parentrel Relation

Table describes the OLAP DML properties of a member_parentrel relation.

Member_Parentrel Relation Properties

Member_Parentrel Relation Properties

Member_Gid Variable

Member_gid variables improve the performance of views for the OLAP API. This integer variable identifies the depth in the hierarchy of each dimension member. This information is generated by the GROUPINGID command in the OLAP DML; refer to its entry in the Oracle OLAP DML Reference for information about its contents. The standard name for a member_gid variable is dimdef_GID.

Contents of a Member_GID Variable

Example shows the member_gid variable for the CHANNEL dimension in the GLOBAL analytic workspace. It shows that channels 2, 3, and 4 are at the base level (0) and channel 1 is one level deep (1).

CHANNEL Member_Gid in Global

Properties of a Member_Gid Variable

Table describes the OLAP DML properties of a member_gid variable.

Member_Inhier Variable

Member_inhier variables are used to improve the performance of views for the OLAP API. This Boolean variable identifies whether a dimension member belongs to a level that is included in a particular hierarchy. The information is acquired from the OLAP Catalog metadata, and typically is useful only for dimensions with multiple hierarchies. The standard name for a member_inhier variable is dimension_INHIER.

Member_GID Variable Properties

Member_GID Variable Properties

Contents of a Member_Inhier Variable

Example shows the contents of the member_inhier variable for the CUSTOMER dimension of the GLOBAL analytic workspace. YES indicates that the dimension member is in the hierarchy; NA indicates that it is not in the hierarchy.

CUSTOMER Member_Inhier Variable in GLOBAL

Properties of a Member_Inhier Variable

Table describes the OLAP DML properties of a member_inhier variable.

Member_Inhier Variable Properties

Member_Inhier Variable Properties

Standard Form Metadata for Hierarchies

Standard form metadata for hierarchies is stored in these objects:

  • ALL_HIERARCHIES dimension
  • ALL_DESCRIPTIONS variable
  • DIM_HIERARCHIES valueset
  • DEFAULT_HIER relation

ALL_HIERARCHIES Dimension

The ALL_HIERARCHIES dimension contains the names of all hierarchies in this format:

workspace.dimension.hierarchy.HIERARCHY

For example: GLOBAL_AW.CUSTOMER.SHIPMENTS.HIERARCHY
ALL_HIERARCHIES is a base dimension of the ALL_OBJECTS concat dimension.
ALL_OBJECTS dimensions ALL_DESCRIPTIONS and AW_NAMES.
ALL_DESCRIPTIONS provides values for the hierarchies, but AW_NAMES does not.

ALL_DESCRIPTIONS Variable for Hierarchies

The ALL_DESCRIPTIONS variable contains short, long, and plural names for the hierarchies. All objects have a short name acquired from the metadata, but may or may not have long and plural names.

DIM_HIERARCHIES Valueset

The DIM_HIERARCHIES valueset identifies the hierarchies defined for each dimension.

DEFAULT_HIER Relation

The DEFAULT_HIER relation identifies the default hierarchy for each dimension.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

OLAP Topics