Rapid Management Cockpit

Integrate Dashboards with Enterprise Data

  • by Andrew Joo, EPM Leader for North America, SAP Business Analytics Center of Excellence, IBM Global Business Services
  • December 22, 2011

Find out how a global energy company — after developing Xcelsius dashboards (now known as BusinessObjects Dashboards) using a Rapid Management Cockpit methodology — followed up on the effort by designing future architecture to integrate dashboards to an enterprise data layer. In doing so, the company fully built out its business intelligence and performance management capabilities without following traditional processes.

BusinessObjects Live Office is a Microsoft Excel-based reporting application used to integrate BusinessObjects components. The software allows you to embed business intelligence information in documents.

In my article, “7 Steps a Global Energy Company Took to Bring BI Potential to Life,” I introduced Rapid Management Cockpit processes and how they relate to the planning, designing, developing, and deploying of Xcelsius (now known as SAP BusinessObjects Dashboards). A global energy company used these initial processes to define and present key business information via Xcelsius dashboards, encompassing cross-functional business processes, functions, and applications. 

The following key processes build upon the energy company’s initial foundation to integrate Xcelsius dashboards to enterprise data architecture and fully build out end-to-end business intelligence (BI) and performance management capabilities.


Integrate to Enterprise Data and Semantic Layers

The energy company had successfully delivered a host of strategic, executive, management, and operational Xcelsius dashboards to the business. The dashboards were used throughout the company to gain visibility into performance and trigger corrective action.

However, unknown to the business, the initial data sourcing process was designed to provide rapid deployment at the expense of scalable, repeatable, and automated data integration processes. Therefore, a key impetus for the subsequent phase was to automate the data sourcing of dashboards with end-to-end information management processes.


The initial architecture focused on leveraging existing data sources (e.g., Excel files, Access databases, SQL-compliant databases). 

Andrew Joo

Andrew Joo is the Enterprise Performance Management (EPM) leader for North America within the SAP Business Analytics Center of Excellence at IBM Global Business Services. He has more than 16 years of deep strategy, financial, cost, management, and technology consulting experience, encompassing leading industry firms (Big 4, system integrators) and a multitude of technologies (SAP, Microsoft, Oracle), industries (private and public sector), processes and methodologies (PMI, Agile, SDLC), and roles (functional and technical). In addition to serving as a thought leader and subject matter expert in the field of financial advisory, EPM, BI, and Information Management disciplines, he has been integral in project delivery, practice development, business development, and industry and community outreach efforts. He has pioneered unique methodologies and go-to-market solutions using an integrated EPM (EPM-BPC) and BI paradigm. The aforementioned have been featured in key industry events and publications, including SAP Sapphire and SAPinsider’s Financials and Reporting & Analytics conferences. He holds an MBA in strategy/marketing from Rice University, an MS in management information systems, and a Bachelor’s in finance. He is the author of 100 Things You Should Know about SAP NetWeaver BW, full of time-saving tips and tricks and step-by-step instruction.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.