Tail ( set [,index ] )
The set from which to take items.
The number of items to take from the end of the set. If omitted, the default is 1. If less than 1, an empty set is returned. If the value exceeds the number of tuples in the input set, the original set is returned.
with
set SSSSSS as tail( crossjoin(LATERALMEMBERS([starting region].[ALL].[Europe]), LATERALMEMBERS(measure.income)) )
SELECT SSSSSS On 10,
LATERALMEMBERS([completion date].[ALL]) On 1
frOM [logistics.test] ;
| ALL | ||
| Europe | quantity | 123567455.556 |