Pro SQL Server 2012 Reporting Services

CHAPTER 12  DELIVERING BUSINESS INTELLIGENCE WITH SSRS

Figure 12-4. Cube browser with year and branch

Using an Analysis Service Cube with SSRS

Now that you have determined that the Patient Referral cube is working as it should, the next step is to
create an SSRS report. In the Pro_SSRS project, you will find two completed reports, the Average Referral
to Admission report and the Referral to Admission Chart report. Both reports are based on the Patient
Referral cube. Since creating reports is the same, we will not go through the procedure of building these
reports step by step. However, we will demonstrate the following through the Average Referral to
Admission report:

• Setting up a data source to use Analysis Services