Standard Form Levels - OLAP

Levels are the basis of dimension hierarchies. A level belongs to one or more hierarchies. These objects support level definitions:

  • Levellist dimension
  • Member_levelrel relation
  • Member_familyrel relation

Levellist Dimension

A levellist dimension stores the names of all levels for all hierarchies defined for a particular dimension. The information is acquired from the OLAP Catalog. This text dimension typically has the name dimdef_LEVELLIST.

Contents of a Levellist Dimension

Example shows the CUSTOMER levellist dimension in GLOBAL, which contains the levels for both the SHIPMENTS and MARKET_SEGMENT hierarchies.

CUSTOMER Levellist Dimension in GLOBAL

Properties of a Levellist Dimension

Table describes the properties of a levellist dimension.

Levellist Dimension Properties

Levellist Dimension Properties

Member_Levelrel Relation

A member_levelrel relation identifies the level of each dimension member. It facilitates the selection of dimension members by level. The information is acquired from the relational fact tables. This text dimension typically has the name dimdef_LEVELREL.

Contents of a Level Relation

Example shows the CUSTOMER member_levelrel relation in GLOBAL.

CUSTOMER Member_Levelrel Relation in GLOBAL

Properties of a Member_Levelrel Relation

Table describes the OLAP DML properties of a member_levelrel relation.

Member_Levelrel Relation Properties

Member_Levelrel Relation Properties

Member_Familyrel Relation

Member_familyrel relations improve the performance of views for Oracle Discoverer. It provides a crosstab with the full parentage of each dimension member within a single row. The standard name for a family relation is dimdef_FAMILYREL.

Contents of a Family Relation

Example shows the CUSTOMER family relation in GLOBAL.

CUSTOMER Family Relation in GLOBAL

Properties of a Member_Familyrel Relation

Table describes the OLAP DML properties of a member_familyrel relation.

Standard Form Metadata for Levels

Standard form metadata for levels is stored in these objects:

  • ALL_LEVELS dimension
  • ALL_DESCRIPTIONS variable
  • DIM_LEVELS valueset

Member_Familyrel Relation Properties

Member_Familyrel Relation Properties

ALL_LEVELS Dimension

The ALL_LEVELS dimension contains the names of all levels in this format:

workspace.dimension.level.LEVEL

For example: GLOBAL_AW.TIME.Quarter.LEVEL

ALL_LEVELS is a base dimension of the ALL_OBJECTS concat dimension.
ALL_OBJECTS dimensions ALL_DESCRIPTIONS and AW_NAMES.
ALL_DESCRIPTIONS provides values for the levels, but AW_NAMES does not.

ALL_DESCRIPTIONS Variable for Levels

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

DIM_LEVELS Valueset

The DIM_LEVELS valueset identifies the levels defined for each dimension.


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

OLAP Topics