Everyone wants an upgrade, it’s been made manageable and simplified by the 100 Day Upgrade program – so what’s next?
You know what, the one thing that is still answered with “How long is a piece of string” – Frustrating answer… Is the cost of modification retrofit. It’s a difficult question to answer. There are programs out there like “DWS Dimension” – a great product that will give you a really good answer, very accurate. I’m looking for something that perhaps I can do with SQL and jiggery pokey to determine how much is actually modified, how much of those modifications are used and then calculate how much time I think that the retrofit is going to take.
I start by assembling this information:
- modified objects
- custom objects
- Modified objects that have been (this is my “relative modification complexity matrix”)
- Checked in
- Checked out
- Transferred
- Designed
- custom jobs in F986110 & F986114
- Custom programs in the menus
- custom programs in security tables
- When was the last time custom jobs were run
- How many lines of ER code is different between pristine and prod by object!! (Yes I can do this).
The amalgamation of all the information above gives me a pretty good idea of the relative complexity of your site and your modifications. It then takes a couple of spot checks for the more complicated objects to give you a pretty good idea of how long things are going to take to get back into place.
A series of spread sheets and combination of scripts and direct connects to the database assembles the information into a form that is easy to understand and interpret.
Note that the query that brings back the “Relative Modification Complexity Matrix” is EXCELLENT and gives you a very good idea of real modifications in a very short period of time. It also tells you the complexity of the modifications based upon the OMW “action” that they have been part of. Start here is you want to have a crack yourself!
No comments:
Post a Comment