07 April 2012

Data Warehouse - Creating Regular Dimensions

* Can be based on information in a star or snowflake schema
* Can be shared or private
* Use the Dimension Editor to create shared regular dimensions
* Use the Cube Editor to create private regular dimensions
* Regular dimensions contain the same number of levels as  the number of columns selected
* Levels are organized from most general to least general, e.g. State, City, Customer Name
* By default a top-level aggregate (All) is created