Microsoft SQL Server 2008 Analysis Services Unleashed [NOOK Book]


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 ...

See more details below
Microsoft SQL Server 2008 Analysis Services Unleashed

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac

Want a NOOK? Explore Now

NOOK Book (eBook)
$27.49 price
(Save 42%)$47.99 List Price


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

Read More Show Less

Product Details

  • ISBN-13: 9780768686890
  • Publisher: Pearson Education
  • Publication date: 12/28/2008
  • Series: Unleashed
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 888
  • File size: 16 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Irina Gorbach is a senior development lead at Microsoft. She joined the Analysis Services team soon after its creation over 11 years ago. During her work at Microsoft, Irina has designed and developed many features of the Analysis Services product, and was responsible for client subsystem: OLEDB and ADOMD.Net. Irina was in the original group of architects that designed XML for Analysis specification; she worked on the architecture and design of calculation algorithms and currently is working on scalability of Analysis Services.


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.

Read More Show Less

Table of Contents


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

Read More Show Less



Analysis Services began as the project of a small Israeli firm named Panorama, which had responded to a request from a British publishing company to develop an application that would analyze the data stored in its relational database. By the end of 1994, Panorama developers began work on a more general application that would make it possible for business managers to analyze data with relative ease.

With its first release in 1995, Panorama deployed the application to several dozen customers. As the next release moved the application more deeply into the Israeli market, the Panorama team began to develop a new client/server analytical application. The server would process the data and store it in a proprietary format, and the client would also offer users an easy-to-use, rich graphical interface.

By 1996, the application had come to the attention of Microsoft, which acquired the technology by the end of that same year. In early 1997, a small Panorama team comprised of Alexander Berger, Amir and Ariel Netz, Edward Melomed, and Mosha Pasumansky moved from Tel Aviv to Redmond to start work on the first version of Microsoft OLAP Server. After the move to the United States, the team added new developers Irina Gorbach and Py Bateman.

To make the application attractive to enterprise customers, the team took on the challenge of formalizing and standardizing data exchange protocols, and they eliminated the client side of the application in favor of supporting a variety of third-party client applications. In early 1997, a small group including Alexander Berger retreated to a Puget Sound island to brainstorm the foundation of what would become SQL Server Analysis Services.

That retreat produced a plan for developing a standard protocol for client applications to access OLAP data: OLEDB for OLAP. More important, and more challenging, was the plan for developing a new query language that could access multidimensional data stored in the OLAP server—MDX (Multidimensional Expressions). MDX is a text language similar to SQL. MDX makes it possible to work with a multidimensional dataset returned from a multidimensional cube. From its inception, MDX has continued to change and improve, and now it is the de facto standard for the industry.

The original release plan was to include the OLAP server in the 1997 release of SQL Server 6.5. However, instead of rushing to market, Microsoft decided to give the development team more time to implement MDX and a new OLEDB for OLAP provider. Microsoft’s first version of a multidimensional database was released in 1998 as part of SQL Server 7.0. That version was integrated with Microsoft Excel PivotTables, the first client for the new server.

Under the slogan, “multidimensionality for the masses,” this new multidimensional database from Microsoft opened the market for multidimensional applications to companies of all sizes. The new language and interface were greeted favorably. The simplicity (and, one could say, elegance) of the design made it possible for users to rapidly become proficient with the new product, including users who weren’t database experts. Technology that used to be available only to large corporations was now accessible to medium-sized and small businesses. As a result, the market for new applications that use multidimensional analysis has expanded and flourished in an environment rich with developers who write those applications.

But, of course, we were not satisfied to rest on our laurels. We took on a new goal—turn Analysis Services into a new platform for data warehousing. To achieve this, we introduced new types of dimensions, increased the volume of data the server can process, and extended the calculation model to be more robust and flexible. Even though no additional personnel joined the team for this effort, by the end of 1999 we brought the new and improved Analysis Services 2000 to market.

For the next five years, more and more companies adopted Analysis Services until it became a leader in the multidimensional database market, garnering a 27% market share. Now, multidimensional databases running on OLAP servers are integral to the IT infrastructures of companies of all sizes. In response to this wide adoption of multidimensional database technology, Microsoft has increased the size of the team devoted to OLAP technology in order to continue to develop the platform to meet the requirements of enterprise customers.

For the 2005 release of SQL Server Analysis Services we started from ground up, rewriting the original (and now aging) code base. We built enterprise infrastructure into the core of the server.

SQL Server 2008 release continues to improve architecture and functionality of Analysis Services. While improving the performance of query execution, it also introduces query language extensions and new management capabilities.

Who Is This Book’s Intended Audience?

In this book, we bring you the tools you need to fully exploit Analysis Services and explain the architecture of the system. You’ll find all of the coverage of our previous book (just in case you were wondering if you needed to go back and read that one first), including the basic architecture established in Analysis Services 2005 as well as all the improvements introduced in Analysis Services 2008. Analysis Services Unleashed gives you a full understanding of multidimensional analysis and the MDX query language. It also exposes all the aspects of designing multidimensional applications and management of the system.

How This Book Is Organized

The book is divided into the following nine parts:

Parts I and II are devoted to a formalized description of the multidimensional model implemented in the new version of the OLAP server. We give you the vocabulary and concepts you’ll need to work with this model.

In Part III, we present a detailed discussion of MDX and explanation of the way we use it to query multidimensional data. You’ll need a practical grasp of the data model and MDX to take advantage of all the functionality of Analysis Services.

We devote the middle section of the book in Parts IV–VII to the practical aspects of loading and storing data in Analysis Services, as well as methods of optimizing data preparation and data access. In addition, we examine server architecture.

In the last section of the book, Parts VIII–IX, we discuss data access, the architecture of client components, and data protection. In addition, we examine the practical aspects of administering the server and monitoring its activities.

We wish you great success in your work with Analysis Services 2008, and we hope that our humbly offered book is of service to you.

Conventions Used in This Book

Commands, scripts, and anything related to code are presented in a special monospace computer typeface. Bold indicates key terms being defined, and italic is used to indicate variables or for emphasis. Great care has been taken to be consistent in letter case, naming, and structure, with the goal of making command and script examples more readable. In addition, you might find instances in which commands or scripts haven’t been fully optimized. This lack of optimization is for your benefit, as it makes those code samples more intelligible and follows the practice of writing code for others to read.

Other standards used throughout this book are as follows:

CAUTION - Cautions alert you to actions that should be avoided.

NOTE - Notes give you additional background information about a topic being discussed.

© Copyright Pearson Education. All rights reserved.

Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Posted January 21, 2009


    Do you need to fully exploit Analysis Services and explain the architecture of the system? If you do, then this book is for you! Authors Irina Gorbach, Alexander Berger, and Edward Melomed, have done an outstanding job of writing a book that gives you a full understanding of the multidimensional analysis and the MDX query language.<BR/><BR/>Authors Gorbach, Berger and Melomed, begin with a formalized description of the multidimensional model that is implemented in the newer version of the OLAP. Then, the authors present a detailed discussion of MDX and an explanation of the way they use it to query multidimensional data. They also cover the practical aspects of loading and storing data in Analysis Services; as well as, methods of optimizing data preparation and data access. Finally, they also discuss data access, the architecture of client components, and data protection.<BR/><BR/>This most excellent book exposes all the aspects of designing multidimensional applications and the management of the system. Perhaps more importantly, this great book examines the practical aspects of administering the server and monitoring its activities.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)