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 )
set.Current
set.CurrentTuple
Parameter | Description |
---|---|
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 | 200 | ... | 400 | Diet | ||||||
---|---|---|---|---|---|---|---|---|---|---|
East | West | South | Central | East | ... | Central | East | West | South | Central |
27740 | 28306 | 16280 | 33808 | 23672 | ... | 33451 | 7919 | 36423 | 18676 | 42660 |