Introduction to MSSQL Server 2000 Analysis Services: Introduction to Local Cubes - Page 4

May 17, 2004

(The Warehouse and Sales cube is one of several great training cubes that are installed with a Typical installation of MSSQL 2000 Analysis Services. While virtually all the documentation and training material available these days seems to focus on the Sales cube, I have found the "undiscovered" cubes to hold value in many specialized instances.)

7.  Click the Get Data button.

If this is the first time we have accessed Microsoft Query (which the button attempts to launch) we may be informed, via a message box, that MS Query has not been installed. If this is the case, we are presented the option of installing it - an option that we must take to complete this exercise. If applicable, give consent to the installation, which occurs relatively rapidly, then rejoin the exercise at this point.

Microsoft Query starts, and presents the Choose Data Source dialog.

8.  Click the OLAP Cubes tab.

The dialog box appears a shown in Illustration 4.

Click for larger image

Illustration 4: The Choose Data Source Dialog

9.  Click and highlight <New Data Source>.

10.  Click OK.

11.  Type the following into Box 1 of the dialog.

Offline Cube 1

12.  Select Microsoft OLE DB Provider for OLAP Services 8.0 in Box 2.

The Create New Data Source dialog appears as shown in Illustration 5.

Illustration 5: The Create New Data Source Dialog

13.  Click the Connect... button.

The Multidimensional Connection dialog appears.

14.  Ensure that the Analysis Server radio button is selected as the location of the multidimensional data source.

15.  In the Server text box, type the name of the server, as shown in Illustration 6.

Illustration 6: The Multidimensional Connection Dialog

In the illustration above, I supplied MOTHER1 (the name of the server I used for preparing this article) in the Server box. The name localhost can be supplied if Excel and the cube share the same server machine.