Oscar Mangisengi, Ngoc Thanh Huynh



An existing challenge is that organizations need to make business processes as the centrepiece of their strategy to enable the processes performing at higher level and to efficiently improve these processes in the global competition. Traditional Data Warehouse and OLAP tools, which have been used for data analysis in the Business Intelligence (BI) systems, are inadequate for delivering information faster to make decisions and to earlier identify failures of a business process. In this paper we propose a closed-loop BI framework that can be used for monitoring and analyzing a business process of an organization, optimizing the business process, and reporting cost based on activities. Business Activity Monitoring (BAM) as data resource of a control system is as the heart of this framework. Furthermore, to support such a BI system, we integrate an extracting, transforming, and loading tool that works based on rules and state of business process activities. We show that some functionalities of our prototype are working well. The tool can automatically transfer data into a data warehouse when conditions of rule and state have been satisfied.


  1. Bulos, D., 1996. A New Dimension, in Database Programming & Design, 1996.
  2. Codd, E.F., Codd, S.B., & Salley, C.T., 1993. Providing OLAP (On-Line Analytical Processing) To UserAnalysts: An IT Mandate, E.F. Codd & Associates, White Paper.
  3. Creese, G., 2005. Volume Analytics: Get Ready for the Process Warehouse. DMReview, April 15, 2005.
  4. Dresner, H., 2002. Business Activity Monitoring: New Age BI?, Gartner Research LE-15-8377, April.
  5. Hellinger, M, & Fingerhut, S., 2002. Business Activitity Monitoring: EAI Meets Data Warehousing. EAI Journal.
  6. Inmon, W., 2002. Building the Data Warehouse, John Wiley & Sons.
  7. Kimball, R., Ross, M., & Merz. R., 2002. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, John Wiley & Sons.
  8. Lopez-Claros, A., 2006. The Global Competitiveness Report 2006-2007, The Global Competitiveness Index: Identifying Key Elements of Sustainable Growth, 2006.
  9. Mangisengi, O., Pichler, M., Auer, D., Draheim, D., & Rumetshofer, H., 2007. Activity Warehouse: Data Management for Business Activity Monitoring. Proceedings of the 9th. International Conference on Enterprise Information Systems, Funchal-Madeira, Portugal.
  10. McCoy, D., 2001. Business Activity Monitoring: The Promise and the Reality, Gartner Group, July.
  11. Morris, Vassett & Fleming, 2007. Improving Business Performance through Process Visibility. IDC Analyze the Future, May 2007.
  12. Nesamoney, D., 2004. BAM: Event-Driven Business Intelligence for the Real-Time Enterprise. DM Review, Vol. 14, Number 3.
  13. Nishiyama, T., 1999. Using a Process Warehouse Concept A Practical Method for Successful Technology Transfer. In Proc. 2nd. International Symposium on Object-Oriented Real Time Distributed Computing, IEEE Computer Society, Saint Malo, France.
  14. Pankratius, V., & Stucky, W., 2005. A Formal Foundation for Workflow Composition, Workflow View Definition, and Workflow Normalization based on Petri Nets. The 2nd. Asia-Pacific Conference on Conceptual Modeling (APCCM 2005).
  15. Schiefer, J., List, B., & Bruckner, R.M., 2003. Process Data Store: A Real-Time Data Store for Monitoring Business Processes, Lecture Notes in Computer Science, Database and Expert Systems Applications (DEXA).
  16. Sheth, A.P., van der Aalst, W.M.P., & Arpinar, I.B., 1999. Processes Driving the Networked Economy: Process Portals, Process Vortex, and Dynamically Trading Processes. IEEE Concurrency, 7(3): 18-31.
  17. Tjoa, A.M., List, B., Schiefer, J., & Quirchmayr, G., 2003. The Process Warehouse - A Data Warehouse Approach for Business Process Management. Intelligent Management in the Knowledge Economy, Edward Elgar Publishing, p. 112-126.
  18. Totok, A., & Jaworski, R., 1998. Modelling of Multidimensional Data Structures with ADAPT, Technical Report, Technical University of Braunschweig, ISBN 3-930166-92-5, 1998 (in German).
  19. White, C., 2003. Building the Real-Time Enterprise, TDWI Report Series, A101 communications Publication. The Data Warehousing Institute.

Paper Citation

in Harvard Style

Mangisengi O. and Thanh Huynh N. (2008). TOWARDS A CLOSED-LOOP BUSINESS INTELLIGENCE FRAMEWORK . In Proceedings of the Tenth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8111-36-4, pages 210-217. DOI: 10.5220/0001693602100217

in Bibtex Style

author={Oscar Mangisengi and Ngoc Thanh Huynh},
booktitle={Proceedings of the Tenth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},

in EndNote Style

JO - Proceedings of the Tenth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
SN - 978-989-8111-36-4
AU - Mangisengi O.
AU - Thanh Huynh N.
PY - 2008
SP - 210
EP - 217
DO - 10.5220/0001693602100217