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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Apr 7, 2003

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

By William Pearson




13.  In the Server text box, type the name of the server, as shown below.





Illustration 6: The Multidimensional Connection Dialog

In the illustration above, I supplied MOTHER (the name of my server PC) into the Server box. Optionally, the name localhost can be supplied, if Excel and the cube share the same server, according to the Microsoft documentation.

14.  Click Next.

The Multidimensional Connection Select the database ... dialog appears, asking that we select the target database / OLAP Data Source. Here we will select the FoodMart 2000 database that accompanied the Analysis Server installation, as we see below.


Illustration 7: Select the FoodMart 2000 Database

15.  Click Finish.

The Create New Data Source dialog reappears, with the new target data source indicated to the right of the Connect... button.

16.  Select the Sales cube in Box 4.

The FoodMart 2000 sample database supplies several other cubes, any of which could be selected here as a data source.

After selecting the Sales cube, the Create New Data Source dialog should resemble the illustration below.


Illustration 8: The Completed Create New Data Source Dialog

17.  Click OK.

We return to the Choose Data Source dialog.

18.  Ensuring that the Sales Cube data source remains selected, (as shown in Illustration 9 below), click OK to return to the Step 2 of 3 dialog, where we left off with the PivotTable and PivotChart Wizard.


Illustration 9: Our Sales Cube Data Source is Selected

Once we return to the Step 2 of 3 dialog, notice, as in the illustration below, that "Data fields have been retrieved" now appears to the right of the Get Data button.


Illustration 10: Indication that Data Fields have been Retrieved

  1. Click Finish.

An empty PivotTable report appears, allowing us to begin browsing the cube / designing the report immediately. In addition to the PivotTable report template, the PivotTable toolbar and the PivotTable Field List appear; the PivotTable Field List provides a selection of report building components (we discuss these in the next section). The Analysis Server is now providing the dimension and measures information to the PivotTable report directly from the cube.



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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


















Thanks for your registration, follow us on our social networks to keep up-to-date