Hi all
I have a doubt. As I can do to make the left side of the cube rule can refer only to children of certain parent (consolidated) in one dimension. Also, as a reference on the left side of the rule to consecutive elements without having to list them all.
Thank you very much to all
Best regards
TM1/Rules
- rkaif
- Community Contributor
- Posts: 328
- Joined: Fri Sep 05, 2008 6:58 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.1 or later
- Excel Version: 2003 or later
Re: TM1/Rules
To clear your doubts you need to read the Manual. Here is a link for you:Santiago wrote:Hi all
I have a doubt
http://publib.boulder.ibm.com/infocente ... gTM1_.html
Cheers!
Rizwan Kaif
Rizwan Kaif
Re: TM1/Rules
@Rizwan,rkaif wrote:To clear your doubts you need to read the Manual.Santiago wrote:Hi all
I have a doubt
Did you actually try to understand the question?
@Santiago,
I'm not sure whether I understand your question - if you're wondering whether you can refer to a list of elements in the area definition of the rule by using a consolidated element, than the answer is no. But you can use f.i. the ElIsAnc fuction in the formula part of the rule to make the rule apply only to N level elements underneath a certain node.
-
- MVP
- Posts: 3120
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: TM1/Rules
And it's you who says this? With a username like that...RTFM wrote:@Rizwan,rkaif wrote:To clear your doubts you need to read the Manual.Santiago wrote:Hi all
I have a doubt
Did you actually try to understand the question?
Santiago,
Use the elisanc, eliscomp, elispar functions. Or you attributes to decide what elements are affected.
Functions go on the right hand side of a rule, NEVER on the left hand side.
Wim
Best regards,
Wim Gielis
IBM Champion 2024
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
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