These various topics will be discussed
throughout the chapter, but for new users the first connection will be directly to a
cube. When starting the Professional clients, users are presented with the Welcome
screen shown in Figure 6-26, where they can choose between the four options.
When choosing to open a cube, there are two options: opening a cube from an
Analysis Services server or opening a local cube. Local cubes are a way of storing
cubes, or pieces of cubes, on machines that may not be running Analysis Services.
There are many limitations with local cubes and a full discussion of local cubes
170 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
is beyond the scope of this book; see the SQL Server Books Online for more
information. Figure 6-27 shows the dialog box that allows users to choose either a server
or local cube; in the screenshot the Advanced button has been clicked. The Advanced
button opens two additional fields on the form that allow users to enter a username and
password. These options are normally used when a cube is made accessible via HTTP;
this makes it easier for companies to access cubes across firewalls in some cases. The
username and password can also be used when accessing cubes across domains if a
trust does not exist; the user can enter credentials that allow access to the domain on
which Analysis Services resides.
After selecting a server name and clicking the OK button, the user is presented with
a list of the server??™s databases on the left, and a list of the cubes in the selected database
on the right.
Pages:
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233