country
-city
- building
this is my dimension hierarchy. i want to add a element city-building not available at building position whenever a new city come. I am using TI process to make dimension.i cant edit the source file.
adding elements in dimesnion using TI
-
- Regular Participant
- Posts: 424
- Joined: Sat Mar 10, 2012 1:03 pm
- OLAP Product: IBM TM1, Planning Analytics, P
- Version: PAW 2.0.8
- Excel Version: 2019
Re: adding elements in dimesnion using TI
Hi Please go through below functions,It will give you an idea:
https://www.ibm.com/support/knowledgece ... ons_N71607
http://public.dhe.ibm.com/software/data ... 1_turb.pdf Thanks
https://www.ibm.com/support/knowledgece ... ons_N71607
http://public.dhe.ibm.com/software/data ... 1_turb.pdf Thanks
"You Never Fail Until You Stop Trying......"
-
- Posts: 10
- Joined: Mon Sep 18, 2017 9:12 am
- OLAP Product: tm1
- Version: 10.2.2
- Excel Version: 2010
Re: adding elements in dimesnion using TI
abdul i am new to tm1, i created dimesnion according to the source file.BariAbdul wrote: ↑Wed Sep 20, 2017 11:07 am Hi Please go through below functions,It will give you an idea:
https://www.ibm.com/support/knowledgece ... ons_N71607
http://public.dhe.ibm.com/software/data ... 1_turb.pdf Thanks
cityname1
building 1
building 2
cityname2
building 1
building 2
see in upper example for both cityname1 and cityname2 i want a child cityname - building not applicable.In my source i have 40 cities for every city i need to follow that.
-
- MVP
- Posts: 3120
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: adding elements in dimesnion using TI
You could use code like:
Code: Select all
DimensionElementInsert( ‘dim’,’’,vCity,’C’);
DimensionElementInsert( ‘dim’,’’,vCity | ‘ - Building NA’,’N’);
DimensionElementComponentAdd( ‘dim’,vCity,vCity | ‘ - Building NA’,1);
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly