Name
CREATE/DROP DIMENSION
Synopsis
CREATE Syntax:
CREATE [FORCE | NOFORCE] DIMENSION [schema.]dimensionLEVELlevelIS {level_ table.level_column|(level_ table.level_column,table_name_ table_name.level_column...) } HIERARCHYhierarchy(child_levelCHILD OFparent_level) [JOIN KEY {child_key_column| (child_key_column,child_key_column...)} REFERENCESparent_level] | ATTRIBUTElevelDETERMINES {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: ...