All eazyBI for Jira eazyBI for Confluence Private eazyBI

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

(Member_expression [ ,Member_expression ... ])

Arguments

Member_Expression

MDX expression that returns a member. Each member in the tuple must come from a different dimension.

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

( 
  [Issue Type].[Bug],
  [Priority].[High & Highest], --calculated member in the Priority dimension
  [Measures].[Issues resolved]
)

See also