Revert Back the Changes in cube

[dilip]

Hi,

I have developed one cube let Say PY cube which contains previous year data and I have done the calculation(by applying all the rules) and many other cubes also i developed are dependent on this cube i.e PY cube. suppose the data in the cube was old data coming from database...Now suppose my requirement is that if Iam user I want my old data as well as the the changes which i have done in the cube(with old data) i.e i want to revert back my all the changes...what I have done before..if Iam not satisfied with the new data coming from database and loading into cube and changes I have done in my new data...this is a scenario.. can you please suggest.


Thanks

[Martin Ryan]

I don't think the answer to this one can found in the manual, at least not directly, so...

Use two Scenarios - "Base" and "Adjustments", plus a consolidated element called "Base + Adjustments" that sums the two. Then the user could report any of those three scenarios.

TM1 doesn't have the concept of journalling. While you can build this type of functionality in, it's not recommended.