What is a tuple?
This document describes what a tuple is and how the tuple function works in query specifications.
Resolving the problem
The tuple function serves to specify the specific context that a filter, sort order or another function (such as value() or rank()) will operate against. A tuple indicates which coordinates of the cube are in use for the operation being executed.
Here are some examples of the tuple function being used...
Within a Query Expression that filters:
Simple use case:
The tuple function serves to specify the specific context that a filter will operate against. In the case of a filter such as ?Top 10 SalesPeople for Q1 of 1996?, the context would likely be the measure (e.g. revenue) and the member 1996 Q1.
TopCount( children of salespeople, 10, tuple([Revenue], [1996 Q1]) )
If a dimension is not represented in the tuple function for a filter, then the default member of each dimension is used for the context.
Within a Query Expression using the Rank function:
rank(<measure> <ordinal direction> TUPLE <member being ranked> WITHIN SET <visible members on opposite axis>)
Simple use case:
User wants to see the rank of each Product Line for the year 1993.
rank(currentMeasure DESC tuple  WITHIN SET [Product Line])
NOTE: In this case, the context used by tuple is not placed in brackets.
|Business Analytics||Cognos 8 Business Intelligence||Analysis Studio|
|Business Analytics||Cognos 8 Business Intelligence||Install and Config|
|Business Analytics||Cognos 8 Business Intelligence||Query Studio|
|Business Analytics||Cognos 8 Business Intelligence||Report Studio|
|Business Analytics||Cognos Business Intelligence||Security||AIX, HP-UX, HP Itanium, Linux, Solaris, Windows||8.3, 8.4, 8.4.1|
More support for:
Cognos 8 Business Intelligence
Software version: 8.3, 8.4, 8.4.1
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Software edition: All Editions
Reference #: 1339536
Modified date: 03 November 2010