Possible reasons for a single cell not being fed

[dubs]

Hi All,

I've exhausted my limited knowledge of feeders trying a crack a problem i have with one calc'd cell not being fed.

I have an calculated element which works for 99% of my cells but for some reason a cell at a particular intersection is not being fed. I've stripped the feeder right down to it's most basic logic (ie feeding it with the entire cube area using [] ) but it's still not working- for some reason one element in my dimension will not be fed but it is no different to any of the cells that are being fed in terms of it composition- ie it's not composed of calculated or consolidated cells

so i have two N Level elements (A) & (B), a calc is done to derive the value for an element on a separate dimension which gets fed when referencing element (A) but doesn't get fed when referencing element (B) both elements (A) & (B) are themselves not calculated, fed or consolidated, are of type N and have the same weighting.

Could anyone list the possible reasons for this? as i say i'm not very experienced with feeders but have used a process of elimination to get this far and just can't work it out any further.

Cheers

dubs

[Martin Ryan]

Hi dubs, could you please post the rule and feeder in question?

Martin

[dubs]

Hi Martin,

The rule in question is this (i've also tried it without the N:):

Code: Select all

['PVR']=N:['Half Year', 'Predicted']-['Real'];

i've tried numerous feeders all of which don't feed a particular cell:

i started with this (i also tried changing the order of the 'Half Year' and 'Predicted') :

Code: Select all

['Half Year', 'Predicted']=> ['PVR'];
['Real']=>['PVR'];

then tried this (just to simplify the feeder to see if was my original feeder syntax):

Code: Select all

['Predicted']=> ['PVR'];
['Real']=>['PVR'];

then tried this just as a sanity check:

Code: Select all

[]=> ['PVR'];

each time the calculated figure doesn't appear when supress zeros is on and shows not fed when you do a 'check feeders' on it.

cheers

[Michel Zijlema]

Hi dubs,

Are the 'PVR', 'Predicted' and 'Real' elements in the same dimension? Is the 'Half Year' element a C or a N level element? Maybe you can elaborate a bit on the dimensionality of your model and the required calculation?
How is the spread over the other dimensions (f.i. time) for the areas used in the rules? In what area does the feeding fail? If you have 'predicted' values in one part of the cube and 'real' in another part and the combined 'pvr' value leads to calculating values for f.i. time periods that are not in either ['Half Year', 'Predicted'] or ['Real'] than there is your feeding problem.

Michel

[Steve Rowe]

Hi Dubs,
That's strange what you have written should be working if ['Half Year', 'Predicted'] and ['Real'] are both N level input fields.
As Michael says, we need information on the dimensionality of the system to understand more about what's happening.
Perhaps if you screen shot the area of the cube that is not fed and where you think the feeder cells are that will give us some clues...
Good luck!

[dubs]

Hi Michael,

The 'PVR', 'Predicted' and 'Real' are all in the same dimension and are all N level.

The 'Half Year' element is in another dimension and is C level, but i have tried setting the feeder to use the N: level child of 'Half Year' and that didn't work either.

The 'Real' is valid for all time periods so setting the cell to be fed by 'Real' should be valid.

The desired calculation is to subtract the 'Predicted' amount for the 'Half Year' (where the 'Half Year' is a consolidation of 'Half Year Amount' and 'Adjustment') from the 'Real' value.

ill try and sketch it out as i can't post screen shots (due to security constraints here)

2 N Level Account Elements (A) & (B)

3 Measure Elements 'PVR' 'Predicted' and 'Real'

2 Time Elements '05' and 'Half Year' (which is the C level of two N elements 'Half Year Amount' and 'Adjustment')

('A','05') should equal ('Predicted', 'Half Year') - ('Real','05')

('Predicted', 'Half Year') should equal ('Predicted', 'Half Year Amount') + ('Predicted', 'Adjustment')
('Real','05') is an absolute (not calculated or consolidated) value

Whilst this calculates correctly for (A) & (B) only (A) gets fed - so when i turn on supress zero's (A) stays but (B) dissapears.

What i've done it to try and feed the whole cube area to the calculation to see if it was my feeder syntax but it made no difference

i have a feeling it's something dumb im doing but can't see the wood for the trees.

i hope i've explained it well enough, if not ill see if i am allowed to post screen shots.

thanks

[Martin Ryan]

Hi Dubs,

I think your problem is that your source is the 'Half Year', but the calcualtion may not necessarily be in the same 'Half Year'. Try a feeder like so

Code: Select all

[Predicted] => ['PVR', 'Consolidation of _All_ Elements in the dimension that Half Year is in'];
['Real'] => ['PVR'];

Cheers,
Martin

[dubs]

Hi Martin,

This works! just going to work out why it works but it's solved my problem.

Thanks very much!

dubs