Page 1 of 1

Transaction Logs - Access Rights Required

Posted: Sun Apr 15, 2018 4:22 pm
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

Re: Transaction Logs - Access Rights Required

Posted: Mon Apr 16, 2018 1:02 am
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.

Re: Transaction Logs - Access Rights Required

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

Re: Transaction Logs - Access Rights Required

Posted: Mon Apr 16, 2018 6:58 am
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.

Re: Transaction Logs - Access Rights Required

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

Re: Transaction Logs - Access Rights Required

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

Re: Transaction Logs - Access Rights Required

Posted: Mon Apr 16, 2018 5:36 pm
by Wim Gielis
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.