i'm trying to make dimension from cube with consolidate level.
cube :
for now i'm using this code in metadata tab
Code: Select all
DimensionElementInsert('HierarchyNew','',YearSimple,'c');
DimensionElementComponentAdd('HierarchyNew', YearSimple, DepartmentSimple,1);
DimensionElementComponentAdd('HierarchyNew', DepartmentSimple, Value,1);
my expectation is like this image :
where A2018001-HRD should not be a child of consolidate 2017 --> HRD
and also A2017002-HRD should not be a child of consolidate 2018 --> HRD
Thanks,
Diastirta