CHAPTER 12 DELIVERING BUSINESS INTELLIGENCE WITH SSRSFigure 12-2. Viewing the Patient Referral cube in BIDS
Perform the following steps to see the average Time to Admission:- You can begin by expanding Measures and then Fact Referral in the cube
object window on the left of the cube design pane. - Next, drag the Time of Admission measure to the Drag Levels or Measures here
to add to the query section of the query pane. Typically, when browsing the
cube or creating reports, you will want to drag over the measures before you
drag over your dimension attributes. You should see an average time of 14.095
days. This calculation was done at the time the cube was originally loaded and
processed and represents a total average of time to admission for all
dimensions combined. Figure 12-3 shows the Time to Admission measure in
the query pane.