Can a TI change a dimension element Type from N to C?

Post Reply
jcr55
Posts: 54
Joined: Tue May 08, 2012 3:58 pm
OLAP Product: TM1
Version: 9.5.2 FP2
Excel Version: Excel 2007

Can a TI change a dimension element Type from N to C?

Post by jcr55 »

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?
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Can a TI change a dimension element Type from N to C?

Post by Alan Kirk »

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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
jcr55
Posts: 54
Joined: Tue May 08, 2012 3:58 pm
OLAP Product: TM1
Version: 9.5.2 FP2
Excel Version: Excel 2007

Re: Can a TI change a dimension element Type from N to C?

Post by jcr55 »

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.
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Can a TI change a dimension element Type from N to C?

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply