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.
The default setting in this step allows for members of a selected level to be counted. 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. If automatic counting of level members is turned off, you must manually enter an estimated number for levels using the Properties pane in the Dimension editor or respond to individual prompts during cube processing.
For more information about dimension levels, see Defining Dimensions.
To select levels
To add a column to the list, click the column, and then click “>“ (Add).
To remove a level from the list, click the level, and then click “<“ (Remove).
To add all displayed columns to your list, click “>>“ (Add All).
To remove all levels from your list, click “<<“ (Remove All).
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.