I have a temp cube which calculates an average usage over a dynamic rolling period. This is recalculated daily.
For reporting purposes, I now need to write this entry into a history cube by day, so that I can trend the results.
The temp cube is dimensioned purely by "device code" which is the entity it is calculating the average for.
The history cube will need to be dimensioned by "device code" and "day".
As it stands, I tried writing a procedure which flags "Today" and then writes the entry into today's date. This works, however it just seems to keep the entry for today..... there is no entry for yesterday. I have not got a "Clear cube" in the procedure.