TM1 Forum

Hi,

I have a requirement where user enters data through excel application to save data into the cube. But user also want to audit trail the change. He want to track who recently changed it. And that info must show in a column of excel and should write back to cube when he clicks recal button. How can we do this...please shed some ideas..

Audit data is available automatically with TM1 - search for "transaction log" in the manuals.

The normal way of working with TM1 is that as soon as you finish typing a number into TM1 it is stored in TM1 and available for other users to see.

If you wish to have a submit functionality then you either have to use the Sandboxing tool, which is only available from version 9.5.1 (or possibly 9.5.0). If your version is older you may have to make use of Excel tools and TM1's DBS formula.

Martin