Customer use case of Embedded SAC on Goods Movement Analysis
SAP introduces the seamless integration of S/4HANA Cloud with SAP Analytics Cloud (SAC) with 1911. It enhances the analysis function of the current system and can better help customers analyze business related data. What’s more, the embedded SAP Analytics Cloud is now fully managed by SAP S/4HANA Cloud that exposes the embedded SAP Analytics Cloud functionality through Fiori applications, which is easy for customers to understand and use the function. In this blog, a successful use case of Embedded SAC on Goods Movement Analysis will be shared to readers to show its powerful functions and to introduce the key steps to implement it in detail.
What’s customer’s request?
Though there is a standard Fiori report for material movement, it doesn’t satisfy the customer requirement. The customer wants to get more information from the report, such as supplier name, cost center description, etc. but no such offerings in the standard Fiori report. Therefore, embedded SAC has been introduced to the customer to customize the Goods Movement Analysis which can provide the information that the customer wants.
How to solve the problem?
There are four main steps to implement Embedded SAC: creating Custom CDS View, creating Custom Analytical Query, creating Story and creating an Application. The specific steps will be described in detail below. To protect customer sensitive data, some of the screenshots come from dummy test system.
• Creating a Custom CDS View
Click Custom CDS View in Extensibility catalog.
Input the related parameters and choose the scenario: Analytical Cube.
Select I_GoodsMovementCube as Primary Data Source which can show the Goods Movement. Then add I_ProductText, I_CostCenterText and I_MaterialDocumentHeader as the Associated Datasource. The I_ProductText can provide Material Description, I_CostCenterText can show the Cost Center Description and I_MaterialDocumentHeader can provide the Material Document Head Description.
Maintain Join Condition and Edit Cardinality to be [0…1].
I_ProductText is maintained as follows.
I_CostCenterText is maintained as follows.
I_MaterialDocumentHeader is maintained as follows.
Maintain Element Properties.
Finally, save and publish custom CDS View.
• Creating Custom Analytical Query
Click Custom Analytical Queries under Query Design catalog.
Create a new query and fill the name(Goods Movement) and label(YY1_GOODMVQRY) of it. Select Material Movement (YY1_GOODSMOVEMENTCUBE) as the DataSource.
Complete the Field Selection.
Create the Calculation measure unit price: ZPRICE
Assign the user input to the field of Posting Date, and the default value is previous month.
Save and publish the query.
• Creating Story
The Create Story page allows customers to define SAP Analytic Cloud story for a selected data source. Customers can create different visualizations to the data source. Multiple data sources can be added to the story and users can design interactive dashboards, create new pages, and add visualization such as charts, tables, and other graphics to visualize the data. The items on the page such as chart are arranged as tiles that can be moved around, resized, and styled to your liking.
Therefore, we have defined an SAP Analytic Cloud story for the new created data source to visualize the data that the customer wants to show on the page.
Firstly, navigate to KPI Design group in the Fiori Launchpad (FLP).
Choose “Stories” tab from the Manage KPIs and Reports app page. To create a custom story, choose + (Add).
The Create Story page appears. In the Definition tab, enter the title in the Header section and description in Business Information section.
Go to Configuration tab to define the story. A pre-defined template will be loaded. Select a query from the list to build the story. Here we choose YY1_GOODMVQRY As Primary Data Source.
Design layout as you prefer. Remove all the default created title input fields.
Insert Image or Shape.
Insert table and adjust the table styling.
Create Input Filter.
So far, the creation of the story is completed.
• Creating an Application
To create an application (aka FLP Tile) to launch the story, choose Applications > Add Tile.
Choose a Tile Type format from the various options.
Fill out all the details and click on “Save and Publish”.
After successful save of the tile, it will navigate to “Custom Catalog Extension” app to publish a tile in the desired catalog. In “Custom Catalog Extensions” App, add a catalog to publish the tile.
Publishing tile and check tile:
On successful publish, the tile will be available on the Fiori Launchpad.
In this blog, we show how to create a custom SAP Analytics Cloud Story or Dashboard via S/4HANA Cloud and embed it in S/4HANA Cloud Fiori Launchpad. The customized Goods Movement Analysis can provide all the information that the customer wants which fully meets the customer’s business needs. By using the S/4HANA Cloud embedded SAP Analytics Cloud, it becomes efficient to help customers solve problems with its powerful function. In the future, we will continue to share more successful stories of embedded analytics to readers.
For more information on SAP S/4HANA Cloud embedded analytics with SAP Analytics Cloud, check out the following links:
· Customer use case of Embedded SAC: how to create custom SAC story and the dashboard in S/4HANA Cloud: click here
· A Customer Use Case of Embedded Analytics in S/4HANA Cloud – Extend the Possibility: click here
· Customer use case of Embedded SAC on Material Stock Analysis: click here
· Customer use case of Embedded SAC on Inventory Aging Report: click here