Create the Report File
the Report File is straightforward, and handled through the following
the Reports folder in Solutions Explorer.
from the context menu that appears.
New Item from the cascading menu, as shown in Illustration 20.
New Item dialog appears.
in the Add New Item dialog.
following into the Name box, leaving other settings at default:
New Item dialog appears, as shown in Illustration 21.
Click the Open
button at the bottom of the Add New Item dialog.
design environment opens. We see the Data, Layout and Preview
tabs appear. Our report has opened in Data View, as shown in Illustration
Illustration 22: The
Design Environment - Data View Tab (Compacted)
design environment that we see is known as Report Designer. We will
construct a very basic OLAP report at this point, primarily to illustrate the
use of the components that we assembled in MSAS. For more detail on the Report
Designer environment, or on Reporting Services in general, see my MSSQL
Server 2000 Reporting Services
series at Database
Create the Data Connection
Our next step is to set
up a Data Connection, from which we create a Dataset within our
Dataset in the Dataset selector at the top of the Data tab,
as depicted in Illustration 23.
Illustration 23: Select
New Dataset in the Dataset Selector - Data Tab
As soon as we click the New Dataset selection, the Data
Link Properties dialog box appears, defaulted to the Connection tab.
Click the Provider
tab to select the appropriate provider for our data source.
OLE DB Provider for OLAP Services on the Provider tab, as shown in Illustration
Illustration 24: Select Microsoft
OLE DB Provider for OLAP Services on the Provider Tab
to move to the Connection tab.
Type the name
of the computer housing the targeted MSAS database, FoodMart 2000, in
the Data Source box near the top of the Connection tab.
appropriate security information / settings (I am using Windows NT
Integrated security for this lesson in my own environment).
2000 in the initial catalog box at the bottom of the tab.
Click the Test
Connection button to verify connectivity to the data source.
receive a message box, indicating a successful test connection, as depicted in Illustration
Illustration 25: We Test
Positive for Connectivity
settings on the Connection tab of the Data Link Properties dialog
should resemble those shown in Illustration 26.
Illustration 26: Data
Link Properties Dialog - Connection Tab
to accept the settings we have made, and to close the Data Link Properties
presents us with the dataset design tool, based upon our newly connected
source. We are immediately positioned to design our dataset query, which
brings us to the next step.