Customer use case of Embedded Analytics on sales order overview with VC

[AngelaDai]

The sales order overview with VC developed in the blog is a proof-of-concept of the customer system implementing embedded analytics to verify that Variant Configuration related information can be captured in SAP S/4HANA Cloud Public edition and supports the visualization of their data. In this blog, you will learn how to implement embedded analytics to customize a report of an overview of sales orders with VC.

What’s customer’s request?

The customer enables VC-related functionality on their business, so they want to view detailed information about the sales order, especially the characteristic values information on the sales order line item, when viewing multiple sales orders. However, relevant data sources that provide characteristic values are currently not supported by SAP.

Based on this requirement, customers can use embedded analytics to create customized CDS views, present characteristic value information, and associate with other data sources for analytical purposes.

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.

1. Create Custom CDS Views

In order to capture a variable characteristic value, you need to create a custom CDS view for it.

Enter the APP Manage classes and create a class of type 399. (Note: Check if you have the business role SAP_BR_PRODUCT_CONFIG_MODELER).

Add the attributes you want to see under the newly created class.

Once created, go to APP Classification/Configuration CDS Views - Generate Analytic Views to generate CDS views for the selected characteristic values.

Select the class type as 399, and the class you created in the predecessor step, provide the CDS view name, and click Go. Up to this generation of CDS views containing characteristic values.

Then link the information from the sales order and the newly generated CDS. CDS views containing characteristic values cannot be used as primary data sources.

Enter the APP custom CDS view, create a new custom CDS view, and select the scenario of analytical cube. Add I_SalesOrderItemCube as primary data source and CDS view of characteristic values as associated data source.

Then maintain the join condition to associate the product configuration field from the data source.

Add elements as per your business needs. Add characteristic values and product configuration to the view.

Maintain the element properties. When you are done, you can click Publish.

After publishing, you can preview the CDS view's data.

1. Create a Custom Analytical Query

Locate the app Custom Analytical Query and Services in the Home page and create a new custom query. Select CDS created in preceding step as data source and add fields.

Then save and publish the query.

• Create 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.

• Create App

Customers can publish the relevant stories or queries as apps according to their business needs.

Conclusion

For more information about VC analytics, you can refer to SAP Note 2953142 - Variant Configuration/Classification Analysis in SAP S/4HANA - SAP for Me

By using embedded analytics, customers can efficiently leverage powerful analytics capabilities to solve analytics problems on the business. In the future, we will continue to share more success stories about embedded analytics.

For more information about SAP S/4HANA Cloud embedded SAC, you can 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
• Customer use case of Embedded SAC on Inventory Aging Report (Enhanced): click here
• Customer use case of Embedded SAC on Sales Gross Profit Analysis: click here
• Customer use case of Embedded SAC on Goods Movement Analysis: click here
• Customer Use Case of Embedded SAP Analytics Cloud on Outbound Delivery and Billing Overview: click here
• Customer use case of embedded SAP Analytics Cloud on Sales Order Fulfillment Analysis: click here
• Customer use case of Embedded SAC on Group Reporting: click here
• Customer use case of Embedded SAC on Account Balance Comparison Across 3 Years: click here
• Customer use case of Embedded SAC on Financial Key Figures Comparison: click here
• Customer use case of Embedded SAC on Purchasing Reconciliation Dashboard: click here