Dimension Wizard

Use this wizard to create dimensions for your cubes.

The Dimension Wizard appears when you perform any of the following actions:

• In the Cube Wizard, in the Select dimensions step, click New Dimension.
  
  
• In Cube Editor, on the Insert menu, point to Dimension, and then click New.
  
  
• In the Analysis Manager tree pane, right-click the Shared Dimensions folder, point to New Dimension, and then click Wizard. If you start the Dimension Wizard in this way, you cannot create a private dimension.

The Dimension Wizard has the following steps:

• Choose how to create the dimension. You can create it from:
  • Columns in a single table. This option creates a regular dimension.
    
    
  • Columns in multiple tables. This option creates a regular dimension.
    
    
  • Two hierarchically related columns. This option creates a parent-child dimension.
    
    
  • Member properties. This option creates a virtual dimension.
    
    
  • The predictable column of an OLAP mining model. This option creates a data mining dimension.
• Select the table or tables for your dimension. This step is displayed only if you are creating a regular or parent-child dimension.
  
  
• Select the dimension type: standard or time. This step is displayed only if you are creating a regular dimension and the dimension table contains a datetime column.
  
  
• Create time dimension levels. This step is displayed only if you are creating a regular time dimension.
  
  
• Edit joins. This step is displayed only if you are creating a regular dimension from multiple tables.
  
  
• Select the levels for your dimension. This step is displayed only if you are creating a regular, non-time dimension.
  
  
• Specify the member key columns. This step is displayed only if you are creating a regular, non-time dimension.
  
  
• Select the columns for a parent-child dimension. This step is displayed only if you are creating a parent-child dimension.
  
  
• Select the dimension with the member properties. This step is displayed only if you are creating a virtual dimension.
  
  
• Select the levels for the virtual dimension. This step is displayed only if you are creating a virtual dimension.
  
  
• Select advanced options for your dimension. This step does not appear if you are creating a data mining dimension.
  
  
• Confirm if you want to create a changing dimension. This step is displayed only if you selected this as an advanced option.
  
  
• Enable and define custom rollup expressions. This step is displayed only if you selected this as an advanced option.
  
  
• Specify how members are ordered and uniquely named. This step is displayed only if you selected this as an advanced option.
  
  
• Specify the storage mode and automatically create member groups. This step is displayed only if you selected this as an advanced option.
  
  
• Enable writeback capability. This step is displayed only if you are creating a parent-child dimension and you selected this as an advanced option.
  
  
• Select an OLAP mining model and predictable column. This step is displayed only if you are creating a dimension from an OLAP mining model.
  
  
• Finish. Name your dimension and preview its data.

See Also

Dimensions