Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted May 17, 2004

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

By William Pearson

(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.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM