cube back up

[daya007]

Hi Gurus

I have a requirement where a cube has 4 dims and one of the dimension is Date dimension. Date dimension consists of only one element which is last day date of given month. This dimension will be recreated when ever new date enters into the data base(So that date dim contains only updated date).
Requirement is, users who play with the data in that cube wants to store the data for future purposes. How can we back up this data. How best we can create a new cube to store all the data into it? Please help.

[Alan Kirk]

Hi Gurus

I have a requirement where a cube has 4 dims and one of the dimension is Date dimension. Date dimension consists of only one element which is last day date of given month. This dimension will be recreated when ever new date enters into the data base(So that date dim contains only updated date).
Requirement is, users who play with the data in that cube wants to store the data for future purposes. How can we back up this data. How best we can create a new cube to store all the data into it? Please help.

It would be a straightforward task to:
(a) Build an archive cube which has the same structure as the existing one, except for the last dimension which will have all dates; then
(b) Create a TI which:
(i) Creates a view of the current data;
(ii) Copies the data from that view across to the archive cube; and
(iii) Inserts the new date element and deletes the old one.

But this still strikes me as a "lowering the river rather than raising the bridge" scenario.

Unless the cube is going to be huge or has masses of calculations in it, my preferred option would be to just add the new element into the last dimension each month. DON'T delete the earlier elements, but simply use security to set them to Read Only access.