How to capture who edited TM1 cube?

Post Reply
tjbalaji85
Posts: 3
Joined: Tue Oct 23, 2018 2:40 am
OLAP Product: TM1
Version: PAW
Excel Version: 2016

How to capture who edited TM1 cube?

Post 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
Wim Gielis
MVP
Posts: 3103
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?

Post 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
06.png (21.66 KiB) Viewed 3075 times
If it's done via TI:


Wim
Attachments
07.png
07.png (31.82 KiB) Viewed 3075 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
User avatar
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?

Post by jim wood »

Moved to the correct forum,

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
lotsaram
MVP
Posts: 3651
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?

Post 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.)
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
tjbalaji85
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?

Post 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.
Wim Gielis
MVP
Posts: 3103
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?

Post 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
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
tjbalaji85
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?

Post by tjbalaji85 »

Thanks for the quick reply Wim, will explore it.
Wim Gielis
MVP
Posts: 3103
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?

Post 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 ?
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
Post Reply