TM1 Forum

Hi,
I have one doubt, if I had Uneven hierarchy in the 21 st level element, which is consolidate element with out any child.
I can write only maximum of 19 Else If statement, then how to write a script for such scenarios.
Can Suggest me please.

TM1 9.5.2
excel 2007
Thanks and reagrds

Hi

What is the reason for that consolidated element without children?

For the script: what situation (in plain English) are you trying to write a script for?

Like Wim Gielis has stated, more information is needed since depending on the situation the way in which you would try to avoid the 20 nest limit changes.

In your situation however I may be wrong (and its very possible considering I don't really understand most of what you said) but if you are simply doing your If statement on what level the element exists at you don't really need an elseif considering it is only ever going to exist at 1 level (unless you're doing something peculiar).