TM1 Forum

Hi expert,

Is there a way to commit specific data from a Sandbox.
OR, revert specific data to the base.

Here is what happened: user made a lot of changes in his sandbox. one of the changes made very early is not good. he needs to bring it back to base, Or commit everything else except this one.
I can see the _delta cube, but dont know how to read it.

Thanks

If the cube where the changes were made in sandbox has LOGGING enabled and there isn't an entry "EnableSandboxTransactionLog=F" in the tm1s.cfg file, there should be sandbox transaction logs in your logging directory. There should be a folder "sandboxlogs" in your logging directory and within there, individual client folders with their own transaction log files. I don't believe you can query/revert transaction changes for these sandbox logs in Architect like you can the server transaction log, but it may help you identify the bad transaction and then manually revert the value in the cube.

I found this post helpful: https://www.tm1forum.com/viewtopic.php?t=13276

Regarding only committing specific slices of data from a sandbox, I'm not aware of that being possible. A user can however run a TI against their private sandboxes. Assuming you could discriminate what values to skip, you could create a process for the user to export their sandbox data to CSV (skipping the corrupted data of course) and then a separate import that writes to base. ServerActiveSandboxSet and SetUseActiveSandboxProperty are two functions you'll want to be familiar with before attempting this method.

Oh wow. Thanks. Never thought of the logging enablement.
I 'resolved' the problem by asking the user to download to excel the data he wants to keep and loading it using TI.
Why make it simple when you can complicated it.
But THANKS, I will look into the logging thing.

micheline