- About the Series
- Introduction
- Introducing MDX Queries
- Key Concepts and Terminology
- Introducing Sets
- Understanding Metadata
- Working with MDX Queries
- Working with Member Sets
- Specifying Members in a Set
- Using the CrossJoin Function to Combine Multidimensional Sets
- Looking Ahead to Calculated Members
- Next in This Series
Like this article? We recommend
Like this article? We recommend
Like this article? We recommend
Introduction
The previous article in this series expanded on the topics introduced in earlier articles, beginning with an integrated practice example that explored the handling of hierarchical relationships in expressions. We used conditional tests to identify empty members, and explored a simple approach for handling divide-by-zero errors in general. Finally, the article introduced the concept of time within the context of expression design, and worked through examples of providing support for time-based analysis, including the quantification of change in values over time, with MDX functions designed for that purpose.
This lesson begins an exploration of MDX queries. We'll do the following:
Examine the differences between MDX expressions and MDX query statements
Create rudimentary MDX queries to gain an understanding of their components and uses
Explore MDX sets, their functional uses, and the steps involved in their creation
Practice the use of set functions as part of working with MDX sets
Consider the creation of calculated members within MDX queries, beginning with the creation of a dynamic calculated member, to further support the business needs of information consumers