How to write feeders for the below rules
Posted: Tue Jan 10, 2012 5:07 am
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
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