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!!!