CSL Behring GmbH pursues a company-wide SAP® strategy, which also includes the corresponding standard modules for business intelligence (BI). However, these were unable to meet all of the special requirements posed by the pharmaceutical company.
As part of the pilot project with fme, the two companies began by setting up a quality and manufacturing data warehouse in the QA department. This would be used to evaluate the corresponding data and likewise allow future BI requirements in this area to be mapped and defined. Process- and quality-related data were imported into QlikView, where they serve as the basis for analyses that enable KPI reporting throughout all steps in the production process. Evaluations of process-related information in the production department, such as step yields and trend information from in-process controlling, supply up-to-date batch-specific values that are used to optimize individual production parameters.
"Companies operating in the field are required to maintain end-to-end documentation of step yields for use in the accompanying batch tracking due to the strict regulatory framework governing the pharmaceutical industry," explains Dennis Finger, project manager at CSL Behring. "QlikView delivers batch-specific values in accordance with our specifications that we in turn use to optimize various parameters within the process chain. This enables us to maintain the quality of our products, as it allows us to reliably calculate the step yields, analyze potential sources of loss, and take immediate steps in response as necessary," continues Finger.
"QlikView is the perfect solution for the process industry in the pharmaceutical industry," explains Andreas Buchholz, who heads the Business Intelligence department at fme AG. "Once the necessary conditions are in place, the program can be seamlessly integrated into the system landscape. QlikView also allows for flexible solutions that meet the requirements of the various departments at the pharmaceutical company to a tee."