Skip to Content
0
Former Member
Feb 26, 2014 at 10:46 AM

concatenate text and property of dimension in script logic

214 Views

hello experts,

how to concatenate text and property of dimension in script logic?

as example:

dimension : interco

property : mgmtallocdefcc

*WHEN TIME.YEAR

*IS %YEAR_VAR%

*REC(EXPRESSION=%VALUE%,ACCOUNT=12345,ENTITY="I_" [INTERCO],MGMTALLOCDEFCC)

*NEXT

then it will read all as text: I_[INTERCO].MGMTALLOCDEFCC

for example the value of property mgmtallocdefcc in interco dimension (INTERCO.MGMTALLOCDEFCC) is ABCDE.

what i expect is :I_ABCDE

thanks!