With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase
By George Spofford, Sivakumar Harinath, Christopher Webb, Dylan Hai Huang, Francesco Civardi
Final Release Date: May 2006
An updated version of the leading tutorial and reference on theMDX query language
Now in its second edition, this invaluable reference explainswhy MDX (MulitDimensional eXpressions) is the most widely acceptedsoftware used for dimensional application. You'll learn how tobuild effective multidimensional data warehouses and you'll gainthe necessary skills to access and analyze data to make betterbusiness decisions.
After a brief overview of the syntax and semantics of the MDXlanguage, the authors move directly to the tutorial, providingpractical examples of MDX in use. With more than 60 percent revisedand updated content, this new edition addresses the increasednumber of analytical applications that use MDX. The authors coverboth the changes in the MDX language itself as well as majorchanges in its implementation with the latest software releases ofMicrosoft SQL Server Analysis Services 2005 and HyperionEssbase.
This unrivaled book includes:
The range of possibilities specific to Microsoft andHyperion
Techniques and tricks of combining the different functions ofMDX to solve a variety of problems
Capabilities of SQL Server 2005 Analysis Services, and how itsrelationship with MDX has changed from the prior version
The standard syntax of MDX that handles the constructs andcapabilities of numerous servers
Detailed reference appendices for MDX operators, functions, andrelated connection settings
The companion Web site includes a collection of sample databasesand code for use in Analysis Services and Essbase, and an MDX queryinterface for Essbase.
MDX Solutions, 2nd Edition
George Spofford, Sivakumar Harinath, Christopher Webb, Dylan Hai Huang, Francesco Civardi