Home > Articles > Data > SQL Server

  • Print
  • + Share This
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

  • + Share This
  • 🔖 Save To Your Account