Integrate a Dashboard into the SAP GUI

  • by Iryna Krauchanka, Senior Software Engineer, SAP BI Solutions, EPAM Systems
  • Syargei Rassadzin, SAP Solutions Organization Consulting Team Leader, EPAM Systems
  • March 21, 2011
When the standard SAP GUI interface becomes too bland or difficult to follow, you can augment it so that it is more user friendly. Engage executives, management, and end users with SAP ERP data visualizations within SAP GUI by using SAP Crystal Dashboard Design.
Key Concept
SAP Crystal Dashboard Design allows you to enhance analytical applications’ user interfaces and create dashboards. Usually users can browse dashboards within portals and desktop applications, but not in a transactional system. SAP Crystal Dashboard Design was formerly known as Xcelsius.

You can perform data analysis on almost anything in the SAP ERP system, but sometimes the SAP GUI makes the data hard to understand. Rather than spending too much time sifting through it, or, for higher-level management, ignoring it due to a lack of user friendliness, you can adjust it by performing a few simple steps.

This involves using SAP Crystal Dashboard Design (formerly Xcelsius) and Web services in conjunction with SAP ERP. We’ll show you how to create an example SAP transaction that allows business users to analyze monthly sales by customer, connect it to SAP Crystal Dashboard Design, and then create a user-friendly report that you can present to higher-level management. This article is intended for technical users.

In our example we create a simple function module to display data from tables VBAK and VBAP with two input parameters (date and company code). To do this, follow these steps:

Step 1. Create a function module to operate with the SAP ERP data

Step 2. Create a Web service from the function module

Step 3. Create a connection in SAP Crystal Dashboard Design (Web service connection) and implement the logic

Step 4. Create a report in SAP ERP to integrate the dashboard

Iryna Krauchanka

Iryna Krauchanka is a senior consultant for the SAP Solutions Organization at EPAM Systems. She has more than four years of experience in IT technologies, including about three years of experience in development, implementation, customizing system settings, and support of SAP products. Her main focus is reporting, SAP NetWeaver Business Warehouse, and SAP BusinessObjects BI solutions. Her area of expertise includes three years of experience in ABAP/4 programming in BI solutions.

See more by this author

Syargei Rassadzin

Syargei Rassadzin is a consulting team leader for the SAP Solutions Organization at EPAM Systems. He has more than 10 years of experience implementing SAP BI products and more than 14 years of experience implementing SAP Business Objects products. In addition, he has more than 17 years of experience in consulting, software development, and testing. An SAP-certified application associate and certified project manager at the International Project Management Association (IPMA) level C, his main area of expertise is data warehouse design and reporting with multiple back-end systems (e.g., SQL Server, SAP NetWeaver BW, and Oracle).

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.