More importantly, the spreadsheet control does not have direct connectivity to
data sources. In other words, creating such a report will require that all the data be
typed in, or at least copied from another source and pasted in. The spreadsheet control
cannot directly tie to data so there are no queries available to retrieve data and fill out
the spreadsheet. There is, however, a button to launch the full Excel product and users
clicking that button will get a copy of the spreadsheet in Excel, as long as they have
either Excel 2003 or Excel 2007 installed on their local machine.
SQL Server Reports and Web Pages
As both the Strategy Map and Trend Analysis Chart reports were covered in detail
in Chapter 5, this section will conclude with a discussion of the SQL Server Reports
and Web Pages. Each of these creates a link to an object that already exists. A new
SQL Server report ties to an existing report in Reporting Services. The developer
can choose to show or hide the Reporting Services toolbar, any parameters, and the
docmap, which is a navigation tool available in Reporting Services to allow users to
jump around in a report quickly. Finally, report parameters can be set so that data is
passed automatically when the report is called, or the report parameters can be set to
filters on a PerformancePoint Dashboard.
Web pages are extremely simple: they simply take a URL. While this may seem
overly simplistic, it is an excellent way to tie non-PerformancePoint Server content
into a dashboard.
Pages:
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230