Select Levels (Dimension Wizard)
In this step of the wizard, you can define certain columns as levels in your dimension. The columns you can use appear under Available columns.
This wizard step appears only if you selected Star Schema: A single dimension table, Snowflake Schema: Multiple, related dimension tables, or Mining Model: A predictable column of an OLAP mining model in the second step of the wizard.
Note Your levels must appear in hierarchical order beginning with the most general level of detail. For example, a Geography dimension would be ordered World (All), Continents, Countries, Cities.
Options
Available columns
Click the columns you want to use in your dimension. Use the arrow keys to move selected columns to the dimension levels pane.
Dimension levels
View the levels that will be generated based on the columns selected in Available columns. Use the arrow keys to remove unwanted levels or to change their order.
Count level members automatically
Counts the members of the selected level in Available dimensions. This is required for cube processing. It may take some time to process levels with a large number of members. To speed up the dimension creation process, clear the Count level members automatically check box.
Note If automatic counting of level members is turned off, you must manually enter an estimated number for levels using the Dimension Editor properties pane or respond to individual prompts during cube processing.