Dimension Wizard - Select Levels

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

  1. Under Available columns, click the columns you want to use. Use the buttons provided to move columns to the list under Dimension 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).

  2. Use the Move Level Up and Move Level Down buttons to arrange your levels in the order you want.
  3. Click Next.

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.


(c) 1988-1998 Microsoft Corporation. All Rights Reserved.