ALTER DIMENSION

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

Syntax:

   ALTER DIMENSION [schema.]dimension ADD level_clause(s) 
      ADD [hierarchy_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 hierarchy;

   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,…)

hierarchy_clause:
   HIERARCHY 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 Oracle Commands:

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

Related Views:

DBA_DEPENDENCIES     ALL_DEPENDENCIES     USER_DEPENDENCIES