MSAS: Virtual Dimensions Page - 4

If the Select the dimension type step appears, select the dimension type. If you select Time dimension:

• In the Date column box, select the column that will be parsed to create the levels of the virtual dimension. 
• Click Next. 
• In the Select time levels box, select the levels for the virtual dimension. 
• (Optional.) In the Day and Month boxes, select the starting date of the year. 
• Click Next.

If you select Standard dimension, click Next.

If the Select the levels for your dimension step appears, select the levels for the virtual dimension:

For each level you want to define, beginning with the top level, in the Available columns box, select the column that defines the level, and then click >. Click Next.

If the Specify the member key columns step appears, select member key columns for one or more of the levels. Click Next.

In the Select advanced options step, choose any advanced options that may apply, and then click Next. Depending on the advanced options you select, other dialog boxes may appear.

In the Set Changing property step, select Changing. A virtual dimension must be a changing dimension. Click Next

If the Specify ordering and uniqueness step appears, for each level, in the Order by column, select the value that determines the order by which the level's members are displayed to end users. Also, for each level, in the Keys unique and Names unique columns, specify the scope of uniqueness among the member keys and member names, respectively. Click Next.

If the Specify storage mode and create member groups step appears, specify a storage mode. If you select MOLAP, indicate whether to create member groups in a level inserted automatically above the dimension's lowest level. Click Next.

In the Finish step:

• In the Dimension name box, type a name up to 24 characters long. 
• If the virtual dimension will be private, clear the Share this dimension with other cubes check box. (This check box is not displayed if you are following the procedure for a shared virtual dimension.)
• Click Finish.

In the editor tree pane, select the newly created virtual dimension.

If the properties pane is not expanded, expand it by clicking Properties beneath the tree pane.
In the properties pane, click the Advanced tab.

Click the Depends on Dimension property, and in the drop-down list click the dimension that supplies the columns for the virtual dimension.

Click the Virtual property, and in the drop-down list click True.

On the File menu, click Save.

In this tutorial we have seen how to set advanced properties for dimensions. In the next tutorial we shall create cubes out of dimensions and work with measures and study their importance in cubes.