Feeders: rule based on constant values

Post Reply
Patrick Gr
Posts: 2
Joined: Tue Feb 20, 2018 8:56 am
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Feeders: rule based on constant values

Post by Patrick Gr » Thu Oct 11, 2018 1:28 pm

Hello community,

On my cube, I have a rule line that contains

['displayElement']=N:IF(ELISANC('product', !Activity , !Product )=1, 0.0000001 ,0);

Can you guys help me in feeding this line of the rule ? this rule is based on constant value. I can give more information if needed.
Thanks in advance for your collaboration!

User avatar
jim wood
Site Admin
Posts: 3599
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA

Re: Feeders: rule based on constant values

Post by jim wood » Thu Oct 11, 2018 1:32 pm

Normally you've got 3 options with this:

1) Don't feed it
2) Feed with with an element constant (an example that's not related may be price)
3) Variable feed from the constant, which may be an issue if your variable is constantly changing

You may want to also look at making the element a consolidation of something related. That would avoid the need for a feeder at all but it just doesn't look very pretty,

Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

Post Reply