IntroductionPart 1: Introduction to Analysis Services Chapter 1 OLAP and its role in Business IntelligenceChapter 2 The Multidimensional Data modelChapter 3 UDM: Linking Relational and Multidimensional DatabasesChapter 4 Client/Server Architecture and Multidimensional DatabasesPart 2: Creating Multidimensional Models Chapter 5 The Conceptual Data ModelChapter 6 Dimensions in the Conceptual ModelChapter 7 Cubes and Multidimensional AnalysisChapter 8 Measures and Multidimensional AnalysisChapter 9 Multidimensional Models and the Business Intelligence Development StudioPart 3 Using MDX To Analyze DataChapter 10 MDX ConceptsChapter 11 Advanced MDXChapter 12 Cube-Based MDX CalculationsChapter 13 Dimension-Based MDX CalculationsChapter 14 Extending MDX with Stored ProceduresChapter 15 Block computationsChapter 16 Key Performance Indicators, Actions, and the DRILLTHROUGH StatementChapter 17 Writing Data Into Analysis ServicesPart 4 Creating a Data Warehouse Chapter 18 Loading Data from a Relational DatabaseChapter 19 DSVs and Object Bindings Chapter 20 Multidimensional Models and Relational Database SchemasPart 5 Bringing Data into Analysis Services Chapter 21 The Physical Data ModelChapter 22 Dimension and partition processingChapter 23 Using SQL Server Integration Services to Load DataChapter 24 Aggregation Design and Usage-based OptimizationChapter 25 Proactive Caching and Real-time UpdatesChapter 26 Building Scalable Analysis Services Applications.Part 6 Analysis Server Architecture Chapter 27 Server Architecture and Command ExecutionChapter 28 Memory ManagementChapter 29 Architecture of Query Execution[md]Calculating MDX ExpressionsChapter 30 Architecture of Query Execution[md]Retrieving Data from StoragePart 7 Accessing Data in Analysis Services Chapter 31 Client/Server Architecture and Data AccessChapter 32 Client Components Shipped with Analysis ServicesChapter 33 XML for AnalysisChapter 34 ADOMD.NETChapter 35 Analysis Management Objects Part 8 Security Chapter 36 Security Model for Analysis ServicesChapter 37 Object Security Model for Analysis ServicesChapter 38 Securing Dimension DataChapter 39 Securing Cell ValuesPart 9 Management Chapter 40 Using Trace to Monitor and Audit Analysis ServicesChapter 41 Backup and Restore OperationsChapter 42 Deployment StrategiesChapter 43 Resource Management
Irina Gorbach (Redmond, WA) spent nine years with the Microsoft Analysis Services Team. Now senior software designer, she has designed/developed features including OLEDB, ADOMD.NET, and the XML for Analysis specification. Edward Melomed (Redmond, WA), an original member of the SQL Server Analysis Services team, played a key role in designing programming interfaces for the newest version of Analysis Services. Alexander Berger (Redmond, WA) has led development of Microsoft OLAP Server through all major releases. A principal architect of the OLEDB for OLAP standard and MDX language, he holds 30+ patents in multidimensional database technology. All three live in the Seattle area.