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
Feeder Issue
-
- 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
-
- 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
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).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
Paul
-
- 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
Thanks a lot for immediate response.
Could tell me what could be the right feeder for this one...
Could tell me what could be the right feeder for this one...
-
- 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
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 ;
['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
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
-
- 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
Thanks a lot!!!