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?
Can a TI change a dimension element Type from N to C?
-
- 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?
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.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?
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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?
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.
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.
-
- 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?
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.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.