Chapter 13. Programmatic and Advanced Administration
Chapter 7 showed you how to administer Analysis Services 2008 using SQL Server Management Studio (SSMS). In Analysis Services 2005 and 2008 you also have the option of automating administrative processes using XMLA commands or using AMO, which in turn communicates with the server using XMLA. AMO provides a well-defined, extremely helpful object model that extracts execute and discover XMLA commands that need to be sent to the server. Almost all the user interfaces you saw in SQL Server Management Studio use the AMO object model while communicating to the server. In this chapter, you learn to manage Analysis Services using AMO. You learn about using XMLA commands and SQL Server Integration Services (SSIS) to automate some of the management tasks in Chapter 19. You don't have to type in the long code snippets that follow; they are available for download on the book's web site.
Get Professional Microsoft® SQL Server® Analysis Services 2008 with MDX now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
