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
Trace history of a single cell
- 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
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
Jodi Ryan Family Lawyer
- 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
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.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
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- 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
If you bolt Cognos BI on top TM1 it is found within that. I know, they showed it to me in glorious technicolour yesterday.
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
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- 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
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...
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
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
- Steve Rowe
- Site Admin
- Posts: 2415
- 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
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
www.infocat.co.uk
- 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
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?
- 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
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.
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.