One-Pot Synthesis of Requirements Elicitation for Operational BI (OBI) System: in the Context of the Modern Business Environment

A.D.N. Sarma

Abstract views = 488 times | downloads = 372 times


Background: Requirement elicitation is the first step for any project. The available BI requirement elicitation approaches are focused more towards: the top pyramid of the management, less focus on the business aspect of an organization, historical in nature, emphasis on data mining and data warehousing aspects, no clear separation between requirements, and lack of proper linkage between the requirements.  The demand of BI shifts towards the operational front for last couple of years. The use of Operational BI is gaining more popularity among industry and business communities because of increased demand of real time BI.  It provides a powerful analysis of both operational and business information in current time for all levels of the users in the organization.

Objective: In the modern business environment, the business operates on networks that demands multi-level decision-making capabilities as compared to the traditional business approaches. Operational BI is one of the business information systems that support the modern business environment and provides timely decision-making information to all the users in the organization. The requirement elicitation methodology for Operational BI system is found open for research. A new approach for requirement elicitation for an Operational BI system is presented in this paper, which highly suits to the organizations in the modern business environment.

Methods: A top down technique is employed in the proposed requirements methodology that focuses on the business context of an organization. The proposed requirement elicitation approach is highly suited for the organizations that operate in the modern business environment. This approach overcomes several limitations in the existing BI requirement approaches. A case study is presented to support the proposed requirement elicitation approach for OBI system.

Conclusion: This approach has several advantages like fast development, clear definition, classification of various types of requirements and proper linkage between the requirements without any loss or missing of gathering requirements. Finally, it is to conclude that the proposed approach acts as a one-pot synthesis of requirements elicitation for Operational BI system.


Business Context, Business, Intelligence, Business Networks, Protocols, Modern Business, Environment, Operational Business, Intelligence    Requirement,  Elicitation, Requirement, Methodology


Business Context Business Intelligence Business Networks; Protocols Modern Business Environment Operational Business Intelligence Requirement elicitation Requirement methodology

Full Text:



Paola Britos, Oscar Dieste and Ramón García-Martínez, “Requirements Elicitation in Data Mining for Business Intelligence Projects,” International Federation for Information Processing (IFIP), Advances in Information Systems Research, Education and Practice; Springer, Boston, MA, 2008, Vol.274, pp.139-150.

John Boyer, Bill Frank, Brian Green, Tracy Harris, Van De Vanter, “Business Intelligence Strategy A Practical Guide for Achieving BI Excellence,” MC Press Online, LLC, Ketchum, ID 83340, 1st Edition, 2010, pp. 21.

Robert M.Bruckner, Beate List, and Josef Schiefer, “Developing requirements for data warehouse systems with use cases,” 7th American Conference on Information Systems, 2001, pp.329-335.

Josef Schiefer, Beate List, and Robert M.Bruckner, “A holistic approach for managing requirements of data warehouse systems,” 7th American Conference on Information Systems, 2002, pp.77-87.

