Data Warehousing within Intranet: Prototype of a Web-based Executive Information System

A Data Warehouse (DWH) contains a large amount of aggregated data, collected from the various operational, enterprise-wide data sources. The DWH will be locigal modeled as a virtual n-dimensional data-cube. Analyses against this n-dim data-cube allow the decision makers (e.g. executives, middle management, controllers, etc.) to view their enterprise in various different ways. This paper describes our ongoing 'WWW-EIS-DWH' research project of the development of a simple to use Executive Information System (EIS), which is complete embedded in the Web , res. an enterprise-wide network (Intranet), and based on a multidimensional medeled Data Warehouse. To accomplish our goals we implemented a generic R-OLAP (relational Online Analytical Processing) engine to extract the raw data from the given multidimensional OLAP data cubes. The 'Information Server' (IS) is responsible for the vizualisation of the retrieved OLAP data cubes in an easy understandable manner. Our user interface uses commonly used Web technology like Java, JavaScript, HTML 3.2.