CurrentTuple

Returns the current tuple in a set. Current is in the context of query execution mechanics. Use in combination with iterative functions such as Filter.

Syntax

CurrentTuple ( set )

OR

set.Current

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:

100 100 100 100 200 200 200 200 300 300 300 300 400 400 400 Diet Diet Diet Diet
East West South Central East West South Central East West South Central East West Central East West South Central
27740 28306 16280 33808 23672 34200 22008 29206 20241 35391 12558 33215 15745 35034 33451 7919 36423 18676 42660

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com