CurrentTuple

The MDX CurrentTuple function for Essbase returns the current tuple in a set. Current is indicated in the context of query execution mechanics. Use in combination with iterative functions, such as Filter.

Syntax

CurrentTuple ( set )

set.Current

set.CurrentTuple

Parameters

set

A set specification. This argument should be a named set, defined in the WITH section.

Example

The following example finds all Product, Market combinations for which Sales data exists.

WITH SET [NewSet] 
AS 'CrossJoin([Product].Children, [Market].Children)'
SELECT
   Filter([NewSet], NOT IsEmpty([NewSet].CurrentTuple)) 
ON COLUMNS
FROM Sample.Basic
WHERE
   {[Sales]}

This query returns the following grid:

Table 4-54 Output Grid from MDX Example

100				200	...	400	Diet
East	West	South	Central	East	...	Central	East	West	South	Central
27740	28306	16280	33808	23672	...	33451	7919	36423	18676	42660