CurrentTuple
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. CurrentTuple addresses the current tuple from a set.
Syntax
CurrentTuple(Set_Expression)
Arguments
| Set_Expression | MDX expression that returns set. |
|---|
Examples
CurrentTuple can be useful to address certain member of the tuple expression. Can be very useful with VisibleRowsSet to return the member name in the results.
Example
If multiple dimensions are used in report rows and you need to log the name of the member for the secondary dimension member you can use this formula:
CurrentTuple(VisibleRowsSet()).item(1).name
See also
- Function Tuple
- Function VisibleRowsSet
- Function Aggregate
- Create calculated measures