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
» Sitemap
Free Newsletters:

By submitting your information, you agree that databasejournal.com may send you databasejournal offers via email, phone and text message, as well as email offers about other products and services that databasejournal believes may be of interest to you. databasejournal will process your information in accordance with the Quinstreet Privacy Policy.

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jun 21, 2004

Introduction to MSSQL Server 2000 Analysis Services: Another Approach to Local Cube Design and Creation - Page 4

By William Pearson

9.  Select the tables listed below, from the Available Tables and Columns box on the left, by selecting each and clicking the > button, to move the respective columns to the right.

  • product
  • product class
  • region
  • sales_fact_1998
  • store
  • time_by_day

The Query Wizard - Choose Columns dialog appears, as partially shown in Illustration 5.

Illustration 5: The Query Wizard - Choose Columns Dialog (Partial View)

While we would probably expand each table and select the specific columns we needed for our cube, in a real-world scenario, we have selected each of the tables in its entirety at this point, to make the process quicker for our lesson.

10.  Click Next.

The Query Wizard - Filter Data dialog appears, as shown in Illustration 6.

Illustration 6: The Query Wizard - Filter Data Dialog

We will simply click Next to skip this step, again noting the importance of filtering the data in a real-world scenario, to keep cube size minimal when the relational data source is large.

11.  Click Next.

The Query Wizard - Sort Order dialog appears, as shown in Illustration 7.

Illustration 7: The Query Wizard - Sort Order Dialog

Again, we will pass on sorting the data; we will not be working with the end product in this lesson. This, too, would likely be handled differently in most business environments.

12.  Click Next.

The Query Wizard - Finish dialog appears.

13.  Click Save Query, and name the query LocalCubeRelational, placing it in a convenient directory (I accepted the default).

The Save As dialog resembles that depicted in Illustration 8.

Illustration 8: Saving the Underlying Relational Query

14.  Click Save.

We are returned to the Query Wizard - Finish dialog.

15.  Click the Create an OLAP Cube from this Query radio button to select it.

The Query Wizard - Finish dialog appears, as shown in Illustration 9.

Illustration 9: The Query Wizard - Finish Dialog

16.  Click Finish.

The colorful Welcome dialog of the OLAP Cube Wizard is launched, based upon our selection in the Finish dialog. It appears as shown in Illustration 10, awaiting instructions as to how we want it to create the cube, for which we have established a source definition in MS Query.

Illustration 10: The OLAP Cube Wizard Welcome Dialog Appears

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