Management Report Engineering — A Swiss Re Business Case
Roland Holten, Alexander Dreiling, Benedikt Schmid · 2002
Defining and structuring management views is a fundamental task of the specification of data marts and reporting systems. Today such systems are based on data warehouses. A data warehouse stores materialized views on business processes to support the management’s information requirements (cf. Inmon 1996; Inmon, Hackathorn 1994; Inmon et al. 1997). It is located on a central layer of an idealized layer oriented architecture connecting online transaction processing (OLTP) systems and components enabling online analytical processing (OLAP) (cf. Becker, Holten 1998; Chaudhuri, Dayal 1997). The latter components are intended to support navigations adequate for management users through so called multi dimensional information spaces. OLTP systems directly support the business processes and are the sources of data used by OLAP systems. Typically, the integration of OLTP systems and the data warehouse is based on tools performing so called extraction, transformation and loading tasks (ETL) (cf. Inmon 1996; Widom 1995)