Database Reference
In-Depth Information
F I g u R e 13-28
Integrating Reporting Services into PerformancePoint
Choose the report you created in the previous section; then click OK.
Reporting Services
in Integrated mode
requires you to
know the URL of the
SharePoint server as
well as the URL of the
report in SharePoint.
This URL format will
be different depend-
ing on the version of
SQL server you have
installed.
PerformancePoint allows you to override the defaults used for the report, as
you can see in Figure 13-29.
F I g u R e 13-29
Setting SSRS parameters in PerformancePoint
Choose Reserve Value for the measure, Month for XAxis, and Country for YAxis;
and leave the rest. Give your report a name and save it.
Now create the dashboard. Right-click the PerformancePoint content list and
choose New
a
Dashboard. Use the Header, 2 Columns template. Drag the
Months of Year filter to the top section, the Average Hours scorecard to the
left section, and the report you just created to the right section. Note that
these will be in the Details window on the right!
