MDX solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase

2nd Edition

By George Spofford ... [et al.].

ISBN: 0471748080
Publisher: Wiley
Year: 2006
Pages: 744

About This Book

Serving as both a tutorial and a reference guide to the MDX (Multidimensional Expressions) query language, this book shows data warehouse developers what they need to know to build effective multidimensional data warehousesAfter a brief overview of the MDX language and a look at how it is used to access data in sophisticated, multidimensional databases and data warehousing, the authors move directly to providing practical examples of MDX in useNew material covers 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 EssbaseAlso covers more advanced techniques, like aggregation, query templates, and MDX optimization, and shows users what they need to know to access and analyze data to make better business decisionsNote: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Product Details

Publisher Wiley
Publication date January 1, 2006
Language English
Print length 744 pages
ISBN-10 0471748080
ISBN-13 978-0471748083
Item Weight 2.35 pounds

Editorial Reviews

Editorial Review

From the Inside FlapAn updated version of the leading tutorial and reference on the MDX query languageAn updated version of the leading tutorial and reference on the MDX query languageNow in its second edition, this invaluable reference explains why MDX (MulitDimensional 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. Now in its second edition, this invaluable reference explains why MDX (MulitDimensional 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. 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: This unrivaled book includes: The range of possibilities specific to Microsoft and HyperionThe range of possibilities specific to Microsoft and HyperionTechniques and tricks of combining the different functions of MDX to solve a variety of problemsTechniques and tricks of combining the different functions of MDX to solve a variety of problemsCapabilities of SQL Server 2005 Analysis Services, and how its relationship with MDX has changed from the prior versionCapabilities of SQL Server 2005 Analysis Services, and how its relationship with MDX has changed from the prior versionThe standard syntax of MDX that handles the constructs and capabilities of numerous serversThe standard syntax of MDX that handles the constructs and capabilities of numerous serversDetailed reference appendices for MDX operators, functions, and related connection settingsDetailed reference appendices for MDX operators, functions, and related connection settingsFrom the Back CoverAn updated version of the leading tutorial and reference on the MDX query languageAn updated version of the lea
Shipping set per seller
Compare book + shipping totals for each offer
Seller-error returns
Returns accepted for seller errors. Ask the seller about change-of-mind returns
Partner purchases
MedicalBook.online handles payment, shipping and returns for its orders
Email Support
[email protected] for buyers and sellers