TM1 Forum

Using TM1 Version 9.5.2, FP2.
I would like to write a TI Process to update an existing dimension, for existing N-level dimension elements, and change them into Consolidations (Update the element DTYPE from N to C).
I know in the dimension editor, I can manually update the element Properties / Element Type from Simple to Consolidated.
Is there any way to do this in a TI Process?

jcr55 wrote:Using TM1 Version 9.5.2, FP2.
I would like to write a TI Process to update an existing dimension, for existing N-level dimension elements, and change them into Consolidations (Update the element DTYPE from N to C).
I know in the dimension editor, I can manually update the element Properties / Element Type from Simple to Consolidated.
Is there any way to do this in a TI Process?

All you have to do is add a child to the element. The conversion happens automatically. Personally I find that to be a bit dangerous, but there are others who find it a useful feature.

Thank you for the quick response...
That is what I thought, that the DimensionElementComponentAdd function would change the target parent into a Consolidated element if needed.
My initial test of that did not create the parent/child relationship, and the target parent element remains an N-level element. However, I tried to create the new 'child' element in Metadata and then update the hierarchy in the Data tab of the same TI Process. I am guessing the newly created N-level elements somehow can't be used to assign to a parent within the same TI process.
I will split those actions into separate TI processes.

jcr55 wrote:My initial test of that did not create the parent/child relationship, and the target parent element remains an N-level element. However, I tried to create the new 'child' element in Metadata and then update the hierarchy in the Data tab of the same TI Process.

There's your problem, metadata changes are not valid when done in the Data tab of a TI process. Move your hierarchy maintenance code to the metadata tab and it will work.