The Select the Dimensions for the Virtual Cube dialog
- Select all dimensions (from the Available
Dimensions list) by clicking the double arrow ">>".
As we saw earlier, selection can also be made by highlighting and
clicking the single arrow ">" to move an individual dimension to the Selected
Dimensions list. Double-clicking individual dimensions achieves the same
The Select the
Dimensions for the Virtual Cube dialog appears as shown below, after our
Illustration 21: The Selected Dimensions List
- Click Next.
The Finish the Virtual Cube Wizard dialog appears,
signaling that we are near end of the processing cycle.
- Name the virtual cube Operations.
- Ensuring that the Process Now radio button is
selected once again, click Finish.
The cube again processes successfully in short
order, and the Process dialog indicates successful completion.
- Close the Process dialog.
We are returned to the Virtual Cube Editor,
where we note the appearance of our new virtual cube's structure, as depicted
in Illustration 22.
Illustration 22: The New Virtual Cube Appears
Our cube contains only the measures that we wish to
be accessible to the Operations information consumers. We have
succeeded in generating a fully functional "view" of the data, complete with
all dimensions and the measures that we deemed appropriate, while securing the
information that we sought to restrict. All that remains is to create two
security roles for the Operations and Corporate groups, and to
assign the Operations role to this cube, and the Corporate role
to the original, unrestricted cube. We have augmented physical and other
security through the use of a virtual cube that is quite simple to create, once
the requirements and restrictions for the component roles is understood.
- Close the Virtual Cube Editor.
Page 9: Working with Calculated Members in a Virtual Cube