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 trail
- 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
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
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
Jodi Ryan Family Lawyer