Feeder Question

[TomHine]

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

[qml]

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.

[TomHine]

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

[Steve Rowe]

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,

[qml]

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.

[TomHine]

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