Returns the member of the last sibling member that is a descendant of a member specified at the specified level.
ClosingPeriod ( [ layer [,member ]] )Layer specification.
Optional member specification. If omitted, the last child of the Time dimension is assumed (for example, Qtr4 in Sample Basic).
select
{ ([Goods].[foods],[Transport].[railway],[starting region].[Europe].[UK]), ([Transport].[highway],[starting region].[Asia].[Japan]) } on 0,
{ (ClosingPeriod([starting region].[country])) } on 2
from [logistics.test];
| foods | ||
| railway | highway | |
| UK | Japan | |
| UK | 999.999 | 3111.1079999999997 |