Pro SQL Server 2012 Reporting Services

CHAPTER 12  DELIVERING BUSINESS INTELLIGENCE WITH SSRS

Figure 12-8. MDX query generated graphically

 Caution If you modify the MDX query while in text mode and try to return to design mode, you could potentially

lose any changes you made to the query manually, as shown in Figure 12-9.

Figure 12-9. Warning message displayed when altering MDX query

Both reports, Average Time to Admission and Referral to Admission Chart, will be displayed in a
compact Web Part in SharePoint, which we will show how to do in the next section. Because of this, we