Microsoft SQL Server 2008 Analysis Services Unleashed

Description

Table of Contents

Introduction

Part 1: Introduction to Analysis Services               

Chapter 1                OLAP and its role in Business Intelligence

Chapter 2                The Multidimensional Data model

Chapter 3                UDM: Linking Relational and Multidimensional Databases

Chapter 4                Client/Server Architecture and Multidimensional Databases

Part 2: Creating Multidimensional Models               

Chapter 5                The Conceptual Data Model

Chapter 6                Dimensions in the Conceptual Model

Chapter 7                Cubes and Multidimensional Analysis

Chapter 8                Measures and Multidimensional Analysis

Chapter 9                Multidimensional Models and the Business Intelligence Development Studio

Part 3 Using MDX To Analyze Data

Chapter 10              MDX Concepts

Chapter 11              Advanced MDX

Chapter 12              Cube-Based MDX Calculations

Chapter 13              Dimension-Based MDX Calculations

Chapter 14              Extending MDX with Stored Procedures

Chapter 15              Block computations

Chapter 16              Key Performance Indicators, Actions, and the DRILLTHROUGH Statement

Chapter 17              Writing Data Into Analysis Services

Part 4 Creating a Data Warehouse        

Chapter 18              Loading Data from a Relational Database

Chapter 19              DSVs and Object Bindings

Chapter 20              Multidimensional Models and Relational Database Schemas

Part 5 Bringing Data into Analysis Services          

Chapter 21              The Physical Data Model

Chapter 22              Dimension and partition processing

Chapter 23              Using SQL Server Integration Services to Load Data

Chapter 24              Aggregation Design and Usage-based Optimization

Chapter 25              Proactive Caching and Real-time Updates

Chapter 26              Building Scalable Analysis Services Applications.

Part 6 Analysis Server Architecture      

Chapter 27              Server Architecture and Command Execution

Chapter 28              Memory Management

Chapter 29              Architecture of Query Execution[md]Calculating MDX Expressions

Chapter 30              Architecture of Query Execution[md]Retrieving Data from Storage

Part 7 Accessing Data in Analysis Services         

Chapter 31              Client/Server Architecture and Data Access

Chapter 32              Client Components Shipped with Analysis Services

Chapter 33              XML for Analysis

Chapter 34              ADOMD.NET

Chapter 35              Analysis Management Objects

Part 8 Security       

Chapter 36              Security Model for Analysis Services

Chapter 37              Object Security Model for Analysis Services

Chapter 38              Securing Dimension Data

Chapter 39              Securing Cell Values

Part 9 Management

Chapter 40              Using Trace to Monitor and Audit Analysis Services

Chapter 41              Backup and Restore Operations

Chapter 42              Deployment Strategies

Chapter 43              Resource Management

Back Cover

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 interfaces
• Enjoy complete coverage of new Shared Scalable Databases scale-out infrastructure
• Learn the key concepts of multidimensional modeling
• Explore the multidimensional object model and its definition language
• Integrate multidimensional and relational databases
• Build client applications to access data in Analysis Services
• Unravel the inner workings of the server architecture, including main data structures, data processing, and query resolution algorithms
• Learn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX concepts
• Gain a deeper understanding of the internal and external protocols for data transfer, including the XML/A protocol
• Discover how Analysis Services manages memory
• Explore the security model, including role-based security, code-access security, and data security

Category: Microsoft SQL Server

Covers: Microsoft SQL Server 2008 Analysis Services

User Level: Intermediate-Advanced

$59.99  USA / $65.99 CAN / £38.99 Net UK±

Author

Alexander Berger

was one of the first developers to work on OLAP systems at Panorama, prior to their purchase by Microsoft. After the acquisition, Alexander led the development of Microsoft OLAP Server through all of its major releases prior to SSAS 2008. Currently, Alexander leads the Business Intelligence department for Microsoft adCenter. He is one of the architects of OLEDB for the OLAP standard and MDX language, and holds more than 30 patents in the area of multidimensional databases.

Edward Melomed is one of the original members of the Microsoft SQL Server Analysis Services team. He arrived in Redmond as part of Microsoft's acquisition of Panorama Software Systems, Inc., which led to the technology that gave rise to Analysis Services 2008. He works as a program manager at Microsoft and plays a major role in the infrastructure design for the Analysis Services engine.