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.
CurrentTuple ( set )
OR
set.Current
| set | A set specification. This argument should be a named set, defined in the WITH section. |
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 |