Database Reference
In-Depth Information
Click Average Hours and choose Create Connection from the Ribbon. If you
don't see the Create connection button, change to the Edit tab in the Ribbon
at top. Set Get Values From to Header - (1) Months of Year; then change to the
Values tab and set the source to Member Unique Name. Click the Connection
Formula button and type
ye ar
. This will set the filter to the year of the date
selected in the calendar. Finish by clicking OK on both screens.
Repeat the process for the report. Click DynamicMeasures and choose Create
Connection from the Ribbon. Set Get Values From to Header - (1) Months of
Year; then change to the Values tab and set the source to Member Unique
Name. Change the Connect To to DimDateYMD.
Click the Connection Formula button and type
ye ar
. Finish by clicking OK on
both screens.
The final step is to link the scorecard to the report. Click DynamicMeasures
and choose Create Connection from the Ribbon. If you can't see Create
Connection in the Ribbon, change the tab in the Ribbon to Set Get Values
from to Left Column - (1) Average Hours. Switch to the Values tab and set the
source to Member Row: Member Unique Name. Change the Connect To to
DimCountryRegions.
When a row is clicked on in the scorecard, this step will send the underlying
unique name from the cube to the report, and hence filter the report. Give
your dashboard a name. Right-click and deploy to SharePoint. Choose a date
in 2011, as that is the last year for which there is average hourly data available.
TrouBleshooTIng
This is a fairly complex section, and many people (including the author)
have issues on the first deploy. The error messages can also be misleading,
as an incorrect setup will sometimes lead to an error saying that you do
not have permission to view the data. In order to troubleshoot, remove
the connection to the parameters one by one until you have isolated the
parameter that is the cause. A common cause of this is PPS sending a value
that SSRS does not have in its list, for instance [Measure] being used instead
of [Measures], or the underlying hierarchies not matching.
Clicking Asia/Pacific in the scorecard will show you a chart similar to the one
in Figure 13-30.