Robert Winter, and Bernhard Strauch, “A Method for Demand-driven Information Requirements Analysis in Data Warehousing Projects, ” Proceedings of the 36th Hawaii International Conference on System Sciences (HICSS'03), Track 8, Vol. 8, IEEE 2003.

Ulrich Christ, “An Architecture for Integrated Operational Business Intelligence,” 2009, pp. 460-468. [Accessed 20 November 2018].

Daniela Ioana Sandu, “Operational and real-time Business Intelligence,” Revista Informatica Economica nr.3(47), 2008.

Geoffrey G. Parker, Van Alstyne, Marshall W., and Sangeet Paul Choudary, Platform Revolution: How Networked Markets Are Transforming the Economy and how to make them work for you, New York : W.W. Norton & Co., 2016, First Edition.

Nenad Jukic and John Nicholas, “A Framework for Collecting and Defining Requirements for Data Warehousing Projects,” Journal of Computing and Information Technology - CIT 18, 2010, 4, pp.377–384.

Steve Willams, “Business requirements for BI and the BI portfolio: How to get it right,” Featured in DM Review, July 2008, pp.2-4.

Golfarelli, Matteo, “From User Requirements to Conceptual Design in Data Warehouse Design–a Survey,” Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction, 2009.

Paolo Giorgini, Stefano Rizzi, and Maddalena Garzetti GRAnD: A goal-oriented approach to requirement analysis in data warehouses , Vol.45, Issue 1, April 2008, Pp. 4-21.

Danielle A. Menéndez and Paulo Caetano da Silva, “A Requirement Elicitation Process for BI Projects,” Lecture Notes on Software Engineering, Vol. 4, No. 1, February 2016, pp-20-26.

Hanu Bhardwaj and Naveen Prakash, “Eliciting and structuring business indicators in data warehouse requirements engineering,” Vol.33, Issue 4, Special Issue: Big Data trends: Modeling, Management and Visualization, John Wiley & Sons Ltd, August 2016, pp.405-413.

Inmon W.H., Building the Data Warehouse, 4 Ed, John Wiley, New York.

E. Soler, V. Stefanov, J. Mazon, J. Trujillo, E. Fernandez-Madina and M. Piattini, “Towards Comprehensive Requirement Analysis for Data Warehouses: Considering Security Requirements,” 2008 Third International Conference on Availability, Reliability and Security, Barcelona, 2008, pp. 104-111.

Umeshwar Dayal, Kevin Wilkinson, Alkis Simitsis, and Malu Castellanos, “Business process meet operational business intelligence,” Bulletin of the Winter Computer Society Technology Committee on Data Engineering, September 2009, Vol. 32, No. 3, pp.35-41.

Naveen Prakash, and Anjana Gosain, “Requirements Driven Data Warehouse Development,” The 15th Conf. on Advanced Information Systems Engineering, Klagenfurt/Velden, Austria, 16-20 June, 2003.

Matteo Golfarelli, “Data warehouse life-cycle and design,” [Accessed 8 August 2019].

SAS Rapid Warehousing Methodology, SAS, A whitepaper, 2000.

Chapman P, Clinton J, Keber R, Khabaza T, Reinartz T, Shearer C, Wirth R, CRISP – DM 1.0 Step BI guide, Edited by SPSS, 2000, [Accessed December 2018].

Pyle D, Business Modeling and Business intelligence, Morgan Kaufmann, 2003.

Soroosh Nalchigar, and Eric Yu, “Business-driven data analytics: A conceptual modeling framework,” Data & Knowledge Engineering 117 April 2018, pp.359–372.

Ramesh Sharda, Dursun Delen, Efraim Turban, J.E.Aronson, Ting-Peng Liang, and David King, Business Intelligence and Analytics: Systems for Decision Support, 10th Edition, Pearson Education Inc., New Jersey, 2015.

Hill, G., “A Guide to Enterprise Reporting,” 2008, [Accessed July 2019].

Natalija Kozmina, Laila Niedrite and Janis Zemnickis, “Gathering Formalized Information Requirements of a Data Warehouse,” In Proceedings of the 19th International Conference on Enterprise Information Systems (ICEIS 2017), 2017, Vol.1, pp. 217-224.

Pierre Bourque and Richard E Fairely “Guide to the software engineering body of knowledge Version3.0,” IEEE Comp. Society Press.

Stephen Opoku-Anokye and Yinshan Tand, “Towards the Design of a Unified Recording and Querying Model for OLTP and OLAP Systems,” Proceeding of 3rd International Conference on Logistics, Informatics and Service Science, Springer-Verlag Berlin Heidelber, 2013, pp-1105-1110.

Dale Rutz, Tara Nelakanti and Nayem Rahman, “Practical Implications of Real Time Business Intelligence,” Journal of Computing and Information Technology, 2012, Vol. 20, No. 4, pp.257–264.

Fabio Rilston S. Paim and Jaelson F. B. Castro, “DWARF: An Approach for Requirements Definition and Management of Data Warehouse Systems,” In the proceedings of the 11th IEEE International Conference on Requirements Engineering, Sept. 2003, pp.75-86.

B. Dano, H. Briand, F. Barbier, “A use case driven requirements engineering process,” Third IEEE Int. Symposium On Requirements Engineering, Antapolis, Maryland, IEEE Computer Society press, 1977.

Chowdhary et al., “Model Driven Development for Business Performance Management,” IBM Systems Journal, Vol. 45 (3), pp. 587-605, 2006.

Paolo Giorgini, and Stefano Rizzi, “Goal-Oriented Requirement Analysis for Data Warehouse Design,” Proceedings 8th Int. Workshop on DW and OLAP (DOLAP 2005), Bremen, Germany, 2005, pp. 47-56.

Horkoff, J., Aydemir, F.B., Cardoso, E. et al., Goal-oriented requirements engineering: an extended systematic mapping study, Requirements Engineering, 2019, Vol.24, Issue 2, pp 133–160.

Khurram Shahzad, and Paul Johannesson , “An Evaluation of Process Warehousing Approaches for Business Process Analysis,” In Proceedings of the International Workshop on Enterprises and Organizational Modeling and Simulation, (EOMAS 2009), Vol. 458.

Svetlana Mansmann, Thomas Neumuth, and Marc H. Scholl , “Multidimensional Data Modeling for Business Process Analysis,” ER 2007, LNCS 4801, pp. 23–38, 2007.

Michael Böhnlein, Achim Ulbrich-vom Ende, “Business Process Oriented Development of Data Warehouse Structures,” Data Warehousing 2000, pp.3-21.

R.Krawatzeck, B.Dinter and D.A.P.Thi, “How to Make Business Intelligence Agile: The Agile BI Actions Catalog,” 48th Hawaii International Conference on System Sciences, Kauai, HI, 2015, pp.4762-4771.

Lewis Lundy, Managing Business and Service Networks, Academic Publishers, 2001.

Nur Hani Zulkifli Abai, Jamaiah H. Yahaya, and Aziz Deraman, “User Requirement Analysis in Data Warehouse Design: A Review”, The 4th Int. Conference on Electrical Engineering and Informatics ICEEI 2013), ScienceDirect,Procedia Technology, 2013, pp.801-806.

N. Jukic and J. Nicholas, “A Framework for Requirement Collection and Definition Process for Data Warehousing Projects,” Proceeding of the International Conference on Information Technology Interface; 2010. pp.187–192.

Robert Winter, and Bernhard Strauch, “Information Requirements Engineering for Data Warehouse Systems,” SAC’04, March 2004

Y. Guo, Sh. Tang, Y. Tong, and D. Yang, “Triple-Driven Data Modeling Methodology in in Data Warehousing: A Case Study,” DOLAP, 2006, Proceedings of the 9th ACM international workshop on Data warehousing and OLAP, 2006, pp. 59–66.


  • There are currently no refbacks.

Copyright (c) 2019 The Authors. Published by Universitas Airlangga.

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.

ISSN 2443-2555 (online) 2598-6333 (print). Published by Universitas Airlangga.
 All article published in JISEBI are open access and under the CC BY license (