And I hope it's not me.
The beauty about data warehouses are that they tend to store historical data. Especially when historical data is going to enrich the reporting to provide real value add.
So I designed a fantastic model, with slowly changing dimensions. Designed, implemented, tested in UAT(by me), passed & deployed into production, where the output was signed off(by me again). Part of that was history preservation and one client has paid a lot of money for the data to be recorded for the last 3 months. All signed off and working. The client has been using the standard report offering for the last 3 months. Now they've asked to analyse the historical changes. Excellent.
Well no. Somebody in the ETL/DBA team turned the fooking history off a few days after Go-Live!! What a mystery!!!!!
No historical data! All contractors(DBA, ETL, Report Developers, Support Staff!). Somebodies head is going to roll. It's got my dabs all over it as signing it off and PM, but luckily I don't have access to the ETL tools.
Who should I take into the boardroom?
The beauty about data warehouses are that they tend to store historical data. Especially when historical data is going to enrich the reporting to provide real value add.
So I designed a fantastic model, with slowly changing dimensions. Designed, implemented, tested in UAT(by me), passed & deployed into production, where the output was signed off(by me again). Part of that was history preservation and one client has paid a lot of money for the data to be recorded for the last 3 months. All signed off and working. The client has been using the standard report offering for the last 3 months. Now they've asked to analyse the historical changes. Excellent.
Well no. Somebody in the ETL/DBA team turned the fooking history off a few days after Go-Live!! What a mystery!!!!!
No historical data! All contractors(DBA, ETL, Report Developers, Support Staff!). Somebodies head is going to roll. It's got my dabs all over it as signing it off and PM, but luckily I don't have access to the ETL tools.
Who should I take into the boardroom?
Comment