Is there a way to save multiple versions/generations of a cube? We have a cube that is a snapshot of data at a given point in time. We would like to save the old version of the cube when the new one is built, so that the users may access it to compare to the new version. Users are accessing the cubes via Upfront. I see in Upfront where this can be done for IWR, but I don't see this option available for cubes. Any ideas??? Thanks!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Saving multiple generations of a cube?
- Thread starter mjcotter
- Start date
I don't have IWR, so can't comment on a similar method. AFAIK, there is no ability in PPES to select cube to run a report against as there is in PP Client.
Simplest way to do it is to have two cubes in upfront and report on each. To update it, have a script that kills both cubes, rename 'current' to 'old cube' and then rebuild before re-enabling the cube. Users can then run either report #1 against 'old cube' or report #2 against 'current'.
This is a variant on the best practise for cube building, namely either backing up an existing cube for restore on failure or only over-writing existing if build is successful.
soi la, soi carré
Simplest way to do it is to have two cubes in upfront and report on each. To update it, have a script that kills both cubes, rename 'current' to 'old cube' and then rebuild before re-enabling the cube. Users can then run either report #1 against 'old cube' or report #2 against 'current'.
This is a variant on the best practise for cube building, namely either backing up an existing cube for restore on failure or only over-writing existing if build is successful.
soi la, soi carré
- Status
Similar threads
- Locked
- Question