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.)
Click the Get
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.
Query starts, and
presents the Choose Data Source dialog.
Click the OLAP
dialog box appears a shown in Illustration 4.
highlight <New Data Source>.
following into Box 1 of the dialog.
Offline Cube 1
OLE DB Provider for OLAP Services 8.0 in Box 2.
New Data Source dialog appears as shown in Illustration 5.
Illustration 5: The
Create New Data Source Dialog
Click the Connect...
Connection dialog appears.
the Analysis Server radio button is selected as the location of
the multidimensional data source.
In the Server
text box, type the name of the server, as shown in Illustration 6.
Illustration 6: The
Multidimensional Connection Dialog
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.