Reporting Services - Professional SQL Server Analysis Services 2005 with MDX - page 894

based on that (like sales per region.) There is much to like about the integra-
tion between Reporting Services and Analysis Services in this SQL Server
2005; report building directly off a UDM, for one, is awesome.
Designing Your Analysis Services Report
In this section you create a sales report from the UDM for AdventureWork-
s2005Tutorial using the Report Wizard. You later refine the report based on
certain requirements surprisingly imposed by your boss at the last moment.
At the end of this section you will be familiar with creating specialized reports
on a UDM. The following steps will help you to build reports from Analysis
Services by establishing a connection to Analysis Services, building the MDX
query, and previewing the report. Follow the steps to create your Analysis
Services reports:
1. Open the AdventureWorks2005Tutorial under Chapter 17 and deploy
it to your Analysis Services instance.
2. Right-click the Reports folder and select Add New Item. Select the
Report Wizard and click the Add button. If a Welcome to the Report
Wizard page appears, click Next.
3. The first step in the Report Wizard is to provide the connection de-
tails to the data source. In the Data Source Wizard select the Mi-
crosoft SQL Server Analysis Services option for data source type, as
shown in Figure 17-12 . Then click Edit.