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 |