adding elements in dimesnion using TI

Post Reply
raman
Posts: 10
Joined: Mon Sep 18, 2017 9:12 am
OLAP Product: tm1
Version: 10.2.2
Excel Version: 2010

adding elements in dimesnion using TI

Post by raman »

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.
BariAbdul
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

Post by BariAbdul »

"You Never Fail Until You Stop Trying......"
raman
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

Post by raman »

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
abdul i am new to tm1, i created dimesnion according to the source file.
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.
Wim Gielis
MVP
Posts: 3105
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

Post by Wim Gielis »

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
Post Reply