The Select the Dimensions for the Virtual Cube dialog
appears.
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
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.
Add databasejournal.com to your favorites Add databasejournal.com to your browser search box IE 7 | Firefox 2.0 | Firefox 1.5.xReceive news via our XML/RSS feed
IE 7
Firefox 2.0