Revert Back the Changes in cube

Post Reply
dilip
Posts: 128
Joined: Thu Dec 15, 2011 8:22 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Revert Back the Changes in cube

Post by 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
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Revert Back the Changes in cube

Post by 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.
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Post Reply