TM1/Rules

Post Reply
Santiago
Posts: 13
Joined: Fri Jul 30, 2010 2:18 pm
OLAP Product: TM1
Version: TM1 9.5
Excel Version: Excel 2003

TM1/Rules

Post by Santiago »

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
User avatar
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

Post by rkaif »

Santiago wrote:Hi all
I have a doubt
To clear your doubts you need to read the Manual. Here is a link for you:

http://publib.boulder.ibm.com/infocente ... gTM1_.html
Cheers!
Rizwan Kaif
User avatar
RTFM
Posts: 2
Joined: Fri Oct 01, 2010 12:30 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: TM1/Rules

Post by RTFM »

rkaif wrote:
Santiago wrote:Hi all
I have a doubt
To clear your doubts you need to read the Manual.
@Rizwan,

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.
Wim Gielis
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

Post by Wim Gielis »

RTFM wrote:
rkaif wrote:
Santiago wrote:Hi all
I have a doubt
To clear your doubts you need to read the Manual.
@Rizwan,

Did you actually try to understand the question?
And it's you who says this? With a username like that... ;-)

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
Post Reply