Database Reference
In-Depth Information
EMBEDDING AN SSrS rEPorT
Reporting Services offers a great deal of flexibility in how it renders data while
also offering additional chart types that are not found within PerformancePoint.
Furthermore, many existing reports contain key information desired for inclu-
sion within a PerformancePoint dashboard. Lastly, scorecards that are used
within the dashboard can filter the reports.
Adding Reporting Services reports to PerformancePoint is done by navigating
to the PerformancePoint content library within SharePoint, selecting a new
report, and then selecting the Reporting Services report template. Next, specific
reporting settings are configured as needed, including these:
uu
Server mode (SharePoint Integrated or Native)
uu
Report Server URL
uu
Report URL
uu
Display Options (show toolbar, parameters, and docmap)
uu
Zoom (percent of actual rendered report size to display in a web part)
uu
Format (e.g., HTML 4.0)
uu
Section (to limit just part of a report to be included)
uu
Report parameters
Once the report has been added to the PerformancePoint content library, it can
then be added to a dashboard as other PerformancePoint objects. Additionally,
the report can be configured to work with PerformancePoint connections
permitting, for example, filtering by passing values to report parameters.
EMBEDDING ExCEL rEPorTS
Excel files often contain very useful and important business information that is
desired for inclusion in a PerformancePoint dashboard. SharePoint allows Excel
files to be used directly on SharePoint sites when Excel Services is configured.
Once Excel Services is enabled and Excel workbooks are stored within the
SharePoint site, support for these files is provided within PerformancePoint
by the Excel Services type of report.
To create an Excel Services report, open Dashboard Designer, and from the
Create menu and Reports menu group, select Other Reports. Figure 7-10
shows the selection of Other Reports from within the Report Ribbon group
within Dashboard Designer.
