dcsimg

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

June 21, 2004

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








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers