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 Apr 7, 2003

Reporting Options for Analysis Services Cubes: MS Excel 2002 - Page 3

By William Pearson

Connecting Excel to the Cube

The PivotTable Wizard walks us through a guided process for connecting Excel 2002 to a given Analysis Services cube. We begin by taking the following steps:

1.      Open a new Excel 2002 workbook.

2.      Click Data (top menu), then select PivotTable and PivotChart Report, to initialize the PivotTable and PivotChart Wizard, as shown below:

Illustration 1: Menu Item for Initializing the PivotTable / PivotChart Wizard

The Step 1 of 3 Wizard dialog appears.

3.      Select the External Data Source radio button, as shown in the following illustration:

Illustration 2: The Step 1 0f 3 Wizard Dialog

  1. Ensuring that the "kind of report" selection is set to "PivotTable," click Next.

The Step 2 of 3 dialog appears, as shown below:

Illustration 3: The Step 2 0f 3 Wizard Dialog

Here we specify the source of our data. For this tutorial, we will use the sample OLAP cube called Sales.

5.      Click the Get Data button.

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

6.      Click the OLAP Cubes tab.

The dialog box appears as shown in Illustration 4 below.

Illustration 4: The Choose Data Source Dialog

7.      Click and highlight <New Data Source>.

8.      Click OK.

9.      Type Sales Cube in Box 1.

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

The Create New Data Source dialog appears as shown below.

Illustration 5: The Create New Data Source Dialog

11.  Click the Connect... button.

The Multidimensional Connection dialog appears.

12.  Ensure that the Analysis server radio button is selected as the location of the multidimensional data source we wish to access.

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