Analysis Services
Building Calculated Members in MDX
In Multidimensional Expressions (MDX), a calculated member is defined as a member that is resolved not by retrieving data, but by calculating an MDX expression to return a value. This innocuous definition covers an incredible amount of ground; the ability to construct and use calculated members in an MDX query provides a great deal of manipulation capability for multidimensional data. This topic discusses some of the simpler aspects of creating calculated members, as covered in the following table.
| Topic | Description |
|---|---|
| Using WITH to Create Calculated Members | Discusses the use of the WITH keyword to create calculated members in an MDX query. |
| Using Functions in Calculated Members | Details the use of functions in calculated members and other MDX expressions. |
| Conditional Expressions | Covers the use of conditional expressions, such as the IF keyword, in calculated members. |