Challenge 7: Analytical Dashboard Using SAP S/4 Hana DB
Introduction
Contoso inc. is a manufacturing company planning to modernize its IT infrastructure. As a part of that efforts, they want to Generate self-service report from SAP HANA DB tables using Microsoft power BI desktop client and develop a self-service report for visualization and analysis.
Description
This exercise includes connecting power BI desktop client to HANA DB (using direct query with DB user and password), Extract data from the required tables (using semantic SQL query) and Generate self-service Job status report.
A high level architectural diagram can be found below.
Tips
-
Download and install SAP HANA client for windows from SAP Service Market Place.
-
Download Power BI desktop from windows power app platfrom.
-
Leverage SAP HANA studio (from Challenge 4) to create the user and required roles and previleges to execute the select query to populate the power BI desktop client.
-
For the HANA DB create the SCHEMA user with admin rights on SAP SCHEMA and assign appropriate roles and privileges to extract the data.
-
New user ID in HANA is able to connect to Tenant database where SAP application DATA is residing including the SAP Job log table TBTCO.
NOTE: Below link gives you more details on what is system DB and tenant DB in SAP HANA database.
-
Run the query both in System DB and Tenant DB to indentify the SQL port to connect from Power BI to SAP HANA.
NOTE: All the details will be found how to query the port both from SYSTEM DB and Tenant DB in SAP HANA from the below link.
-
SAP HANA ports will be 3NN40-3NN99, NN is the system number for HANA.
-
Leverage direct query for data connectivity Mode.
-
Report should have a matrix, a pie chart and a bar chart.
-
SAP HANA database has to be up and running when participants try to refresh the data from Power BI desktop.
Success Criteria
- Create PowerBI Dashboard displaying data from SAP HANA DB.
- Generate self-service report from SAP HANA DB tables using Microsoft power BI desktop client and develop a self-service report for visualization and analysis.
- Publish the visualization from Power BI desktop to power BI Service for broader user community.