Feeder Issue

Post Reply
Cognostm1.ibm
Posts: 20
Joined: Tue Dec 27, 2011 3:31 pm
OLAP Product: Cognos TM1
Version: 9.5.1 and 9.5.2
Excel Version: 2007 and 2010

Feeder Issue

Post 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
Paul Segal
Community Contributor
Posts: 314
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: TM1 11 and up
Excel Version: Too many to count

Re: Feeder Issue

Post 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).
Paul
Cognostm1.ibm
Posts: 20
Joined: Tue Dec 27, 2011 3:31 pm
OLAP Product: Cognos TM1
Version: 9.5.1 and 9.5.2
Excel Version: 2007 and 2010

Re: Feeder Issue

Post by Cognostm1.ibm »

Thanks a lot for immediate response.

Could tell me what could be the right feeder for this one...
Wim Gielis
MVP
Posts: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Feeder Issue

Post 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 ;
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Cognostm1.ibm
Posts: 20
Joined: Tue Dec 27, 2011 3:31 pm
OLAP Product: Cognos TM1
Version: 9.5.1 and 9.5.2
Excel Version: 2007 and 2010

Re: Feeder Issue

Post by Cognostm1.ibm »

Thanks a lot!!!
Post Reply