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!
Feeders: rule based on constant values
-
- Posts: 10
- Joined: Tue Feb 20, 2018 8:56 am
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2010
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Feeders: rule based on constant values
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,
Jim.
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,
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- MVP
- Posts: 600
- 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
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?
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?
- Steve Rowe
- Site Admin
- Posts: 2416
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Feeders: rule based on constant values
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.
Technical Director
www.infocat.co.uk
www.infocat.co.uk