How to Execute BEx Queries on Mobile Devices

  • by Venugopal Kambhampati, Supply Chain Planning/Reporting Architect, Hewlett-Packard
  • Jimmy Rubio, IT Developer/Engineer II, Hewlett-Packard
  • Jimmy Le, IT Developer/Engineer II, Hewlett-Packard
  • January 9, 2015
Learn a simple, elegant method for enabling the display of BEx Query results on mobile devices, saving time and money for your company. BI mobility is essential in order to accelerate and enable the anywhere/anytime visibility of your business. With the methods discussed, learn how to execute all your BEx Queries, from disparate data sources, on mobile devices without incurring additional BEx Query work or license fees.
Key Concept

The Internet Communication Framework (ICF) is an integrated component of the application server in SAP BW. ICF allows you to communicate with the SAP BW system using standard Internet protocols (e.g., HTTP, HTTPS, and SMTP). ICF is used to enable the delivery of BEx Query output as a JSON or XML file, for consumption by a JavaScript, or any other consumer web server—in other words, to present BEx Query results in a web browser or mobile display.

Many companies have invested a lot of time and money in creating new data models, data cleansing, and in ETL-related work in their SAP BW system. In addition, hundreds of BEx Queries need to be created to report on the data that is loaded daily from disparate data sources into the SAP BW system. However, most users want to be able to execute all those BEx Queries on mobile devices. Using our simple guide, learn how to go mobile by simply leveraging the investment already made in your SAP BW system.

In our guide, we show how to display BEx Query output on mobile devices, including a look at the end-to-end architecture and a description of the various technical components. This step-by-step approach enables you to create the critical mechanisms for going mobile, along with some simple code snippets to make this task easier. The sample code has been provided to accelerate your time-to-value delivery. This mobile solution requires no additional IT investment, other than some internal, fee-free development work.

Creating and Executing BEx Queries on Mobile Devices

Let’s begin with an overview of SAP BW and BEx Query creation (Figure 1). On the left side of the illustration is SAP BW. Here you see a cube and DataStore Object (DSO). These are representative objects for any existing InfoProviders you might have in your SAP BW system. Similarly, the BEx Queries shown are any existing BEx Queries in your SAP BW system. Later in this article we explain how to create the web-service components inside SAP BW that convert the output of the BEx query into a JavaScript Object Notation (JSON) file format, which will be interpreted or presented on the mobile device by the web server. In addition, we provide a snippet of the JavaScript code as well, to highlight the critical components.


Figure 1
End-to-end high-level view of the BEx Query creation and execution process (the yellow boxes indicate the required work)

Venugopal Kambhampati

Venugopal Kambhampati has 19 years of experience working with Hewlett-Packard supply chain IT systems. Recently, he has been engaged as the Supply Chain IT Architect for planning systems, focusing on the desktops and notebooks for both consumer and commercial businesses in the Americas region. Venugopal is a Certified Supply Chain Professional (CSCP) with an in-depth understanding of the supply chain business. Combining this business knowledge with a keen interest in learning new technologies allows him to deliver cost-effective IT solutions using innovative methods.

See more by this author

Jimmy Rubio

Jimmy Rubio is an IT Developer/Engineer II at Hewlett-Packard, with nearly four years of SAP experience. He has extensive knowledge of ABAP and BW development. Jimmy is a graduate of the University of Houston’s C. T. Bauer College of Business.

See more by this author

Jimmy Le

Jimmy Le is a Supply Chain Developer/Engineer II at Hewlett-Packard. He helped develop and implement a mobile web app that allowed Hewlett-Packard to understand how its products were fairing in retailer stores against competitors and how promotions impacted Hewlett-Packard product sales. Jimmy is responsible for working with designers to implement interactive dashboard designs using HTML5 and CSS3, optimizing JavaScript using jsPerform, designing optimized data structures, and implementing JAVA web services with a backend team and demo tool.

See more by this author


Comments

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.