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 5

By William Pearson

16.  Supply authentication information if required.

17.  Click Next

The second Multidimensional Connection 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 depicted in Illustration 7.

Click for larger image

Illustration 7: Select the FoodMart 2000 Database

18.  Click Finish.

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

19.  Select the Warehouse and Sales sample cube in Box 4.

The options available for selection will depend upon which cubes are present in the database. The FoodMart 2000 sample database supplies several other cubes, any of which could be selected here as a data source.

After selecting the Warehouse and Sales cube, the Create New Data Source dialog should resemble that shown in Illustration 8.

Illustration 8: The Completed Create New Data Source Dialog

20.  Click OK.

We return to the Choose Data Source dialog.

21.  Ensuring that the Offline Cube 1 data source is selected, click OK to return to the Step 2 of 3 dialog, where we left off with the PivotTable and PivotChart Wizard.

We return to the Step 2 of 3 dialog. We note, as depicted in Illustration 9, that "Data fields have been retrieved" now appears to the right of the Get Data button.

Illustration 9: Data Fields Have Been Retrieved ...

22.  Click Finish.

An empty PivotTable report appears, with PivotTable Field List in front, as shown in Illustration 10, allowing us to begin designing the PivotTable report we need, as a basis for creating our local cube, immediately.

Illustration 10: An Empty PivotTable Report Appears

The PivotTable Field List acts, effectively, to "prove" our connection to the data source (as it displays the dimensions and measures of same), in addition to providing all we need for report design. The PivotTable toolbar, if not yet apparent, can be "called" by going to View --> Toolbars --> PivotTable from the main menu.

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