Microsoft SQL Server 2008 Analysis Services Unleashed
©2009 |Sams Publishing | Available
©2009 |Sams Publishing | Available
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.
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±
This product is part of the following series. Click on a series title to see the full list of products in the series.
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
Pearson offers special pricing when you package your text with other student resources. If you're interested in creating a cost-saving package for your students, contact your Pearson rep.
|Online purchase price||$47.99|
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 Bergerwas 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.
We're sorry! We don't recognize your username or password. Please try again.
The work is protected by local and international copyright laws and is provided solely for the use of instructors in teaching their courses and assessing student learning.
You have successfully signed out and will be required to sign back in should you need to download more resources.