MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase, 2nd Edition - Brossura

Spofford, George

Brossura

ISBN 10: 0471748080 ISBN 13: 9780471748083

Casa editrice: Wiley, 2006

Riassunto

• 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.

Su questo libro

L'autore

George Spofford is a Distinguished Engineer at HyperionSolutions, Inc. and the author of the first edition of MDXSolutions (Wiley).

Sivakumar Harinath is the Test Lead for Analysis Services2005 at Microsoft.

Christopher Webb is a technical architect who specializesin BI solutions at IMS Health in London.

Dylan Hai Huang is currently working as a program managerin Microsoft Office Business Application Team. Before joining thecurrent team, he had been working in Microsoft Analysis ServicePerformance Team. His main interests are business intelligence,high performance computation and data mining.

Francesco Civardi is Chief Scientist at DaisyLabs, aBusiness Intelligence Company. He is also Professor of DataAnalysis Tools and Techniques at the Catholic Universities ofBrescia and Cremona.

Dalla quarta di copertina

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.

Dettagli dell?edizione

• Editore: Wiley
• Data di pubblicazione: 2006
• ISBN 10: 0471748080
• ISBN 13: 9780471748083
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero edizione: 2
• Numero di pagine: 744