MAPPING TEMPORAL DATA WAREHOUSE CONCEPTS TO SAP BW COMPONENTS

Ahmed Hezzah, A Min Tjoa

Abstract

SAP Business Information Warehouse (BW) today is a suitable and viable option for enterprise data warehousing and one of the few data warehouse products that offer an integrated user interface for administering and monitoring data. In previous works we introduced design and modeling techniques for representing time and temporal information in enterprise data warehouses and discussed generic problems linked to the design and implementation of the Time dimension, which have to be considered for global business processes, such as handling different time zones and representing holidays and daylight saving time (DST). This paper investigates supporting the global exchange of time-dependent business information by mapping those temporal data warehouse concepts to SAP BW components, such as InfoCubes and master data tables.

References

  1. Egger, N., (2004), SAP BW Professional, SAP Press
  2. Hezzah, A., Tjoa, A. M., (2004a), Design and Representation of the Time Dimension In Enterprise Data Warehouses - A Business Related Practical Approach, In Proc. of ICEIS'04
  3. Hezzah, A., Tjoa, A. M., (2004b), Temporal Multidimensional Modeling with OLAP for Business Applications, In Proc. of BIS'04
  4. Hezzah, A., (2004c), Modeling Temporal Characteristics with SAP Business Information Warehouse as an Enterprise Data Warehouse - A Business Performance Enhancing Practical Approach, Accepted for Publication at CISTM'04
  5. Kimball, R., (1996), The Data Warehouse Toolkit, John Wiley & Sons, Inc.
  6. McDonald, K., Wilmsmeier, A., Dixon, D. C., Inmon, W. H., (2002), Mastering the SAP Business Information Warehouse, John Wiley & Sons
  7. Nguyen, T., Tjoa, A.M., Wagner, R., (2000), An Object Oriented Multidimensional Data Model for OLAP, In Proc. of 1st Int. Conf. on Web-Age Information Management (WAIM 2000)
  8. Prosser, A., Ossimitz, M. L., (2001), Data Warehouse Management Using SAP BW, UTB Stuttgart
  9. Ravat, F., Teste, O., (2000), A Temporal Object-Oriented Data Warehouse Model, DEXA'00
  10. Wijsen, J., Ng, R.T., (1999), Temporal Dependencies Generalized for Spatial and Other Dimensions, Proc. Spatio-Temporal Database Management
  11. Yang, J., Widom, J., (2000), Temporal View SelfMaintenance in a Warehousing Environment, EDBT'00
Download


Paper Citation


in Harvard Style

Hezzah A. and Min Tjoa A. (2005). MAPPING TEMPORAL DATA WAREHOUSE CONCEPTS TO SAP BW COMPONENTS . In Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-19-8, pages 391-397. DOI: 10.5220/0002510903910397


in Bibtex Style

@conference{iceis05,
author={Ahmed Hezzah and A Min Tjoa},
title={MAPPING TEMPORAL DATA WAREHOUSE CONCEPTS TO SAP BW COMPONENTS},
booktitle={Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2005},
pages={391-397},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002510903910397},
isbn={972-8865-19-8},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - MAPPING TEMPORAL DATA WAREHOUSE CONCEPTS TO SAP BW COMPONENTS
SN - 972-8865-19-8
AU - Hezzah A.
AU - Min Tjoa A.
PY - 2005
SP - 391
EP - 397
DO - 10.5220/0002510903910397