Analysis Services
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.
- Columns in a single table. This option creates a regular 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.