Monday, August 31, 2020

Cleaning up - the aftermath

IBM has been gone for a month or so now. Some of their handiwork has become apparent not just in the reverse KT sessions, but in what was NOT transferred.
In our "successful" transition to SAP, someone from Deloitte dropped several balls and missed doing 2 important reports. One being more critical than the other. They managed to slap something together in eHana which really didn't need to be done. To complicate things, this became a 2 part process where I loaded data and they reported it on a schedule that assumed it was there.(and sometimes it wasn't)

THEN, to make matters worse, they depend on SAP tables that they shouldn't depend on which restrict data and no one knows who maintains those tables. Then, Deloitte's contracts ends and they "hand" it off to the Business Intelligence group which has no clue what this does or how it works.

On the other report, IBM had (without talking to me) created an SSIS package and SSRS reports and scheduled them. They did a little KT at the end, but what was done was mostly useless as they used horrible naming schemes, left things in staging tables but used them as production, and scheduled reports to run under their own userid which expired right after they left. What a mess!

No comments:

Post a Comment