feeder consolidate to leaf

[rozef]

Hi everyone,

my feeder problem is I need to feed some (Actual / YTD) on (Budget / month)
my time dimension is builded that way:

(Conso) YTD M
| - Month M (Leaf)
| - YTD m-1 (Conso)

A feeder like that will works:
[Actual, YTD M4] => [Budget, M4]

I'm looking for something more dynamic:
[Actual]=> DB( SameCube, Budget, ELCOMP('Time', !Time, 1) ... );
But it don't works like that.

Any Idea is welcome.

[rozef]

Finally, I found the answer:

[Actual, YTD M12]=>[Budget, YTD M12];

As al months ans consolidated months are childrens of 'YTD M12' it works.
But I dont understand why a simply "Actual => Budget" won't work.

regards

[Christopher Kernahan]

Hi rozef,

A bit confused, do you want Budget Month to equal Actual YTD?

If your Month dimension is setup like 'Jan', 'Jan YTD' etc, you could put a text attribute on Month called 'Prior Month', such that 'Mar' has the attribute 'Feb'.

Then use a rule;

['Budget'] = N:
DB( 'Actuals', ATTRS( 'Month', !Month, 'Prior Month') | ' YTD', etc.