Finally, the actual name of the document is selected.
Figure 6-24 A PivotTable showing the Field List as well as an extensive set of options for
controlling how the grid is laid out.
C h a p t e r 6 : A n a l y s i s w i t h P e r f o r m a n c e P o i n t S e r v e r a n d P r o C l a r i t y 167
In addition, an Item Name can be chosen if the page has named ranges, and the
developer can also choose to show just certain rows and cells. Finally, a spreadsheet
with parameters will list the parameters and those can be tied to PerformancePoint
filters. Figure 6-25 shows what this page looks like after it is filled out for a simple
report with no parameters.
Once the report has been set up, the developer can preview it by clicking on
the View tab. This will open the report in a browser mode in the tab and let the
developer confirm that it is working properly.
ProClarity Analytics Server Page
The ProClarity Analytics Server Page report will link to an existing view in a
ProClarity Analytics Server briefing book. This will be covered in detail in the
section on ProClarity later in this chapter.
Figure 6-25 Report Settings on the Excel Settings page
168 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
Spreadsheet Reports
The Spreadsheet report is relatively simple. Creating one loads up the Excel grid
using the Office Web Components. Note that the Office Web Components are from
Office 2003, not Office 2007, so users will only have the functionality of Excel 2003
in their spreadsheet report.
Pages:
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229