TM1 Forum

Hey Guys and Gals!

Just like to know if there are way in which you can consolidate strings within a dimension? The result at the Parent level should be a concatenation of all the children elements of the Parent.

Can this be done in rules or is it a job for TI?

Been working with TM1 for 3 years now but have never needed to this until now. I am stumped, can think of a way to do this, so please someone rescue me!

Cherio!

Hi par3

TI is the (only ?) way to go here.

I guess it is the only way since you cannot loop over elements in a rule. You know the number of components of a consolidation (ELCOMPN), but you cannot form the string with a loop say from component 1 to n.

Wim

I think the logic to this is like the rule solution I've proposed at the end of this post http://forums.olapforums.com/viewtopic. ... 510#p11510 I think you might be able to adapt this to concatenate the strings rather than multiply values.

It maybe that TI is a better approach though....