How to write feeders for the below rules

Post Reply
Radhika
Posts: 97
Joined: Mon Sep 27, 2010 6:49 am
OLAP Product: IBM Cognos TM1
Version: v9.4.1
Excel Version: Microsoft Excel 2003

How to write feeders for the below rules

Post 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
Gregor Koch
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

Post 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
David Usherwood
Site Admin
Posts: 1457
Joined: Wed May 28, 2008 9:09 am

Re: How to write feeders for the below rules

Post 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.
Gregor Koch
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

Post by Gregor Koch »

True, true.
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: How to write feeders for the below rules

Post 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
Robin Mackenzie
Post Reply