Yes we considered building something, but for now I think we will use PAW GIU and just do smaller batches, the development work is not worth it given how rarely this happens.
Original Message:
Sent: Tue September 17, 2024 05:01 AM
From: Declan Rodger
Subject: PAW Rollback transaction log - more than 1500 rows
If its a regular task you are having to perform you can achieve better rollback functionality yourself with a little development effort; it then becomes a case of weighing up the effort to develop vs the effort spent doing the rollbacks in batches etc.
We have a customer where admin access in Production is restricted so we couldn't do rollbacks at all without putting a request in which obviously ended up being too slow to action. So we set up 2 TI processes; the master process is just a wrapper that would take parameters relating to the time range and objects you want to clear (e.g. Cube Name, Dim 1 element, Dim 2 element etc.) that process would then action a loop to call a sub process against the transaction logs looping back (with wildcardfilesearch) until one of the sub processes finds a record earlier than the "start time".
In the subprocess it did a couple of basic checks to see if the row of data "matched" with what you wanted to reverse and if so would do the CellPutN/S.
I don't have access to those TIs at the moment but from memory they were fairly straightforward to set up after spending a little time reviewing the log formats. As with anything involving loops you need to be careful to make sure they are tested properly and can't run "forever".
Or in your specific case, depending how the users are "uploading files".... if they are doing it via a TI to upload a CSV... you could add extra steps into that TI process that outputs a new (timestamped / user named) file with the cell destination (cube and element references) in addition to the new and old values. Then a second basic TI to reverse whatever is any of those output files.
------------------------------
Declan Rodger
Technical Director
Spitfire Analytics
Original Message:
Sent: Thu September 12, 2024 05:40 AM
From: Magnus Eckerbom
Subject: PAW Rollback transaction log - more than 1500 rows
We have user uploading files to Planning Analytics. Sadly this is a must have business requirement.
Of course this will occasionally lead to someone uploading a file overwriting someone else numbers. By rolling back all transaction from the import in Architect, we have manged to save our users a great deal of frustration and double work.
When trying to do this in PAW it seems like the rollback is only possible to do on max 1500 rows, and the files are almost always larger than that.
Are we missing something obvious in PAW that makes it possible to rollback ALL transactions matching the search criteria?
Of course you could slice the selection into smaller slice, say rollback month by month, but this is time consuming and a worse experience than in Architect.
------------------------------
Magnus Eckerbom
------------------------------