Mdx Solutions With Ms Sql Server Analysis Services

0.0

MDX Solutions is both a tutorial and a reference guide to the MDX query language. It shows data warehouse developers what they need to know to build effective multidimensional data warehouses. And it teaches users what they need to know to access and analyze data to make better business decisions. The Second Edition provides 200 additional pages of new material covering both 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 MDX language, the authors move directly to the tutorial, providing practical examples of MDX in use. They show various techniques using MDX to access data and calculate results. They also cover more advanced techniques, like aggregation, query templates, and MDX optimization. The appendixes provide a handy reference guide that users can refer to after completing the tutorial. The companion Website includes sample MDX code with sample databases which can be used to practice what they've learned. Special Feature The current first edition has sold more than 9,000 copies, at $49.99; it is far and away the leading tutorial on the MDX language. The market for MDX tools is growing fast, and now includes Microsoft, Hyperion, SAS, SAP, and other vendors. The new edition is more than 60% new and revised, with 200 more pages. The authors are well-known authorities on MDX, and include an insider on the Microsoft Analysis Services team. Wiley is the leading publisher of books on data warehousing and business intelligence.

0.0

George Spofford is a Distinguished Engineer at Hyperion Solutions, Inc. He has written numerous articles for trade journals, spoken at trade shows, co-authored the book Microsoft OLAP Solutions, and authored the first edition of MDX Solutions. Sivakumar Harinath is currently at Microsoft Corporation and is the Test Lead for Analysis Services 2005. Chris Webb is a Technical Architect specialising in BI solutions at IMS Health in London. He has worked with Microsoft Analysis Services (and previously OLAP Services) for over five years, including three years spent with Microsoft Consulting. Francesco Civardi is Chief Scientist at DaisyLabs, a Business Intelligence Company. He is also Professor of Data Analysis Tools and Techniques (ie Data Warehousing, OLAP and Data Mining) at the Catholic Universities of Brescia and Cremona. 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. Table of Contents Acknowledgments Introduction A FirstIntroduction 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 Index