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 » Wed Sep 20, 2017 10:53 am

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: 403
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: TM1,Cognos
Version: 9.5.2
Excel Version: 2007

Re: adding elements in dimesnion using TI

Post by BariAbdul » Wed Sep 20, 2017 11:07 am

"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 » Wed Sep 20, 2017 11:22 am

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: 1538
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: adding elements in dimesnion using TI

Post by Wim Gielis » Wed Sep 20, 2017 10:49 pm

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

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 103 TM1 articles and a lot of custom code
Newest blog article: TM1 message log analysis with Power Query

Post Reply