Connecting BusinessObjects Dashboards Directly to SAP Tables

  • by Neha Lunkad Lodha, Team Lead, Infosys
  • January 2, 2015
Learn step-by-step instructions for how to use web service connections to connect directly to SAP tables without using a BEx Query connection. Also learn how to use existing dashboard web-service functionality to pull data directly from SAP BW tables, and to read, write, and modify SAP tables via a web service. The benefit of this functionality is that it minimizes the effort, time, and cost required to build SAP BW data flow to acquire the data into dashboards. Using the logic outlined in this article, dashboards can straightforwardly consume data from SAP tables.
Learning Objectives

Reading this article, you will learn how to:

  • Read SAP tables in dashboards directly through web services
  • Read, modify, and update SAP tables directly through web services
Key Concept

SAP BW tables can be connected to SAP BusinessObjects dashboards via web service-based function modules. A customized solution enables a simple function module to perform the logic of reading, writing, and updating the records based on run-time actions carried out in the dashboard. Web service connections can be used to connect SAP BusinessObjects dashboards to SAP BW tables.

My implementation solution enables companies to access data directly from SAP tables in SAP BW. This same web service connection can be used in multiple dashboards, enabling reusability. By using this customized solution, you can make SAP tables a direct part of a dashboard data source, and you can call web service-based function modules to perform different sets of activities (for example, to read, write, and update the data from SAP tables). In addition, the same web service can be used for all the logic used for multiple tables, and multiple dashboards can be connected to multiple tables via a single web service connection.

This step-by-step approach shows how you can connect dashboards directly to SAP BW tables with the following steps:

  1. Create an SAP table in SAP BW
  2. Create the function module
  3. Create the web service
  4. Bind the web service
  5. Create a user interface (UI) dashboard and map the connection
  6. Publish the dashboard

This process is outlined in Figure 1.

Figure 1
Overview of the process for connecting SAP tables to BusinessObjects dashboards

Neha Lunkad Lodha

Neha Lunkad Lodha is the Team Lead for SAP BusinessObjects and SAP NetWeaver BW at Infosys, in New Jersey. She specializes in SAP NetWeaver BW and reporting using SAP BusinessObjects toolsets and BEx Query.

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.