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.
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
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 ...
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.
» 
Comment and Contribute