The data ware­house fol­lows a clas­sic, two-layer core-mart archi­tec­ture. The sys­tem col­lects the rel­ev­ant inform­a­tion from the vari­ous source sys­tems, cleans it accord­ing to defined rules, pre­pares it in terms of data tech­no­logy and stores it in a cent­ral data pool. The core ware­house is oper­ated with DB2 z/OS on a main­frame envir­on­ment and is updated daily using batch jobs from the source sys­tems. The mart layer, which uses DB2 LUW under Unix, is man­aged with Sagent Data Flow. Vari­ous con­trol tables, which are main­tained by the cus­tomer using Apparo Fast Edit, can be used to influ­ence the pro­cessing logic of the mart sup­ply. For example, sales can be dynam­ic­ally assigned to a series of key fig­ures based on selec­ted char­ac­ter­ist­ics (con­tra account, pur­pose, etc.). The vari­ous com­pon­ents and jobs in the backend are sched­uled using Automic. The fron­tend essen­tially con­sists of the Cognos com­pon­ents Fram­work Man­ager, Con­nec­tion and Report Stu­dio. The rela­tional reports are based on the pack­age also used for ad hoc ana­lyses. An innov­a­tion for both the cus­tomer and Atruvia is the first-time use of Cognos ActiveReports.

The BI solu­tion developed provides the fol­low­ing benefits:

• Ful­fill­ment of legal requirements
• Stand­ard­ized, user-friendly and highly flex­ible front end through the use of IBM Cognos Busi­ness Intelligence
• Thanks to para­met­er­ized ETL routes and Apparo Fast Edit, tech­nical changes can be impor­ted autonom­ously by the customer
• The Act­ive Reports enable the bank’s cus­tom­ers to ana­lyze their loan port­fo­lio inter­act­ively and nav­ig­ate flex­ibly through their data.