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.
|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.|