I have a time dimension (Year->Month->Week) and region dimension
(Region->Location) with measures as Revenue $, Cost $ and Cost %.
Users can define Cost as $ or % of Revenue. Also have a calculated
measure as Final Cost. Final Cost is equal to Cost % of Revenue or
Cost $, whichever is defined by user. Cost % takes priority over Cost
$.
Problem is that when user defines Cost % at month level, cube
distributes to each week as Month %/4 (because of equal allocation).
This messes up my weekly Final Cost, which has to be Month %
multiplied by Revenue for week.
Is there any way, by means of allocation I can make this work. Is it
possible that at month level I can see Month%*Month Revenue $ and at
week level Month%*Week Revenue $.
Any help is appreciated.

Thanks,
Manish