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