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 3

By William Pearson

Creating a Virtual Cube to Consolidate Information

One of the main reasons for creating a virtual cube is to compare values that exist within two OLAP databases against each other. We will create a virtual cube that accomplishes this and also effectively demonstrates the general steps of design and creation.

Our example will involve the Sales and Budget cubes, both of which are installed as sample with a Typical MSSQL Server 2000 Analysis Services installation. As one might conclude from the names, the Sales cube houses actual sales data, while the Budget cube contains budgeted values for many of the corresponding accounts. The primary objective in creating our first virtual cube will be to provide information consumers a means of comparing actual and budget values, in our case expense values.

  1. Start Analysis Manager, then expand the Analysis Server name (shown below as MOTHER) to see the underlying databases as shown below:

Illustration 1: Expand the Analysis Server

  1. Expand the FoodMart 2000 database to see the underlying folders as displayed in Illustration 2:

Illustration 2: Expand the FoodMart 2000 Database

  1. Right-click the Cubes folder.
  2. Click New Virtual Cube on the context menu, as shown below.

Illustration 3: Select New Virtual Cube

The Virtual Cube Wizard Welcome Dialog appears as shown in Illustration 4.

Illustration 4: The Virtual Cube Wizard Welcome Dialog

  1. Click Next.

Page 4: Creating a Virtual Cube (Continued)

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