The Select the
dimension with the member properties dialog appears. We are given a choice
of "eligible" dimensions - that is, dimensions that the Wizard
determines to possess member properties, upon which a virtual
dimension is based.
8.
Click Store
in the Available Dimensions list on the left side of the dialog.
The Member Properties list
on the right side of the dialog becomes populated with the "eligible"
member properties for the Store dimension (including the new Store City member property we added in the
previous section of our exercise), as depicted in Illustration 19.
9.
Click Next.
10. Select Store Name.Store City in the Available member properties
list, in the left half of the Select the levels for the virtual dimension
dialog that appears next.
11. Click the ">"
button to add the Store Name.Store City member property to the Selected
virtual levels list on the right side of the dialog.
The Selected virtual
levels list on the right side of the dialog becomes populated with the Store
City member property we added earlier, as shown in Illustration 20.
Illustration 19: Adding Store City as
a Virtual Dimension Level
We will skip setting
advanced options in the Select advanced options dialog that appears
next, as depicted in Illustration 21.
Illustration 21: Select
Advanced Options Dialog
The Finish the
Dimension Wizard dialog appears next.
14. Type the following into the Dimension
name box:
Store Location
The Finish the
Dimension Wizard dialog appears as shown in Illustration 22.
Illustration 22: Our
Title in the Finish the Dimension Wizard Dialog
The Dimension Wizard closes,
and we return to the Cube Editor, where we see our new virtual
dimension, Store Location, among the other dimensions in the tree, as
depicted in Illustration 23.
Illustration 23: The
Store Location Virtual Dimension Joins the Other Dimensions ...
(We can
also see it in the Shared Dimensions folder for the Analysis Services
database, as we accepted default to share the dimension in the Finish
dialog above).
» 
Comment and Contribute
