From an end-user standpoint, perspectives and cubes work
exactly the same way, so in this case the user should select just what they want to
see. This chapter will assume the user has the entire Adventure Works cube selected.
The next screen of the wizard has several options on it. The first is the name of
the data connection file as it will be stored on the hard drive. There is also a check
box to allow for the saving of a password if the user chose to enter a username
Figure 9-1 The Data Connection Wizard allows users to connect Excel 2007 PivotTables
and PivotCharts to many different data sources, including Analysis Services
cubes.
298 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
and password on the first screen of the wizard. There is an optional description
field available, and then a field for a friendly name. This is the name of the
data connection as it will appear in the future if the user clicks on the Existing
Connections button on the Data ribbon. By default this is server name, database
name, and cube name, but shortening it often makes sense. Figure 9-2 shows it
renamed to a much simpler name. The Wizard screen also enables the user to type in
search keywords and then click on a check box that attempts to use the file to refresh
data. Checking that particular box means that if any changes have been made to the
connection file, those changes will be picked up by the PivotTable when the data is
refreshed.
Pages:
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387