Tuple

A tuple is a collection of member(s) with the restriction that only one member in the tuple can be from the same dimension. A tuple uniquely identifies a slice of data from a cube, and it represents a single data cell if all dimensions are represented.

Syntax

 ( tuple )

Arguments

tuple	Combination of members from different dimensions in MDX syntax (member_1, member_2, ..., member n)

Examples

Tuples can be useful when creating new calculated measures to calculate results for a specific set of members from dimensions, even if dimensions are not used in the report context directly (rows/pages/columns).

There are several ways to create reports with tuples. For example, to compare the results from the filtered report context with results from a specific set.

Example 1

The Issues created measure, in this example, would calculate the Issues created value for Issue type dimension member Bug and Priority dimension member High regardless of the report context (other dimensions used as filters).

( 
  [Issue Type].[Bug],
  [Priority].[High],
  [Measures].[Issues created]
)

Example 2

The Issues resolved measure, in this example, would calculate the Issues resolved value for Issue type dimension member Bug and a calculated member from "Priority" dimension that aggregates two priorities "High" and "Highest".