Tuple-Based Calculation

A calculation tuple is a way to represent a data slice of members, from two or more sparse dimensions, to be used in a calculation.

Examples of valid calculation tuples:

  • ("Diet Cola", "New York")
  • ("Diet Cola", "Cola", Florida)
  • (Cola, "New Hampshire")

If you write MDX expressions, you might be aware of these tuple restrictions that apply to MDX:

  • Only a single member from each dimension can be included in an MDX tuple
  • All tuples in an MDX set must have the same dimensions represented, in the same order

However, when you select tuples in calculation scripts, these requirements are relaxed for convenience. You may freely write tuple expressions, and the tuples may describe member lists, as the following tuple does: (@Children(East), Cola).