MDX Solutions
With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase
George Spofford, Sivakumar Harinath, Christopher Webb, Dylan Hai Huang, Francesco Civardi
Résumé
- 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 warehouses
- After 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 use
- New 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 Essbase
- Also 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 decisions
L'auteur - George Spofford
George Spofford is a Distinguished Engineer at Hyperion Solutions, Inc. and the author of the first edition of MDX Solutions (Wiley).
L'auteur - Sivakumar Harinath
Sivakumar Harinath is the Test Lead for Analysis Services 2005 at Microsoft.
L'auteur - Christopher Webb
Christopher Webb is a technical architect who specializes in BI solutions at IMS Health in London.
L'auteur - Dylan Hai Huang
Dylan Hai Huang is currently working as a program manager in Microsoft Office Business Application Team. Before joining the current team, he had been working in Microsoft Analysis Service Performance Team. His main interests are business intelligence, high performance computation and data mining.
L'auteur - Francesco Civardi
Francesco Civardi is Chief Scientist at DaisyLabs, a Business Intelligence Company. He is also Professor of Data Analysis Tools and Techniques at the Catholic Universities of Brescia and Cremona.
Sommaire
- A First Introduction to MDX
- Introduction to MDX Calculated Members and Named Sets
- Common Calculations and Selections in MDX
- MDX Query Context and Execution
- Named Sets and Set Aliases
- Sorting and Ranking in MDX
- Advanced MDX Application Topics
- Using the Attribute Data Model of Microsoft Analysis Services
- Using Attribute Dimensions and Member Properties in Hyperion Essbase
- Extending MDX through External Functions
- Changing the Cube and Dimension Environment through MDX
- The Many Ways to Calculate in Microsoft Analysis Services
- MDX Scripting in Analysis Services 2005
- Enriching the Client Interaction
- Client Programming Basics
- Optimizing MDX
- 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
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Wiley |
Auteur(s) | George Spofford, Sivakumar Harinath, Christopher Webb, Dylan Hai Huang, Francesco Civardi |
Parution | 17/03/2006 |
Édition | 2eme édition |
Nb. de pages | 744 |
Format | 19 x 23,5 |
Couverture | Broché |
Poids | 1075g |
Intérieur | Noir et Blanc |
EAN13 | 9780471748083 |
ISBN13 | 978-0-471-74808-3 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse