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
How to write feeders for the below rules
-
- MVP
- Posts: 263
- Joined: Fri Jun 27, 2008 12:15 am
- OLAP Product: Cognos TM1, CX
- Version: 9.0 and up
- Excel Version: 2007 and up
Re: How to write feeders for the below rules
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
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
-
- Site Admin
- Posts: 1457
- Joined: Wed May 28, 2008 9:09 am
Re: How to write feeders for the below rules
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.
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.
-
- MVP
- Posts: 263
- Joined: Fri Jun 27, 2008 12:15 am
- OLAP Product: Cognos TM1, CX
- Version: 9.0 and up
- Excel Version: 2007 and up
Re: How to write feeders for the below rules
True, true.
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: How to write feeders for the below rules
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.David Usherwood wrote:Rates_don't_need_feeding!
Radhika - there is information online that will help you with basic information about how feeders work
Robin Mackenzie