Returns the parent of a member.
Parent ( member [, hierarchy ] )A member specification.
Optional. A specific hierarchy within the time dimension.
with
set QQQ as XXX set XXX as children( parent([Goods].[electronic product].computer) )
select
children( parent( parent( [starting date].[2021].Q1.M3 ) ) ) on 0,
QQQ on 111
from [logistics.test]
where
( [completion date].[2020].[Q1].[M3], Transport.[railway], [starting region].[Europe].[UK], [ending region].[Europe].[Italy], measure.income );
| Q1 | Q2 | Q3 | Q4 | |
| mobile phone | 3003 | 3003 | 3003 | 3003 |
| computer | 4224.222 | 6003 | 6003 | 6003 |
| smart watch | 9003 | 9003 | 9003 | 9003 |