MDX Solutions With Microsoft SQL Server Analysis Services

  • 6h 50m
  • George Spofford
  • John Wiley & Sons (US)
  • 2001

Understanding MDX is crucial for anyone designing or implementing a database in Microsoft’s products. This informative book serves as both a tutorial and a reference guide by teaching you how to use MDX to access and analyze data fro decision support. The standard language and Microsoft’s own extensive additions to MDX are thoroughly explained. After the overview of the MDX language is presented, the author plunges into the tutorial, offering practical examples of MDX in use. He shows various techniques using MDX to access data and calculate results, and covers the more advanced techniques of aggregation, query templates, and MDX optimization.

This unrivaled book includes:

  • Explanations of each MDX feature
  • Simple and sophisticated applications
  • Details of building and executing MDX queries
  • Introduction to Visual Basic programming techniques using MDX
  • Instructions for building and using client-side local cubes
  • Detailed reference appendices for MDX operators, functions, and related connection settings

About the Author

George Spofford is Chief Architect of the DSS Lab, where he is a consultant and software engineer specializing in design, implementation, and evaluation of OLAP-based DSS systems and related tools. He coauthored Microsoft OLAP Solutions (also from Wiley) and has extensive experience applying Microsoft’s analysis tools. Working on OLAP technologies since 1988, he has also developed OLAP clients and servers, including Power Thinking Tools’ FreeThink. He earned a Microsoft MVP award for his contributions to the OLAP user community.

In this Book

  • MDX Solutions With Microsoft SQL Server Analysis Services
  • Introduction
  • A First Introduction to MDX
  • MDX in More Detail
  • MDX in Use
  • Advanced MDX Application Topics
  • MDX Context and Execution
  • Chapter 6: The Many Ways To Calculate in Microsoft Analysis Services
  • Extending MDX through External Functions
  • Building Queries in MDX
  • Chapter 9: Advanced Operations and Commands—Drill-Through and Actions
  • Changing the Cube and Dimension Environment through MDX
  • Advanced Applications in Cube Design
  • Chapter 12: Client Programming Basics
  • Chapter 13: Working with Local Cubes
  • Optimizing MDX
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Course CompTIA Data+: Data Analytics Tools
Rating 4.3 of 32 users Rating 4.3 of 32 users (32)
Book Pro Power BI Architecture: Development, Deployment, Sharing, and Security for Microsoft Power BI Solutions, 2nd Edition
Course Low-code ML with KNIME: Getting Started with the KNIME Analytics Platform
Rating 4.6 of 9 users Rating 4.6 of 9 users (9)