企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 882|回复: 5

Feeder Question

[复制链接]

76

主题

396

帖子

582

积分

高级会员

Rank: 4

积分
582
QQ
发表于 2014-6-29 14:44:43 | 显示全部楼层 |阅读模式
Hi,

Forgive my ignorance as far as feeders are concerned but I'm a bit stuck and some help would be much appreciated.

I have a feeder rule in my cube which is using a consolidated element to feed a cash flow element.

The issue I have that the consolidation includes the element 92096 which I don't want to be included in the CF Other Creditores element. Is it possible to either ignore that element or subtract it in another feeder?

['Other Creditors']=>['CF Other Creditors'];
['Other Creditors']=>DB('Reporting','CF Other Creditors',!Cost Centre,!Scenario,!Contract,!Department,!Work Stream,ATTRS('Time',!Time,'Next_Period'));

Any assistance is gratefully received.

Regards
Tom
回复

使用道具 举报

81

主题

389

帖子

575

积分

高级会员

Rank: 4

积分
575
QQ
发表于 2014-6-29 17:06:17 | 显示全部楼层
You need to understand that feeding from a consolidation is just a shordhand notation for feeding from all its children.

If you leave the feeders as is, the worst case scenario is that there might be some slight overfeeding (only where 92096 is non-zero where other accounts under Other Creditors are zero), which should not be a big issue. If you want to solve it then just create another consolidation element that won't contain 92096 and feed from it.

You haven't provided the rules to go with these feeders, so I will assume that you have no issues with that side of things.
回复 支持 反对

使用道具 举报

57

主题

378

帖子

507

积分

高级会员

Rank: 4

积分
507
发表于 2014-6-29 18:01:48 | 显示全部楼层
HI,

Thanks for the reply.

The associated rules are working OK it's only this feeder. The issue is that there is quite a large figure in the 92096 element which is being feed into two places (using the consolidation) but only one should include 92096. I was hoping that I'd be able to back out the element from one target without having to create another consolidation in what is already a large cube.

Thank you for your help any way.

Tom
回复 支持 反对

使用道具 举报

83

主题

421

帖子

617

积分

高级会员

Rank: 4

积分
617
QQ
发表于 2014-6-29 18:39:51 | 显示全部楼层
Hi Tom,
You may be looking at the problem wrong, not sure.

Feeders just flag a cell to be calculated or not, the size of the value that is doing the feeding is not relevant to anything.  (Unless that value is itself the result of a long and complicated calculation chain).

In general, if you are getting the wrong results from your calculation then it is the rule that is wrong not the feeder.

Cheers,
回复 支持 反对

使用道具 举报

86

主题

397

帖子

596

积分

高级会员

Rank: 4

积分
596
QQ
发表于 2014-6-29 19:05:00 | 显示全部楼层
I agree with Steve, it does sound like you might not really understand how rules and feeders work.

Post your whole code (rules + feeders for both cubes) here with a description of what you would expect it to do vs what it's doing at the moment.
回复 支持 反对

使用道具 举报

58

主题

393

帖子

540

积分

高级会员

Rank: 4

积分
540
QQ
发表于 2014-6-29 19:05:47 | 显示全部楼层
Hi,

You we're all right (of course) I was missing the point of feeders.

I went back into the rules and found the one that was causing the issue and amended it and it's working fine now.

Thanks for your help with the feeder bit as I now understand them a whole lot better.

Regards

Tom
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2019-3-23 10:23 , Processed in 0.176775 second(s), 11 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表