Trace history of a single cell

Suggest and discuss enhancements for TM1
Post Reply
User avatar
Martin Ryan
Site Admin
Posts: 1988
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Trace history of a single cell

Post by Martin Ryan »

I'm using v8 and I have a vague inkling this might have been done in v9?? Either that or it's been mentioned before, perhaps in the Christmas wishlist.

Often when I'm doing reconciliations there is a rogue number and I'd like to see who put it there. At the moment the only option I have is to go through the transaction log to find out who did it when. I'd like to be able to right click on it and select "view cell history", which would tell me the changes that this cell has had in the last week/month/quarter. This would serve the same function as the transaction log, but only give me the current cell and do it in about five seconds and two clicks instead of three minutes and 40 clicks.

Is this already in version 9? If not, do other people see this as being a useful function?

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
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: Trace history of a single cell

Post by Alan Kirk »

Martin Ryan wrote:I'm using v8 and I have a vague inkling this might have been done in v9?? Either that or it's been mentioned before, perhaps in the Christmas wishlist.

Often when I'm doing reconciliations there is a rogue number and I'd like to see who put it there. At the moment the only option I have is to go through the transaction log to find out who did it when. I'd like to be able to right click on it and select "view cell history", which would tell me the changes that this cell has had in the last week/month/quarter. This would serve the same function as the transaction log, but only give me the current cell and do it in about five seconds and two clicks instead of three minutes and 40 clicks.

Is this already in version 9? If not, do other people see this as being a useful function?
Martin
No, it's not even in 9.4... but to be honest I'm not sure whether this could (practically) be implemented in the way you describe.

Short of storing the changes relating to a cell as in-memory metadata (which would blow out memory usage quite sizeably, I would think, especially during budget times when you can have people updating the same number multiple times a day as they try to tweak their bottom lines), the only way of getting this information is via the log files. Regardless of whether you go through the existing dialog, or go through a view cell history shortcut, that's going to take roughly the same amount of time. It's also going to be dependent on people continuing to store the uncompressed log files in the relevant folder.

I don't think that it's a bad idea, but I think it's more likely to be one that will be viable when we're all on 64 bit and have a truckload of gigs to hand so that the in-memory method is an option.

(Though having a shortcut to the logfiles would indeed cut down on the number of clicks needed to perform the query, and would be useful in that respect.)
"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.
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Trace history of a single cell

Post by jim wood »

If you bolt Cognos BI on top TM1 it is found within that. I know, they showed it to me in glorious technicolour yesterday. :o
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: Trace history of a single cell

Post by Steve Vincent »

we should be getting a demo of 9.4 in a few weeks, not sure if they'll do a Cognos BI demo with it but would be interesting to see what that front end is like.

I know where you are coming from Martin, its just the idea of being able to click a cell and automatically populate the transaction log selections, rather than having a view open then manually picking what you need. Problem is, what happens when you have consolidations? The logs only show what level 0 elements have been changed, so it'd need some funky coding to be able to select from a consolidation but actually search all of its level 0 kiddies...
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Trace history of a single cell

Post by Steve Rowe »

When I worked for Infocat we had a piece of code that actually did this, was an extra add in called auditor.xls or something. Not sure what happened to it or where it came from....
Technical Director
www.infocat.co.uk
User avatar
stephen waters
MVP
Posts: 324
Joined: Mon Jun 30, 2008 12:59 pm
OLAP Product: TM1
Version: 10_2_2
Excel Version: Excel 2010

Re: Trace history of a single cell

Post by stephen waters »

Steve Rowe wrote:When I worked for Infocat we had a piece of code that actually did this, was an extra add in called auditor.xls or something. Not sure what happened to it or where it came from....

Steve, it was a special requirement for a workshop you and I ran back in Jan\Feb 2006. Applix were pally and helpful at the time and got it to us from product managemtn guys in US. We were told it was beta code and would be incororated in next release or 2 ( I forget what that would have been). However, since then appears to have vanished. May be worth chasing with themm, perhaps a question to Dave Corbet on 14 Oct?
User avatar
garry cook
Community Contributor
Posts: 209
Joined: Thu May 22, 2008 7:45 am
OLAP Product: TM1
Version: Various
Excel Version: Various

Re: Trace history of a single cell

Post by garry cook »

Well, that'd be useful if there was an available tool, even if beta as I'm currently working through a method for doing this exact task at the second for one of our major project deliverables next year.

Currently working on an .xla addin attached to a right click menu in Excel calling perl script to query log files which would only work on lvl 0 elements - thought about ELCOMPN'ing it and passing multiple variables to the query but that way leads to both coding hell and "ooooh, I'll ask for any changes to Net Cash Balance for the whole company for the whole year" kind of queries from the user base.

Perl script stops the server freeze but I've still to really have a good think about how we're going to go about doing it. It's coming out as a pretty key requirement in the project so I'm loathe to just say no until I've investigated if we really can do it/realistic speed/etc. If there's a beta version kicking about of something that does this already, I'd be very interested in seeing how it functions.
Post Reply