Chapter 6. MDX
In this chapter, we will cover:
- Returning data on the query axes
- Limiting the query output
- Sorting the query output
- Defining query-level calculations and named sets
- Navigating dimension hierarchies
- Working with the Time dimension
- MDX script's functionality
- Monitoring and tuning MDX queries
Introduction
This chapter explains how to write the most commonly encountered MultiDimensional eXpression (MDX) queries. You use MDX to model calculations in the MDX script within the cube designer as well as to query the cubes. Although most MDX concepts, functions, and keywords will apply to queries as well as the MDX script, the framework for developing MDX will be distinctly different in each environment.
The basic MDX query construct resembles Structured ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
