Hello all - Can someone tell me on how do we track changes made to maybe a cube, TI for instance done by users? and how do we rollback if we have to? thanks. HKR
TM1 logs all data changes, unless you turn logging off for specific cubes. (Note the default behaviour for TI processes is to turn logging off at the start and back on at completion.)
Changes are written to tm1s.log, in csv format. A record holds the cube, cell coordinates, local and UTC timestamps, before and after values, and the user.
When you 'commit' with a SaveDataAll, the server closes the current log file, renames it with a timestamp in the name, and opens a new one. (It also updates the cubes on disc.)
You can query the changes by selecting 'View Transaction Log'. Here you can select by cube, user and dimension(s). You can also rollback a set of changes. The UI for this is 'OK' but no more - and I'm not aware of any possibility to treat the log as a pseudo relational table (for instance) as it's really a set of flat files.
HTH
Thanks very much.