Microsoft SQL Server 2008 Analysis Services Unleashed

Description

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

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