MDX Solutions

With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase

George Spofford, Sivakumar Harinath, Christopher Webb, Dylan Hai Huang, Francesco Civardi

744 pages, parution le 17/03/2006 (2^eme édition)

Ajouter à une liste

Indisponible

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

Voir tout

Replier

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	2^eme é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