Page 1 of 1
How to capture who edited TM1 cube?
Posted: Tue Dec 18, 2018 8:14 am
by tjbalaji85
For example In employee cube, If someone initiate transfer for an employee from one department to another department, is there a way to capture the userid of user who initiated the transfer using transaction log?
I can read these details in transaction log of the cube, but wanted to know how to capture the user details who initiated the transfer in another cube for auditing purpose using tm1s log file.
Thank you
Re: How to capture who edited TM1 cube?
Posted: Tue Dec 18, 2018 5:10 pm
by Wim Gielis
Hello,
Welcome to the forum. Can you please post questions in the correct subforum ?
As to the question, I don't understand what you mean. In the transaction logs, I do see the user name that initiated the change. For manual entry (in yellow the username):
- 06.png (21.66 KiB) Viewed 3605 times
If it's done via TI:
Wim
Re: How to capture who edited TM1 cube?
Posted: Tue Dec 18, 2018 6:56 pm
by jim wood
Moved to the correct forum,
Jim.
Re: How to capture who edited TM1 cube?
Posted: Tue Dec 18, 2018 7:57 pm
by lotsaram
Wim Gielis wrote: ↑Tue Dec 18, 2018 5:10 pm
As to the question, I don't understand what you mean. In the transaction logs, I do see the user name that initiated the change. For manual entry (in yellow the username):
My interpretation of the OP's question is that the end result is a rule derived calculation and they want to know where the "initiator" or the change came from. If that's the case the answer is that the transaction log is for tracing DATA CHANGES. You can trace a calculation a different way (but ultimately any difference in calculation is also going to come down to difference in data.)
Re: How to capture who edited TM1 cube?
Posted: Wed Dec 19, 2018 12:37 am
by tjbalaji85
Hi All,
Thank for everyone time in replying and moving to right sub forum.
Yes I could see that names are captured in Tm1s.log file as shown. Could anyone advise on the options to read tm1s.log file and update the value in cube?
Thank you.
Re: How to capture who edited TM1 cube?
Posted: Wed Dec 19, 2018 12:56 am
by Wim Gielis
- Write a TI process to read out those text files (or process the file using other tools)
- Use the TM1 REST API
Re: How to capture who edited TM1 cube?
Posted: Wed Dec 19, 2018 1:06 am
by tjbalaji85
Thanks for the quick reply Wim, will explore it.
Re: How to capture who edited TM1 cube?
Posted: Wed Dec 19, 2018 1:51 am
by Wim Gielis
What's your level of knowledge of TM1, and programming in general ?
The second option is all but trivial, the first one might be feasible.
Does the model have a high or low volume of data (transactions) logged in the transaction log ?
Is it merely input that is being captured or also copy/load/calculation processes ?