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

May 17, 2004

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.