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.
The Query Wizard - Choose Columns dialog appears, as partially shown in Illustration 5.
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.
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.
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.
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.
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.