Oracle in a Nutshell

Name

CREATE/DROP DIMENSION

Synopsis

CREATE Syntax:

CREATE [FORCE | NOFORCE] DIMENSION [schema.]dimension
LEVEL level IS 
  { level_ table.level_column 
  |(level_ table.level_column, table_name 
                     _ table_name.level_column ...)
  }
HIERARCHY hierarchy (child_level CHILD OF parent_level)
[JOIN KEY {child_key_column | (child_key_column,child_key_column ...)}
  REFERENCES parent_level] |
ATTRIBUTE level DETERMINES 
  { dependent_column 
  |(dependent_column, dependent_column ...)
  }

DROP Syntax:

DROP DIMENSION [schema.]dimension

Creates or removes a dimension, which defines a parent-child relationship between pairs of column sets. New with Oracle9i.

Keywords

FORCE

Specifies that the dimension be created, even if the referenced tables do not exist.

NOFORCE

Specifies that the dimension be created only if the referenced objects exist. This is the default.

dimension

Name of the dimension.

LEVEL

Defines a level with a name that defines dimension hierarchies and attributes.

level_table.level_column

Specifies the columns (up to 32) for the level.

HIERARCHY

Specifies the name of a hierarchy.

child_level

Name of a level that has an n-to-1 relationship with a parent level.

CHILD OF

Specifies the name of a parent level.

JOIN KEY

Specifies the name of a column in the JOIN condition with a parent table.

REFERENCES

Specifies the name of the parent level.

ATTRIBUTE

Specifies the name of a level or hierarchy.

DETERMINES dependent_column

Specifies the name of a column that is dependent on an attribute level.

Common keywords and clauses: ...