CHAPTER 12 DELIVERING BUSINESS INTELLIGENCE WITH SSRS Note If you have skipped to this chapter, note that Business Intelligence Development Studio (BIDS) and SQL
Server Data Tools (SSDT) have been used synonymously throughout this book. If you are using SSRS 2005 through
SSRS 2008 R2, the shortcut to start DEVENV.exe was labeled SQL Server Business Intelligence Development
Studio. In 2012, it is now labeled SQL Server Data Tools.
Figure 12-1. Patient Referral cube structure
Of the six dimensions, several of them should be familiar to you because you have worked with
them in other chapters of the book. Dimensions contain textual attributes that describe the fact data.
You can think of a dimension in a cube as pre-aggregated groups or categories of data that can be
associated with one or more measures. Measures, such as Time to Admission and Fact Referral Count,
are calculated values at each level in a dimension. Multidimensional data stored in a cube consists of
both dimensions and measures that, when queried using MultiDimensional eXpressions (MDX), can be