Feeders for data from multiple cubes

[manne]

Hi,

I have tried to find a similar Topic for my Problem, but no luck and if I missed it, I am apologized for posting this Kind of question again.

I Need help on Feeders for a cube where I am feeding data from 2 other cubes to do an calculation. I have written the following rule and it works fine, unless that at consolidation Level the values are Zero, due to no Feeders.

['VAL' ] = N : DB('Cube1', !YEAR, !PERIODE, !SALESCODES, !PNR ) * DB('Cube2', 'TOTAL', 'ACTUAL', !YEAR, !PERIODE, 'MP', 'ALL_DEPT_TYP', !DEPT, 'ALL_FTE', 'ALL', 'ALL_POSITIONS', !ROLES, !PNR, 'FTE');

Do I Need Feeders in both cubes where I am feeding the data from and if so, how do I Need to set These ? and / or do I Need also a Feeder in the cube where I wrote the rule ?

Thank you for your assistance.....Manfred

[Steve Rowe]

Hi Manfred,

Suggest you re read the documentation as your questions suggest you have not yet grasped their purpose, you're not alone though, they are a little odd.

A feeder flags a ruled cell for calculation.

Your calc is a=b * c

You need to create a flag (via a feeder statement) for all cases where "a" will evaluate to a non-zero value.
You need to minimise the amount of feeder flags created so that you minimise the amount of calcs that return zero (and so waste calculation cycles).
The flags only exist at the N level, feeding a consolidation is short hand for feeding all the N levels underneath it. This is an area to be very careful of.

a will not be zero if at least one of b and c are populated. So you can write a feeder statement from either b or c. You don't feed from b and c since in the case where both are populated the second feeder statement is redundant.

Typically you would write the feeder statement against the least populated component or the one that results in the least amount of over-feeding (i.e. calculations that result in zero). This will usually be the component that most matches the dimensionality of the calculated value.

HTH with your understanding.

Cheers,

[manne]

Hi Steve,

thanks for coming back that quickly.

I was confused with the info that you Need to put the Feeders in the cubes where you feed from, I understood that I had a write a Feeder for the pulling and not a "normal Feeder" in the cube where I am feeding from.

I will see if I get it now worked out.

Thank you,

Manfred