Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Dec 11, 2002

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

By William Pearson

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

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM