Feeders: rule based on constant values

Post Reply
Patrick Gr
Posts: 5
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: 3656
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

Duncan P
Posts: 588
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: Feeders: rule based on constant values

Post by Duncan P » Tue Nov 27, 2018 8:00 pm

I presume you are building the product dimension with a TI. This is setting the parent(s) for each "activity" in the product dimension. Can the data tab of the TI not just set the appropriate cell values (having cleared ['displayElement'] with a view)?

Rules are good for the dynamic things. This is setting values based on hierarchy structure which is not dynamic.

Or have I missed some new development in the 5 years I've been out of the game?

User avatar
Steve Rowe
Site Admin
Posts: 1870
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Feeders: rule based on constant values

Post by Steve Rowe » Wed Nov 28, 2018 9:28 am

As Duncan said, if you are trying to flag valid intersections (maybe for some kind of data entry form where the rows in the input space are zero and there is nothing to drive to suppression) then do this in a TI process and populate the intersection directly. This could be chained with whatever mechanism you are using to maintain your product structure.

Post Reply