Lesen Sie hier die komplette Erfolgsgeschichte, oder laden Sie die Succes Story als pdf-Datei herunter.

World's leading Eye Care Company
establishes KPI System for Global Supply Chain. 

• Include sales, purchasing, inventory and forecasting source data in the data warehouse
• Correct bugs, migrate and enhance existing reporting possibilities
• Integrate new KPIs to support new or changed processes
• Utilize a forward looking approach (KPIs based on forecast or projected sales)
• Allow multidimensional, hierarchical and historical analyses (multiple views from the top to the lowest detail level and across dimensions)
• Provide a common access point for KPI analysis over the intranet.

Architecture
The opportunity was taken to create a dedicated data warehouse in an MS SQL Server 2000 environment, keeping all relevant data in a central location.

State of the art reporting data models were created, to provide users with a relational database that is designed for query and analysis rather than for the transactional processing environment of the operational JD Edwards ERP system.

And in addition to highly automated processes, this solution provides the advantages of ad-hoc reporting and historical analyses.

Demanding a standardized reporting environment, project requirements could be fulfilled by the use of the existing reporting software - IBM Cognos 8 Business Intelligence - with users accessing the reporting environment via the local intranet (Cognos Connection Portal).



Generated Benefits
Meeting the challenge by implementing the KPI project in five phases step by step, Alcon benefits from these achievements:

• KPI production and analysis processes were optimized from highly manual to highly automated and are provided in a reliable, timely manner
• The risk of data integrity issues was reduced by utilizing host system, automated ETL and standardized reporting applications
• Special consideration was given to the accurate comprehension of user requirements. Business requirements were defined by very experienced Alcon professionals, which ensures efficiency and improves acceptance
• The elaborately designed reports allow more dynamic and in-depth analyses for various managerial levels
• Reports enable users to examine global data by drilling down through multiple hierarchies to the detail of 130.000 individual products, more than 60 countries and some 90 manufacturing origins. Analysis allows the use of multiple additional filters and KPI specific categorizations, forecast fence periods, target values, historical timelines as well as a drill through navigation between reports
• This project provides additional benefit for the company through the creation of a second center of expertise in KPI/BI/Cognos development at the European Data Center.

Services Accomplished by saracus
Meeting saracus aspires to realize the most beneficial technical implementation by incorparating business needs. The folllowing services were performed at Alcon: 

• Development of the Conceptual Design in close collaboration with the internal IT team
• Support Alcon with IT project planning expertise related to Data Mart and Front End development
• Performance review of the system landscape
• Assistance in the development of complex data mart ETL processes
• Proficient examination of user requirements as a base for the technical implementation
• Design and realization of a specialized data mart model with a business model in Cognos Framework Manager and advanced reports in Cognos Report Studio
   

Statement The world wide roll-out of Alcon's KPI and global inventory visibility is still going on. "We never had such a useful system delivered by IT" was one of the feedback from one of the users. One of the roll-out strategy key factor was validating the data trans mitted by all Alcon organizations and get the acceptance of the users. The demand and awareness of getting more KPI is still growing. Further enhancements will be organized with the BI Release concept. One example is getting a global backorder visibility that could have an impact on Alcon's revenue. Jack Jaeger, Director Global IT

Conclusion
The first three realization cycles of the Global Supply Chain KPI System fulfill the requirements. Intercompany Service Level and Cycle Time KPIs, Inventory KPIs and Global Planning Repository KPIs are presented in an automated, standardized and high-quality reporting solution..

saracus - A Competent Partner
In particular our extensive experience in data warehouse architectures, databases and reporting tools have made saracus consulting a valuable partner in the provision of consulting and implementation services to Alcon.