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 6

By William Pearson

Making Modifications to Virtual Cubes

Even though there is no schema tab in the Virtual Cube Editor, we can modify virtual cubes readily. Let's illustrate with a change to our new cube.

  1. Right-click the Budget vs Actual cube.
  2. Select Edit from the context menu, as shown in Illustration 13.

Illustration 13: Select Edit from the Context Menu

The Virtual Cube Editor again appears, as shown.

Illustration 14: The Virtual Cube Editor (Compressed View)

Even though we have returned to the Virtual Cube Editor, we see that no means of structural modification is apparent at this juncture, because of the missing schema tab. Although a bit confusing in its redundancy, we again select the virtual cube, and get to the Edit feature (this time, it returns us to the Virtual Cube Wizard) via a right-click.

  1. Right-click the Budget vs Actual cube, from the present position within the Virtual Cube Editor.
  2. Select Edit Structure (Wizard) from the context menu, as shown in Illustration 15.

Illustration 15: Select Edit Structure (Wizard) from the Context Menu

The Virtual Cube Wizard again appears, with the dialog shown.

Illustration 16: The Return of the Virtual Cube Wizard

  1. Click Next.

We arrive at the Select Measures ... dialog once more.

  1. Select the Sales Count measure for addition to the virtual cube.
  2. Modify the Sales Count measure name to read Units Sold, as shown below:

Illustration 17: Our New Measure, with Modified Name, Appears

  1. Click Next.
  2. Click Next.
  3. Ensuring that the Process Now radio button is selected once again, click Finish.

The cube again processes successfully in short order.

  1. Close the Process dialog.

We are returned to the Virtual Cube Editor, where we note the appearance of the new Units Sold measure, as depicted in Illustration 18.

Illustration 18: The New Measure Appears in the Cube Tree

  1. Select File -> Exit to close the Virtual Cube Editor.

We have designed and processed a virtual cube to consolidate the information found in two separate cubes. Let's examine the creation of a virtual cube for what may seem to be the exact opposite reason: to remove dimensions and/or measures from a cube for purposes of limiting the information available to a given set of information consumers.

Page 7: Creating a Virtual Cube to Control Presentation and Augment Security

MS SQL Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



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