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 logical 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 modeled 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 DWH and create the virtual multidimensional OLAP data cubes. The "Information Server" (IS) is responsible for the visualization 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.