OWNER

VARCHAR2(30)

NOT NULL

Owner of the dimension.

DIMENSION_NAME

VARCHAR2(30)

NOT NULL

Name of the dimension.

HIERARCHY_NAME

VARCHAR2(30)

NOT NULL

Name of the hierarchy.

DISPLAY_NAME

VARCHAR2(30)

Display name for the hierarchy.

DESCRIPTION

VARCHAR2(2000)

Description of the hierarchy.

SOLVED_CODE

VARCHAR2(2)

NOT NULL

The solved code may be one of the following:

UNSOLVED LEVEL-BASED, for a hierarchy that contains no embedded totals and is stored in a level-based dimension table.

SOLVED LEVEL-BASED, for a hierarchy that contains embedded totals, has a grouping ID, and is stored in a level-based dimension table.

SOLVED VALUE-BASED, for a hierarchy that contains embedded totals for all level combinations and is stored in a parent-child dimension table.

For information about mapping hierarchies with different solved codes, see "Joining Fact Tables with Dimension Tables".