Allocate a measure that contains data per week to every date

[kdemulder]

Hello peeps,
Another thing I can't get out of that probably has a simple solution. Powerplay Transformer (7.1)
I have a cube with a lot of different datasources. 2 of them are linked to the margin (you don't wanna know how our datastream is in here... horror). The first one gives the margin for every week, the other one gives them for all older dates. but here's the catch. The last mentioned datasource consists of a table with 3 fields. A store code, a timestamp and a margin. Every date resembles a week. This means that I have to use the margin from that day and allocate it to the other dates of that week as a constant. That way I can roll it up as an average. But I just can't seem to get the allocationtab active. It stays grey. As well as in the time dimension as in the (let's say) Stores dimension. Does anyone know what I'm overlooking? Or am I working the wrong way?

 

[Draoued]

Why don't you stop your time dimension at week level ??

Then you would not need to duplicate the entries for every day.

 

[kdemulder]

Unfortunately no, Cube has other measures and day level is needed for other purposes =/ I'm not quite sure that would work either... All the other days get a zero by default which causes troubles for the average rollup