Visualize S/4HANA CDS View with Data Warehouse Cloud
In the previous blog, I made a connection to S/4HANA, on premise SAP HANA, and SAP HANA Cloud from the Data Warehouse Cloud (DWC).
In this blog, I will visualize the data of CDS Views in S/4HANA through the SAP Data Warehouse Cloud.
I will follow the steps below:
- Create Graphical View
- Replicate data from S/4HANA to Data Warehouse Cloud
- Create a story
1. Create Graphical View
First, select “Data Builder” from the menu icon on the left and select the Space where the connection is created.
Click “New Graphical View” to create a new view.
In the left pane, you can select data sources of the view from both Repository (tables and views on Data Warehouse Cloud) and Sources (objects on the source systems). In this blog, I will select “Sources” to directly connect to CDS View on S/4HANA.
If you select “Sources”, the list of defined connections is displayed. Open the S/4HANA connection “S41” and you can see that we can extract data from ABAP tables, BAPI procedures and Extractors.
In addition, when you open “Extractor”, you can see that you can select “ABAP CDS View, BW (technical contents), HANA and SAPI (extractors generally used for BW).
When you open “ABAP CDS”, you will see folders divided alphabetically and the CDS Views which can extract data (annotation “@Analytics.dataExtraction.enabled” is set to “true”) are displayed.
In this blog, I will select “CMMPOITMDX$F – Data Extraction View for PO Item”. Drag and drop it into the middle pane.
The CDS View has been imported. Enter “Business Name” and “Technical Name” in the “Properties” on the right. Select”Analytical Dataset” for “Type” and “ON” for “Allow Consumption” to visualize the data.
“Measure” is required because it is set to “Analytical Dataset”. Set the numerical item to be aggregated / calculated as “Measure”. Click the “…” icon on the right of the field name and select “Change to Measure”.
Field is set as “Measure”. The aggregation type is “SUM” in order to summary the data.
In addition, you can define further configurations such as hierarchy, calculation column, filter, join with other table, etc. However, this blog will leave it as it is, save and deploy it.
Select a target and click “Data Preview” to display a preview of the data. At this point, the data is not stored in the Data Warehouse Cloud, but connect to the source system (S/4HANA) each time.
Click “Preview SQL” to display SQL statement for data preview.
Go back to “Data Builder”, the saved “Graphical View” and source tables used by the view are displayed in the list.
2. Replicate Data
You can create a report (story) for the Graphical View created in the previous step. In this case, you will access S/4HANA every time you request data.
On the other hand, you can also replicate the data to Data Warehouse Cloud for better performance. In this blog, I will try to replicate data.
* At present (May 2020), only data replication is possible, but a data flow function is planned to be available within this year (2020), which enables so-called ETL processing that performs data transformation while extracting and loading data.
From the menu icon on the left, select “Data Integration Monitor”.
The table you created earlier (the table that references CDS View) is displayed. You can select “Remote” and “Replicated” in the “Data Access” column.
- Remote: Have no data in Data Warehouse Cloud and access the source system every time
- Replicate: Replicate data from source system to Data Warehouse Cloud
Now change the setting to “Replicate”.
You can select “None” and “Real-Time” as the “Data Frequency”. Here, I will select ‘None’.
- None : Stores the data as a snapshot. Data Warehouse Cloud will not be updated even if the data source is updated unless the snapshot is updated
- Real-Time : Replicate changes that occur in the source system to Data Warehouse Cloud in real-time
Data replication started.
Data replication completed.
Return to the Graphical View again to preview the data. You can see that the data preview can be executed faster.
3. Create Story
Finally, create a story using the created Graphical View as a source. Various graphical visualizations are possible using the functions of SAP Analytics Cloud.
In this blog, I will try to create a simple story. Select “Story Builder” from the menu icon on the left. Spaces will be displayed and select the space in which the Graphical View was created.
Click “Create Story” to create a new story.
In the data source selection screen, select the Graphical View which was created before.
You can create story using various components like chart, table, geo map, etc.
In this blog, I will use chart as an example. Select measures and attributes to visualize.
Save the story once completed.
I have introduced the flow of importing S/4HANA CDS View data into Data Warehouse Cloud and visualizing it.
With Data Warehouse Cloud, you have seen that it is possible to create data models, replicate data, and visualize data with a single tool and this enables flexible and quick data visualization and utilization.
This time, we simply visualized one data (one CDS View), but it is also possible to realize complicated data transformation (definition of joins, calculation items, hierarchy definition, etc.) and create more graphical story. I would like to introduce those on another blog.