Skip to Content
Product Information

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.

1.png

Input the related parameters and choose the scenario: Analytical Cube.

2.png

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.

3.png

Maintain Join Condition and Edit Cardinality to be [0…1].

I_ProductText is maintained as follows.

4.png

I_CostCenterText is maintained as follows.

5.png

I_MaterialDocumentHeader is maintained as follows.

6.png

Add Elements.

7.png

Maintain Element Properties.

8.png

Finally, save and publish custom CDS View.

Creating Custom Analytical Query

Click Custom Analytical Queries under Query Design catalog.

1.png

Create a new query and fill the name(Goods Movement) and label(YY1_GOODMVQRY) of it. Select Material Movement (YY1_GOODSMOVEMENTCUBE) as the DataSource.

2.png

Complete the Field Selection.

3.png

Create the Calculation measure unit price: ZPRICE

4.png

Assign the user input to the field of Posting Date, and the default value is previous month.

5.png

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).

1.png

Choose “Stories” tab from the Manage KPIs and Reports app page. To create a custom story, choose + (Add).

2.png

The Create Story page appears. In the Definition tab, enter the title in the Header section and description in Business Information section.

3.png

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.

4.png

Design layout as you prefer. Remove all the default created title input fields.

5.png

Insert Image or Shape.

6.png

Insert table and adjust the table styling.

7.png

Create Input Filter.

8.png

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.

1.png

Fill out all the details and click on “Save and Publish”.

2.png

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.

3.png

Publishing tile and check tile:

On successful publish, the tile will be available on the Fiori Launchpad.

4.png

Conclusion

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

Be the first to leave a comment
You must be Logged on to comment or reply to a post.