29 Writing MDX Queries

MDX is a query language for multidimensional databases that can be used to execute grid retrievals. MDX expressions can also be used to define formulas on Essbase aggregate storage databases, to query metadata, to qualify member names, and to describe data or outline subsets.

• About Writing MDX Queries

• Understanding Elements of a Query

• Using Functions to Build Sets

• Working with Levels and Generations

• Using a Slicer Axis to Set Query Point-of-View

• Common Relationship Functions

• Performing Set Operations

• Creating and Using Named Sets and Calculated Members

• Using Iterative Functions

• Working with Missing Data

• Using Substitution Variables in MDX Queries

• Querying for Properties