1227
Chapter 54: Confi guring and Administering Analysis Services
54
■ (^) Multidimensional and Data Mining instances have a yellow cube.
■ Tabular instances have a blue fl at grid.
■ (^) PowerPivot for SharePoint instances have a set of three people blue, yellow, and red.
FIGURE 54-3
The SQL Server Confi guration Manager showing Analysis Services running.
FIGURE 54-4
Object Explorer showing different Analysis Services instances.
Confi guring Basic Analysis Services Settings
After Analysis Services is installed and running, Analysis Services administrators may
confi gure various settings that customize how Analysis Services performs. This section
reviews common basic settings for Analysis Services. You can fi nd a more thorough detail-
ing of the Analysis Service settings in Professional Microsoft SQL Server Analysis Services
with MDX and DAX (Harinath, et al Wrox, 2012)To modify settings for Analysis Services, launch SQL Server Management Studio, and when
prompted with the Connect to Server dialog, select the Server type as Analysis Services,
and provide your Server and Instance Name, as shown in Figure 54-5.c54.indd 1227c54.indd 1227 7/31/2012 10:31:04 AM7/31/2012 10:31:04 AM
http://www.it-ebooks.info