What is a tuple?

Technote (troubleshooting)


Problem(Abstract)

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.

Syntax:

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:

Syntax:

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 [1993] WITHIN SET [Product Line])

NOTE: In this case, the context used by tuple is not placed in brackets.


Cross Reference information
Segment Product Component Platform Version Edition
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

Historical Number

1019080

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos 8 Business Intelligence
Security

Software version:

8.3, 8.4, 8.4.1

Operating system(s):

AIX, HP Itanium, HP-UX, Linux, Solaris, Windows

Software edition:

All Editions

Reference #:

1339536

Modified date:

2010-11-03

Translate my page

Machine Translation

Content navigation