Cover image for Microsoft OLAP solutions
Microsoft OLAP solutions
Thomsen, Erik, 1959-
Personal Author:
Publication Information:
New York : Wiley, [1999]

Physical Description:
xviii, 509 pages : illustrations ; 24 cm + 1 computer laser optical disc (4 3/4 in.)
General Note:
"Wiley computer publishing."
Title Subject:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D343 T47 1999 TEXT Book and Software Set Central Closed Stacks

On Order



"The authors merge their deep experience in OLAP to produce a roadmap to success with Microsoft SQL Server OLAP Services." -Bill Baker, Microsoft Corporation Microsoft(r) OLAP Solutions OLAP enables users to create, change, and access information from multi-dimensional data warehouses almost instantaneously. Microsoft has unleashed the power of OLAP in one of its most popular products, SQL Server 7, now distributed with its OLAP Services component. This guide to mastering Microsoft OLAP Services begins with a practical introduction to OLAP server concepts and architecture. It then progresses by logical, skill-building steps through a range of crucial topics in maintenance, database optimization, and advanced database design. The authors include in-depth case studies illustrating how to build OLAP applications, as well as instructions on how to construct working OLAP applications, including a healthcare benefits analysis application and a grocery store frequent shopper analysis application. Topics covered in detail include:
* The storage and operational architecture of Microsoft OLAP server
* Using the MDX language with Microsoft OLAP server
* Using Microsoft OLAP server to access and update data
* Specifying calculations
* Optimizing server performance
* Securing the server
On the CD-ROM you'll find:
* All the sample applications and databases described in the book
* Additional software for working with Microsoft OLAP server
Wiley Computer Publishing Timely. Practical. Reliable. Visit our Web site at

Author Notes

ERIK THOMSEN is Chief Scientist of the DSS Lab, where he works on the design and implementation of integrated DSS systems. He is a frequent speaker at conferences, writes the "Decision Support" column for Intelligent Enterprise, and performs independent research in the areas of multidimensional logic and visualization. His e-mail address is GEORGE SPOFFORD is Chief Architect of the DSS Lab, where he is a consultant and software engineer specializing in design, implementation, and evaluation of OLAP-based DSS systems and related tools. His e-mail address is DICK CHASE is a Senior Consultant for Decision Support Technology (a part of the Condor Technology Solutions family) and has developed numerous decision support solutions for clients in such industries as retail, healthcare, insurance, and financial services. His e-mail address is

Table of Contents

OLAP Structures and OLAP Services Microsoft OLAP Services Architecture
Database Design Basics
The Basics of Building a Database with the OLAP Manager
Introduction to MDX
Context and Data in MDX Evaluation
MDX Function and Operator Reference
MDX Dimensional Reference Functions
MDX Application Topics
Maintaining Applications
Advanced Cube and Database Design
Extending OLAP Services through External Functions
Tutorial 1: Health Care Benefits Analysis
Tutorial 2: Grocery Store Frequent Shopper Program