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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

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

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