Alter Dimension

ALTER DIMENSION

Alter a dimension (data warehouse parent-child relationship.)

Syntax:

   ALTER DIMENSION [schema.]dimension ADD level_clause(s) 
      ADD [heirarchy_clause(s) ADD attribute_clause(s)];

   ALTER DIMENSION [schema.]dimension COMPILE;

   ALTER DIMENSION [schema.]dimension
      DROP LEVEL level [RESTRICT|CASCADE];

   ALTER DIMENSION [schema.]dimension
      DROP HEIRARCHY heirarchy;

   ALTER DIMENSION [schema.]dimension
      DROP ATTRIBUTE attribute;

Multiple drop statements can be combined in a single command
e.g. ALTER DIMENSION... DROP ATTRIBUTE... , DROP DIMENSION...;

level_clause:
   LEVEL level IS (table.column,...)

heirarchy_clause:
   HEIRARCHY heirarchy (child_level CHILD OF parent_level,... [join_clause])

attribute_clause:
   ATTRIBUTE level DETERMINES (dependent_column,...)

join_clause:
   JOIN KEY (child_key_column,...) REFERENCES parent_level

"If you don't ask the right questions, you don't get the right answers. A question asked in the right way often points to its own answer" - Edward Hodnett

Related Commands:

DIMENSION - CREATE DIMENSION
DIMENSION - DROP DIMENSION
MVIEW - CREATE MATERIALIZED VIEW
DBMS_UTILITY - Compile pl/sql package

Simon Sheppard
SS64.com