Hi there
From what I can see, only users in one of the 3 admin roles can view the transaction log and roll back if required.
Is this correct? Is there any way around this?
Regards
Chris
Transaction Logs - Access Rights Required
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Transaction Logs - Access Rights Required
Only admins, anyway. I'm not sure if it's all three types because I regard the two newer groups as being a waste of space which were the result of regulatory demands to be Seen! To! Be! Doing! Something! after Enron hit the wall. I never use them.
Yes, because as a general principle turning end users loose to be able to back out anything their little hearts desire would be a rather bad thing. That said, there are Undo options in both Perspectives/Client and Web if a user has simply screwed up and realised it straight away.
I can think of a few ways that such a thing could be implemented using TI, but I would hope that the need to do so (aside from the need which is already covered by Undo) would be rare enough to make it an unproductive use of time.
To be honest if I find that a user has made a massive mistake (like using data spreading clear), I don't use the transaction log GUI anyway; I do a data save and run the relevant part of the transaction log in backwards through a TI. The transaction log GUI seems to grab only 100 lines at a time which makes backing out thousands of entries through that a really, really tedious process.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Re: Transaction Logs - Access Rights Required
Hi Alan
Thanks very much for your feedback.
Your approach with TIs sounds interesting. Do you not have challenges with this approach, when for example, you want to back out all transactions for a specific date ranges, user, element etc. I guess one would need a TI that read through all log files that are date stamped between a specific range.
The rest could be parameterised.
If you already have a TI that does this, would greatly appreciate a copy.
Regards
Chris
Thanks very much for your feedback.
Your approach with TIs sounds interesting. Do you not have challenges with this approach, when for example, you want to back out all transactions for a specific date ranges, user, element etc. I guess one would need a TI that read through all log files that are date stamped between a specific range.
The rest could be parameterised.
If you already have a TI that does this, would greatly appreciate a copy.
Regards
Chris
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Transaction Logs - Access Rights Required
Weeelll... I do have a confession to make there. TI of course can only read a file from front to back. I therefore don't have TI read the log files directly, but pre-process the file elsewhere. More specifically I load the last n months of transaction logs into SQL Server because it's way easier to answer the question of "Who entered the values for Profit Centres x, Y and Z last Tuesday" that way. Multiple queries are a nightmare in the GUI.chewza wrote: ↑Mon Apr 16, 2018 6:47 am Your approach with TIs sounds interesting. Do you not have challenges with this approach, when for example, you want to back out all transactions for a specific date ranges, user, element etc. I guess one would need a TI that read through all log files that are date stamped between a specific range.
The rest could be parameterised.
If you already have a TI that does this, would greatly appreciate a copy.
It's therefore really easy to extract anything I need and have it ORDER(ed) BY whatever way suits, though on occasions in the past for a quick ad hoc fix I've just used Excel if the logs hadn't been loaded to MSSS at the time. Then with the file in reverse time order I just feed it up to some standard TIs that exist for most of the major cubes.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Re: Transaction Logs - Access Rights Required
ok thanks.
I'm thinking of designing an approach where a TI loops through all log files that are date stamped between required range, and writes values to a cube.
This could then be used as the query source.
Will need to see if there is a loop through log files, and dynamically change the test file source. Not sure if this can be done in Tm1, or if I would need something like a VB script to accumulate multiple log files into a single text file that can be accessed.
Many thanks!
Chris
I'm thinking of designing an approach where a TI loops through all log files that are date stamped between required range, and writes values to a cube.
This could then be used as the query source.
Will need to see if there is a loop through log files, and dynamically change the test file source. Not sure if this can be done in Tm1, or if I would need something like a VB script to accumulate multiple log files into a single text file that can be accessed.
Many thanks!
Chris
-
- Site Admin
- Posts: 1454
- Joined: Wed May 28, 2008 9:09 am
Re: Transaction Logs - Access Rights Required
TM1PY could be useful for this eg:
https://github.com/cubewise-code/TM1py- ... equests.py
https://github.com/cubewise-code/TM1py- ... equests.py
-
- MVP
- Posts: 3117
- 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: Transaction Logs - Access Rights Required
Why not ? Use Wildcardfilesearch and DataSourceNameForServer.
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