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
Multiple hierarchies
-
Wim Gielis
- MVP
- Posts: 3241
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Multiple hierarchies
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?
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?
Best regards,
Wim Gielis
IBM Champion 2024-2025
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
Wim Gielis
IBM Champion 2024-2025
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
-
declanr
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Multiple hierarchies
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).
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).
Declan Rodger