Spofford / Harinath / Webb MDX Solutions

With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase
1. Auflage 2006
ISBN: 978-0-470-00733-4
Verlag: John Wiley & Sons
Format: PDF
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 744 Seiten, E-Book

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

Autoren/Hrsg.

Spofford, George

Harinath, Sivakumar

Webb, Christopher

Huang, Dylan Hai

Civardi, Francesco

Inhaltsverzeichnis

Acknowledgments.
Introduction.
Chapter 1:Â A First Introduction to MDX.
Chapter 2: Introduction to MDX Calculated Members and NamedSets.
Chapter 3: Common Calculations and Selections in MDX.
Chapter 4: MDX Query Context and Execution.
Chapter 5: Named Sets and Set Aliases.
Chapter 6: Sorting and Ranking in MDX.
Chapter 7: Advanced MDX Application Topics.
Chapter 8: Using the Attribute Data Model of Microsoft AnalysisServices.
Chapter 9: Using Attribute Dimensions and Member Properties inHyperion Essbase.
Chapter 10: Extending MDX through External Functions.
Chapter 11: Changing the Cube and Dimension Environment throughMDX.
Chapter 12: The Many Ways to Calculate in Microsoft AnalysisServices.
Chapter 13: MDX Scripting in Analysis Services 2005.
Chapter 14: Enriching the Client Interaction.
Chapter 15: Client Programming Basics.
Chapter 16: Optimizing MDX.
Chapter 17: Working with Local Cubes.
Appendix A: MDX Function and Operator Reference.
Appendix B: Connection Parameters That Affect MDX.
Appendix C: Intrinsic Cell and Member Properties.
Appendix D: Format String Codes.
Index.

Über Autor(innen)

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.