702

CREATE DIMENSION [ schema. ] dimension
level_clause ...
{ hierarchy_clause
| attribute_clause
| extended_attribute_clause
}...
;

level_clause ::=
LEVEL level IS
{ level_table.level_column
| (level_table.level_column
[, level_table.level_column ]...
)
}
hierarchy_clause ::=
HIERARCHY hierarchy
(child_level { CHILD OF parent_level }...
[ dimension_join_clause ]
)
dimension_join_clause ::=
{ JOIN KEY
{ child_key_column
| (child_key_column [, child_key_column ]...)
}
REFERENCES parent_level
}...
attribute_clause ::=
ATTRIBUTE level DETERMINES
{ dependent_column
| ( dependent_column
[, dependent_column ]... )
}
extended_attribute_clause::=
ATTRIBUTE attribute
{ LEVEL level
DETERMINES { dependent_column
| (dependent_column [, dependent_column ]... )
}
}...