(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.
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.
» 
Comment and Contribute
