Create offline cube files (.cub) with OlapCube. Download Now!

table of contents

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.