MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase, Second Edition
- 10h 44m
- Christopher Webb, Dylan Hai Huang, Francesco Civardi, George Spofford, Sivakumar Harinath
- John Wiley & Sons (US)
- 2006
Now in its second edition, this invaluable reference explains why MDX (MultiDimensional eXpressions) is the most widely accepted software used for dimensional application. You’ll learn how to build effective multidimensional data warehouses and you’ll gain the necessary skills to access and analyze data to make better business decisions.
After a brief overview of the syntax and semantics of the MDX language, the authors move directly to the tutorial, providing practical examples of MDX in use. With more than 60 percent revised and updated content, this new edition addresses the increased number of analytical applications that use MDX.
The authors cover both the changes in the MDX language itself as well as major changes in its implementation with the latest software releases of Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase.
This unrivaled book includes:
- The range of possibilities specific to Microsoft and Hyperion
- Techniques and tricks of combining the different functions of MDX to solve a variety of problems
- Capabilities of SQL Server 2005 Analysis Services, and how its relationship with MDX has changed from the prior version
- The standard syntax of MDX that handles the constructs and capabilities of numerous servers
- Detailed reference appendices for MDX operators, functions, and related connection settings.
About the Authors
George Spofford is a Distinguished Engineer at Hyperion Solutions, Inc., and the author of the first edition of MDX Solutions (Wiley).
Sivakumar Harinath is the Test Lead for Analysis Services 2005 at Microsoft
Christopher Webb is a technical architect who specializes in BI solutions at IMS Health in London.
Dylan Hai Huang is currently working as a program manager in Microsoft Office Business Application Team. Before joining the current team, he had been working in Microsoft Analysis Service Performance Team. His main interests are business intelligence, high performance computation and data mining.
Francesco Civardi is Chief Scientist at DaisyLabs, a Business Intelligence Company. He is also Professor of Data Analysis Tools and Techniques at the Catholic Universities of Brescia and Cremona.
In this Book
-
A First Introduction to MDX
-
Introduction to MDX Calculated Members and Named Sets
-
Common Calculations and Selections in MDX
-
MDX Query Context and Execution
-
Named Sets and Set Aliases
-
Sorting and Ranking in MDX
-
Advanced MDX Application Topics
-
Using the Attribute Data Model of Microsoft Analysis Services
-
Using Attribute Dimensions and Member Properties in Hyperion Essbase
-
Extending MDX through External Functions
-
Changing the Cube and Dimension Environment through MDX
-
The Many Ways to Calculate in Microsoft Analysis Services
-
MDX Scripting in Analysis Services 2005
-
Enriching the Client Interaction
-
Client Programming Basics
-
Optimizing MDX
-
Working with Local Cubes
