{"product_id":"mdx-solutions-isbn-9780471748083","title":"MDX Solutions","description":"\u003cul\u003e \u003cli\u003eServing 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\u003c\/li\u003e \u003cli\u003eAfter 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\u003c\/li\u003e \u003cli\u003eNew 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\u003c\/li\u003e \u003cli\u003eAlso 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\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cb\u003eNote:\u003c\/b\u003e CD-ROM\/DVD and other supplementary materials are not included as part of eBook file.\u003c\/p\u003e  Acknowledgments.  \u003cp\u003eIntroduction.\u003c\/p\u003e \u003cp\u003eChapter 1:  A First Introduction to MDX.\u003c\/p\u003e \u003cp\u003eChapter 2: Introduction to MDX Calculated Members and Named Sets.\u003c\/p\u003e \u003cp\u003eChapter 3: Common Calculations and Selections in MDX.\u003c\/p\u003e \u003cp\u003eChapter 4: MDX Query Context and Execution.\u003c\/p\u003e \u003cp\u003eChapter 5: Named Sets and Set Aliases.\u003c\/p\u003e \u003cp\u003eChapter 6: Sorting and Ranking in MDX.\u003c\/p\u003e \u003cp\u003eChapter 7: Advanced MDX Application Topics.\u003c\/p\u003e \u003cp\u003eChapter 8: Using the Attribute Data Model of Microsoft Analysis Services.\u003c\/p\u003e \u003cp\u003eChapter 9: Using Attribute Dimensions and Member Properties in Hyperion Essbase.\u003c\/p\u003e \u003cp\u003eChapter 10: Extending MDX through External Functions.\u003c\/p\u003e \u003cp\u003eChapter 11: Changing the Cube and Dimension Environment through MDX.\u003c\/p\u003e \u003cp\u003eChapter 12: The Many Ways to Calculate in Microsoft Analysis Services.\u003c\/p\u003e \u003cp\u003eChapter 13: MDX Scripting in Analysis Services 2005.\u003c\/p\u003e \u003cp\u003eChapter 14: Enriching the Client Interaction.\u003c\/p\u003e \u003cp\u003eChapter 15: Client Programming Basics.\u003c\/p\u003e \u003cp\u003eChapter 16: Optimizing MDX.\u003c\/p\u003e \u003cp\u003eChapter 17: Working with Local Cubes.\u003c\/p\u003e \u003cp\u003eAppendix A: MDX Function and Operator Reference.\u003c\/p\u003e \u003cp\u003eAppendix B: Connection Parameters That Affect MDX.\u003c\/p\u003e \u003cp\u003eAppendix C: Intrinsic Cell and Member Properties.\u003c\/p\u003e \u003cp\u003eAppendix D: Format String Codes.\u003c\/p\u003e \u003cp\u003eIndex.\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eGeorge Spofford\u003c\/b\u003e is a Distinguished Engineer at Hyperion Solutions, Inc. and the author of the first edition of \u003ci\u003eMDX Solutions\u003c\/i\u003e (Wiley). \u003cb\u003eSivakumar Harinath\u003c\/b\u003e is the Test Lead for Analysis Services 2005 at Microsoft. \u003cb\u003eChristopher Webb\u003c\/b\u003e is a technical architect who specializes in BI solutions at IMS Health in London. \u003cb\u003eDylan Hai Huang\u003c\/b\u003e 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. \u003cb\u003eFrancesco Civardi\u003c\/b\u003e 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.    \u003c\/p\u003e\u003cp\u003e\u003cb\u003eAn updated version of the leading tutorial and reference on the MDX query language\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eNow in its second edition, this invaluable reference explains why MDX (MulitDimensional eXpressions) is the most widely accepted software used for dimensional application. You'll learn how to build effective multidimensional data warehouses and you'll gain the necessary skills to access and analyze data to make better business decisions. \u003c\/p\u003e\u003cp\u003eAfter a brief overview of the syntax and semantics of the MDX language, the authors move directly to the tutorial, providing practical examples of MDX in use. With more than 60 percent revised and updated content, this new edition addresses the increased number of analytical applications that use MDX. The authors cover both the 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. \u003c\/p\u003e\u003cp\u003eThis unrivaled book includes: \u003c\/p\u003e\u003cul\u003e \u003cli\u003eThe range of possibilities specific to Microsoft and Hyperion\u003c\/li\u003e \u003cli\u003eTechniques and tricks of combining the different functions of MDX to solve a variety of problems\u003c\/li\u003e \u003cli\u003eCapabilities of SQL Server 2005 Analysis Services, and how its relationship with MDX has changed from the prior version\u003c\/li\u003e \u003cli\u003eThe standard syntax of MDX that handles the constructs and capabilities of numerous servers\u003c\/li\u003e \u003cli\u003eDetailed reference appendices for MDX operators, functions, and related connection settings\u003c\/li\u003e \u003c\/ul\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989591998693,"sku":"NP9780471748083","price":70.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9780471748083.jpg?v=1761784728","url":"https:\/\/k12savings.com\/products\/mdx-solutions-isbn-9780471748083","provider":"K12savings","version":"1.0","type":"link"}