* Serving as both a tutorial and a reference guide to the MDX(Multidimensional Expressions) query language, this book shows datawarehouse developers what they need to know to build effectivemultidimensional data warehouses * After a brief overview of the MDX language and a look at how itis used to access data in sophisticated, multidimensional databasesand data warehousing, the authors move directly to providingpractical examples of MDX in use * New material covers changes in the MDX language itself as wellas major changes in its implementation with the latest softwarereleases of Microsoft SQL Server Analysis Services 2005 andHyperion Essbase * Also covers more advanced techniques, like aggregation, querytemplates, and MDX optimization, and shows users what they need toknow to access and analyze data to make better businessdecisions Note: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.
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. He coauthored Microsoft OLAP Solutions (also from Wiley) and has extensive experience applying Microsoft's analysis tools. Working on OLAP technologies since 1988, he has also developed OLAP clients and servers, including Power Thinking Tools' FreeThink. He earned a Microsoft MVP award for his contributions to the OLAP user community.