Transaction Logs - Access Rights Required

Post Reply
chewza
Posts: 146
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Transaction Logs - Access Rights Required

Post by chewza »

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
User avatar
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

Post by Alan Kirk »

chewza wrote: Sun Apr 15, 2018 4:22 pm From what I can see, only users in one of the 3 admin roles can view the transaction log
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.
chewza wrote: Sun Apr 15, 2018 4:22 pm and roll back if required.
Is this correct?
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.
chewza wrote: Sun Apr 15, 2018 4:22 pm Is there any way around this?
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.
chewza
Posts: 146
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Re: Transaction Logs - Access Rights Required

Post by chewza »

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
User avatar
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

Post by Alan Kirk »

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.
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.

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.
chewza
Posts: 146
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Re: Transaction Logs - Access Rights Required

Post by chewza »

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
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: Transaction Logs - Access Rights Required

Post by David Usherwood »

Wim Gielis
MVP
Posts: 3105
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

Post by Wim Gielis »

chewza wrote: Mon Apr 16, 2018 7:09 amWill 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,
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
Post Reply