Figure 6-24 shows an example of a PivotTable with both
Gross Profit and Gross Profit Margin, broken down by year and product models.
Note that the formatting of the data from the cube is not honored; in other words, the
Gross Profit does not show up as dollars nor does the Gross Profit Margin show up
as a percentage.
Figure 6-23 The PivotChart showing the interactivity that can be used to make selections.
166 B u s i n e s s I n t e l l i g e n c e w i t h M i c r o s o f t O f f i c e P e r f o r m a n c e P o i n t S e r v e r 2 0 0 7
Excel Services Reports
Excel Services reports are simply reports that display an Excel Services spreadsheet.
Excel Services is a web-based version of Excel that allows users to publish Excel
spreadsheets to the server and view them in a browser. Spreadsheets may be static or
contain data pulled from an external data source. If data is pulled from an external
data source, users have the ability of refreshing the data in the spreadsheet.
In order to create an Excel Services report, the developer would select the Excel
Services report template and then give the report a name and optional display
folder. Once the report is open in the editor, the developer chooses the URL to
the SharePoint site. Once the SharePoint site is selected, the Document Library is
chosen; this can be a shared library or someone??™s personal library, although this
choice will force users to enter a username and password to view a spreadsheet in
someone??™s personal folders.
Pages:
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228