Introduction to SQL Server 2000 Analysis Services: Exploring Virtual Cubes - Page 8

December 11, 2002

The Select the Dimensions for the Virtual Cube dialog appears.

  1. 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 result.

The Select the Dimensions for the Virtual Cube dialog appears as shown below, after our additions.

Illustration 21: The Selected Dimensions List

  1. Click Next.

The Finish the Virtual Cube Wizard dialog appears, signaling that we are near end of the processing cycle.

  1. Name the virtual cube Operations.
  2. 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.

  1. 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.

  1. Close the Virtual Cube Editor.

Page 9: Working with Calculated Members in a Virtual Cube