Audit trail

Post Reply
daya007
Posts: 49
Joined: Fri May 28, 2010 4:47 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003
Location: IL, USA

Audit trail

Post by daya007 »

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

Re: Audit trail

Post by Martin Ryan »

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
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