Hi All,
We are having a cube with four dimensions.
Rule:
['elem1','elem2']=N:
IF(DB('Cube1',!dim1,!dim2,!dim3,'element')@<>'Y',0,1);
There is a feeder written in existing code, but my feeling is "do we really need to write feeder for above rule?"
Can someone please share info regarding feeder for above rule?
Regards,
Deepak Jain
Do we need feeders
-
- Regular Participant
- Posts: 152
- Joined: Sat May 25, 2013 10:32 am
- OLAP Product: TM1
- Version: 9.5.2; 10.2.2
- Excel Version: 2007
- qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Do we need feeders
Surely it is you who should answer that question based on your knowledge of the model which you are not sharing here...
Do you need the rule-calculated numbers to consolidate? Do you need to see them in zero-suppressed views? Do you need to use the calculations in zero-suppressed data sources (e.g. exporting data to a file)? If the answer to at least one of these questions is yes then you do need to feed that rule. How to feed it smartly and not overfeed is another matter altogether.
Do you need the rule-calculated numbers to consolidate? Do you need to see them in zero-suppressed views? Do you need to use the calculations in zero-suppressed data sources (e.g. exporting data to a file)? If the answer to at least one of these questions is yes then you do need to feed that rule. How to feed it smartly and not overfeed is another matter altogether.
Kamil Arendt
-
- Regular Participant
- Posts: 152
- Joined: Sat May 25, 2013 10:32 am
- OLAP Product: TM1
- Version: 9.5.2; 10.2.2
- Excel Version: 2007
Re: Do we need feeders
Hi qml,
Based on questions, yes I will have to feed them.
Is it good to go with conditional feeders for rules written in below manner?
['elem1','elem2']=N:
IF(DB('Cube1',!dim1,!dim2,!dim3,'element')@<>'Y',0,1);
If you have any other suggestions please share.
Regards,
Deepak Jain
Based on questions, yes I will have to feed them.
Is it good to go with conditional feeders for rules written in below manner?
['elem1','elem2']=N:
IF(DB('Cube1',!dim1,!dim2,!dim3,'element')@<>'Y',0,1);
If you have any other suggestions please share.
Regards,
Deepak Jain
-
- MVP
- Posts: 3241
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Do we need feeders
Yes, a conditional feeder will do.
Best regards,
Wim Gielis
IBM Champion 2024-2025
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-2025
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
-
- Community Contributor
- Posts: 324
- Joined: Mon Jul 02, 2012 9:39 pm
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: 2016
- Location: Sydney, Australia
Re: Do we need feeders
You definitely can, as Wim suggested. However, your question is too generic.... else you could look at avoiding conditional feeding by different structure/rule designYes, a conditional feeder will do.