CHAPTER 12 DELIVERING BUSINESS INTELLIGENCE WITH SSRS
Figure 12-3. Viewing the overall Time to Admission measure’s average for all dimensions- Now drag two dimension objects onto the data pane. Under the Branch object,
drag and drop the Branch Name field to the left of our Time to Admission
measure. - Next, under Date of Admission, drag and drop the Year - MonthName -
admitdate hierarchy to the right of Branch Name in the data pane. The
hierarchy looks like a pyramid made of six squares. When finished, the cube
browser should look like Figure 12-4. You can now see the results for every
single admitDate along with its corresponding Branch Name, Year and
MonthName attributes.
In prior releases of the cube browser, you could drill down into hierarchies and have column
groupings as we have seen in the Matrix-style reports. However, as of the current release of SQL Server
2012, the cube browser returns the data two-dimensionally much like the results of a T-SQL query. Some
active members in the SQL Server user community has stated that this is a strange setback for
Microsoft’s cube browser and I personally believe that they should add the functionality back. However,
nothing really has changed from the reporting perspective. If you are seeing the results depicted in
Figure 12-3 above, then you are indeed getting data from the cube! Now it is time to move on to SSRS
and create the report you will deploy to SharePoint.