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
How to capture who edited TM1 cube?
-
- Posts: 3
- Joined: Tue Oct 23, 2018 2:40 am
- OLAP Product: TM1
- Version: PAW
- Excel Version: 2016
-
- MVP
- Posts: 3113
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: How to capture who edited TM1 cube?
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):
If it's done via TI:
Wim
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):
If it's done via TI:
Wim
- Attachments
-
- 07.png (31.82 KiB) Viewed 3102 times
Last edited by Wim Gielis on Tue Dec 18, 2018 6:58 pm, edited 1 time in total.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: How to capture who edited TM1 cube?
Moved to the correct forum,
Jim.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- MVP
- Posts: 3652
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: How to capture who edited TM1 cube?
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.)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):
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 3
- Joined: Tue Oct 23, 2018 2:40 am
- OLAP Product: TM1
- Version: PAW
- Excel Version: 2016
Re: How to capture who edited TM1 cube?
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.
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.
-
- MVP
- Posts: 3113
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: How to capture who edited TM1 cube?
- Write a TI process to read out those text files (or process the file using other tools)
- Use the TM1 REST API
- Use the TM1 REST API
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 3
- Joined: Tue Oct 23, 2018 2:40 am
- OLAP Product: TM1
- Version: PAW
- Excel Version: 2016
Re: How to capture who edited TM1 cube?
Thanks for the quick reply Wim, will explore it.
-
- MVP
- Posts: 3113
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: How to capture who edited TM1 cube?
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 ?
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 ?
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly