Pro SQL Server 2012 Reporting Services

CHAPTER 12  DELIVERING BUSINESS INTELLIGENCE WITH SSRS

• Using the graphical MDX query builder that was added with SQL Server Reporting
  Services 2005

Setting Up the Analysis Services Data Source

With the Pro_SSRS project open, navigate to the Reports folder, and open the Average Referral to

Admission report. Next, open the Report Data window. Right-click the Patient_Referral dataset and

select the Query option from the submenu list. Notice that the query recognizes that you are using an

OLAP data source with MDX and brings up the graphical MDX query designer. As you can see, it is very

different from the T-SQL query window that we have used when accessing queries throughout the book.

If you select filter expression and choose to filter on 2010, 2011, and 2012, you should see results similar

to those shown in Figure 12-5. There are two datasets contained in this report, Patient_Referral and

DateofAdmissionYear.

Figure 12-5. Viewing the Patient_Referral for the Average Referrals to Admission report

The type of data source for both datasets is Microsoft SQL Server Analysis Services. If your Analysis

Services instance is not on the local machine that you are connected to, you will need to change the data

source server from localhost, defaulted in the report, or the default to your SSAS server name. You can