Transaction Logs - Access Rights Required

Post Reply
chewza
Posts: 60
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 » Sun Apr 15, 2018 4:22 pm

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: 5839
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: Transaction Logs - Access Rights Required

Post by Alan Kirk » Mon Apr 16, 2018 1:02 am

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: 60
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 » Mon Apr 16, 2018 6:47 am

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: 5839
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: Transaction Logs - Access Rights Required

Post by Alan Kirk » Mon Apr 16, 2018 6:58 am

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: 60
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 » Mon Apr 16, 2018 7:09 am

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: 1337
Joined: Wed May 28, 2008 9:09 am

Re: Transaction Logs - Access Rights Required

Post by David Usherwood » Mon Apr 16, 2018 8:20 am


Wim Gielis
MVP
Posts: 1849
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Transaction Logs - Access Rights Required

Post by Wim Gielis » Mon Apr 16, 2018 5:36 pm

chewza wrote:
Mon Apr 16, 2018 7:09 am
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,
Why not ? Use Wildcardfilesearch and DataSourceNameForServer.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

Post Reply