Microsoft® SQL ServerTM 2008 Analysis Services Unleashed

As the foundation of the Microsoft Business Intelligence Strategy, Microsoft SQL Server 2008 Analysis Services provides users with faster access to data and even more tools for managing and analyzing data across multidimensional objects (databases, dimensions, cubes).Microsoft SQL Server 2008 Analysis Services Unleashed is the ultimate guide for anyone who is planning to use the latest version of Analysis Services. It gives readers insight into the way Analysis Services functions, and explains practical methods for designing and creating multidimensional objects. It also provides valuable insight into the reasons behind the design decisions taken by the product development team. The authors have been involved with Analysis Services from its earliest days. They have documented in detail the internal features of Analysis Services 2008, explaining server architecture, main data structures, data processing, and query resolution algorithms.Discover the new functionality introduced in Analysis Services 2008 including MDX enhancements and new DMV (dynamic memory views)Work with the Business Intelligence Development Studio, the new Dimension Editor, and Aggregation Designer interfacesEnjoy complete coverage of new Shared Scalable Databases scale-out infrastructureLearn the key concepts of multidimensional modelingExplore the multidimensional object model and its definition languageIntegrate multidimensional and relational databasesBuild client applications to access data in Analysis ServicesUnravel the inner workings of the server architecture, including main data structures, data processing, and query resolution algorithmsLearn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX conceptsGain a deeper understanding of the internal and external protocols for data transfer, including the XML/A protocolDiscover how Analysis Services manages memoryExplore the security model, including role-based security, code-access security, and data securityCategory:Microsoft SQL ServerCovers:Microsoft SQL Server 2008 Analysis ServicesUser Level:Intermediate-Advanced