Returns the first child of the parent of a member.
FirstSibling ( member [, hierarchy ])
A member specification.
Optional. A specific hierarchy within the time dimension.
select
{ ( FirstSibling([starting date].[2020]) ) } on 0,
{ (measure.income), (measure.cost) } on 100
from [logistics.test];
2019 | |
income | 137825.9201999994 |
cost | 123576273.86565734 |