Page 1 of 1

How to write feeders for the below rules

Posted: Tue Jan 10, 2012 5:07 am
by Radhika
Hi All,

I have the below rules written on a sales cube. I am unaware how to write feeders for the elements part of if loop.

SKIPCHECK;
['Result_Rate']=n:if (['Rate']<>0,['Rate'],DB('FeeRates_PP',!Partnerships,!Version_64,!Year, ATTRS('RateMonth',!RateMonth,'PriorMonth'),'Result_Rate',!FeeBands));
['Result_Band']=n:if (['Band'']<>0,['Band''],DB('FeeRates_PP',!Partnerships,!Version_64,!Year, ATTRS('RateMonth',!RateMonth,'PriorMonth'),'Result_Band',!FeeBands));
Feeders;

Please help me.

Thanks,
Radhika

Re: How to write feeders for the below rules

Posted: Tue Jan 10, 2012 5:27 am
by Gregor Koch
Hi
Maybe start by
1. reading some of the other posts on Feeders as this could/should be quite an easy one
2. posting a rule that actually would compile, or does it really?
3. after reading other posts on feeders posting the required information so others are able to help you

Cheers

Re: How to write feeders for the below rules

Posted: Tue Jan 10, 2012 9:27 am
by David Usherwood
I'll be somewhat more explicit than Gregor (though I agree with him).
Repeat after me, 1, 2,3 ....
Rates_don't_need_feeding!
You apply a rate to something else eg Value = Quantity x Price . Feed from Quantity.

Re: How to write feeders for the below rules

Posted: Tue Jan 10, 2012 9:59 pm
by Gregor Koch
True, true.

Re: How to write feeders for the below rules

Posted: Tue Jan 10, 2012 10:24 pm
by rmackenzie
David Usherwood wrote:Rates_don't_need_feeding!
Sometimes you might feed values simply so they will display in zero-suppressed view... hard to say if this applies in the case of the OP's question.

Radhika - there is information online that will help you with basic information about how feeders work