Database Reference
In-Depth Information
Repeat this process for the target, but also add a dimension filter for
DimCountry.Regions and choose All instead of Default Member (All). Your
setup should look like Figure 13-26.
F I g u R e 13-26
Adding ilters
This process will create a target that is the average of all the countries.
Next, create a new scorecard by choosing “Blank scorecard” from the templates.
Add the KPI to the new scorecard by dragging it onto the design surface, and
add the DimCountries
a
Regions hierarchy by dragging it onto the KPI name
on the scorecard. Call your scorecard
Average Hours
, and it
should appear as it does in Figure 13-27.
The inal step before creating the dashboard is to link to the
Reporting Services report. Right-click the PerformancePoint
content list, choose New
a
Report, and then choose Reporting
Services.
A setup screen will appear—if you are using Native mode
Reporting Services, put in the server name. If you are running
a named instance, you will need to go to the Reporting Services
Coniguration Manager to obtain the name. Once you have set
it up, click the Browse button to choose the report, as shown
in Figure 13-28.
F I g u R e 13-27
A scorecard in
PerformancePoint
