How to create dimension with multilevel element from cube

[diasoptus]

Hi experts,

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);

the result is like this:


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

[pandinus]

This happens because the interim level is not year-specific.

[tomok]

You can't do what you want without changing the names of your departments. That's because if HRD is chosen to roll up to a consolidated node called 2017 then all the Spending List values specified as children of HRD will roll up to that 2017 node, not just the ones you have specified in your cube as belonging to the year 2017. What you would have to do is create two nodes, like HRD-2017 and HRD-2016 and roll the appropriate Spending List elements to them. Sorry, this is a fundamental functionality limitation of TM1, there is no way around it.

[diasoptus]

Well, thanks pandinus and tomok.... I'm glad you would help me.

Now I can understand.

[tomok]

Your welcome and let me take this opportunity to thank you for doing such a good job asking your question. The screen shots were perfect and made it real easy for me to understand what you were asking. I just wish all our users were this conscientious.