Page 1 of 1
Feeder Issue
Posted: Wed Jun 20, 2012 10:20 am
by Cognostm1.ibm
Hi Gurus,
I have a feeder which doesnt seems to work correctly.
I am getting wrong totals with below one.
Rule:
[2012, 'Amount'] = N:DB('OC_ Exp_Input',!OC_Account_Rollup,!OC_Cost_Center,!OC_Entity,’2012’, !Time, 'Amount');
Feeder:
['Amount'] => ['2012'], ['Amount'];
Can you provide your valuable suggestions to fix this one...
Thanks,
Appz
Re: Feeder Issue
Posted: Wed Jun 20, 2012 10:41 am
by Paul Segal
Cognostm1.ibm wrote:Hi Gurus,
I have a feeder which doesnt seems to work correctly.
I am getting wrong totals with below one.
Rule:
[2012, 'Amount'] = N:DB('OC_ Exp_Input',!OC_Account_Rollup,!OC_Cost_Center,!OC_Entity,’2012’, !Time, 'Amount');
Feeder:
['Amount'] => ['2012'], ['Amount'];
Can you provide your valuable suggestions to fix this one...
Thanks,
Appz
The feeder needs to go in the cube you are getting the numbers from (i.e. OC_Exp_Input), and not the cube you are writing the rule for, so that it pushes the feed (rather than trying to pull the feed as you have it here).
Re: Feeder Issue
Posted: Wed Jun 20, 2012 10:45 am
by Cognostm1.ibm
Thanks a lot for immediate response.
Could tell me what could be the right feeder for this one...
Re: Feeder Issue
Posted: Wed Jun 20, 2012 11:51 am
by Wim Gielis
In the cube OC_Exp_Input, add a feeder by typing:
['2012','Amount']=>
then hit the DB() function button and pick the needed/corresponding elements.
Close the statement with ;
Re: Feeder Issue
Posted: Wed Jun 20, 2012 2:13 pm
by Cognostm1.ibm
Thanks a lot!!!