Success Story Dillinger

EXTRACTING BUSINESS LOGIC Fortunately for Dillinger, the author of the VB Code implementing the business logic was still working at the organization. Together with the DHW team they analyzed several thousand lines of code and were able to reproduce the numbers in their Business Vault. However, it was not possible to implement an up-to-date definition of the metrics. The knowledge of the business logic and the responsibilities were unfavorably distributed and it was not possible to quickly get an agreed definition together. Nevertheless, the discussion about the definition of key figures has led to the fact that those responsible now meet regularly in a working group and define agreed key figures. DELIVERING KPIS When it comes to displaying KPIs, Dillinger has relied on custom-written Java and VB applications. These offer a high degree of flexibility but require good programming skills. Similar to their sister company SAG, new visualizations are to be realized with a selected dashboard application: the department is to create prototypes and then make them available to interested parties with the help of internal experts for dashboard development. Since their internal customers in both sub-projects had no training in developing dashboards, it was up to the Dillinger DWH team to provide those. To address this, Scalefree provided a specialist who assisted with the implementation. Together, they were able to deliver a presentable result in a very short time. SECOND SUBPROJECT: STEEL MILL - SECONDARY METALLURGY For Dillinger’s second sub-project - key figures for the secondary metallurgy of the steel mill - the conditions were much better from the onset. The entire effort of finding “right” business keys could be saved because of prior knowledge from the first project. Another major advantage was the redesign of the source database in 3NF within the course of another migration project. Thus, the model conversion rules customized in WhereScape worked much smoother given they were initially designed to digest 3NF models and CDC was established as well. In this sub-project, the business logic was provided to the Dillinger DWH team by the business department in a well-structured requirements document, so there was no need to organize working groups or analyze old code to get KPI definitions. Since the to-be-generated reports are for quality assurance purposes, it was extremely important that the data in the warehouse was prepared in a timely manner. Thus, a loading cycle of two hours was considered an acceptable timeframe by the business department. In the meantime, the Dillinger team was able to double their team size which allowed for better knowledge transfer and more active participation in the implementation. The only real challenge was to handle the large amount of measurement data in combination with the dashboard application.

Made of Steel - Data Vault 2.0 at Dillinger | Scalefree International GmbH

9/13

Powered by