In Figure 6-28, there is only a single database called Adventure Works DW,
and on the right is a list of cubes and perspectives. A perspective in Analysis Services
2005 is much like a view in a relational database: it??™s a way to limit what can be seen in
the cube. A perspective is not a security mechanism but a way to reduce the complexity
of a cube. This means that one large cube with many dimensions can be simplified by
creating different perspectives for different groups of users. As far as client tools are
concerned, cubes and perspectives are treated identically.
Figure 6-26 ProClarity Desktop Professional allows users to connection directly to a cube
or to use one of three other options.
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 171
Figure 6-27 Cubes may reside on the server or, in rare cases, locally on the user??™s computer.
Security may require a username and password for server-based cubes.
Figure 6-28 A server may have one or more Analysis Services databases and each
database may have multiple cubes and perspectives.
172 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
After the user selects the cube or perspective to browse, a screen appears that
allows the user to choose how they want to see the data. There are five choices on
the page and a user can check the box at the bottom of the screen to make their next
selection the default so that they are not again presented with this screen, which is
shown in Figure 6-29.
Pages:
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234