Customer use case of Embedded SAC on Financial Key Figures Comparison
This is a Proof of Concept in customer system for embedded analytics / embedded SAC. S/4HANA Cloud Embedded SAP Analytics Cloud can enhance the analysis function of the current system and can better help customers analyze business related data. In this blog, the successful PoC of Embedded SAC Financial Key Figures Comparison will be shared to show its powerful functions and to introduce the key steps to implement it in detail.
What’s customer’s request?
There is already a long list of standard analysis apps in S/4HANA Cloud. But customer in specific region or with special purpose will request for dashboard/report with a specific format. For this customer, financial department wants a view on finance KPIs across multiple years among different company codes grant customers the flexibility to compare finance performance among different company codes and identify trends along the time span of several years.
The report includes basic financial KPI like Accounts Receivable Turnover and Inventory turnover and sales net profit, cash ratio, sales-to-revenue ratio, and also the trend. In the prospectus these KPIs need to be disclosed to the public to present the financial situation of the customer and can be shared to the management to monitor the status as well.
The content of the table could be as follow:
Currently, there is no CDS Query or Fiori application that allows the comparison of Finance KPIs across 3 fiscal years for multiple company codes. Most CDS view (e.g. C_FinancialStatementKPI ) provides finance KPI information for fiscal periods of one fiscal year. Therefore, we recommend that customers use the Embedded Analytics Cloud to create a Key figure report to reflect customers’ financial health statistics.
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 Creating Custom CDS Views
No custom CDS view are created in this use case, we use standard CDS.
CDS View I_GLACCOUNTLINEITEM contains all the required fields and data required to calculate account balance for all company codes for all the fiscal year/period.
2 Creating Custom Analytical Queries
Find the Custom Analytical Queries app from menu Query Design and create a new custom query.
Custom CDS query YY1_KPIV4QRY is created on top of CDS View I_GLACCOUNTLINEITEM with key figure “AmountInCompanyCodeCurrency” to provide the required comparison capabilities.
Select Fields according to your requirement. Then add restricted measures and User Input like Fiscal Year (Current Period) and Fiscal Year (Last Year) if required.
As a new feature in CE2111, hierarchy nodes value can be set for a hierarchy element. And in this report, some user inputs need to be created based on Hierarchy Node of dimension GLAccount.
Take Revenue as an example.
Then create Restricted Measures using Hierarchy Node User Input on GLAccount.
Create Restricted Measure on GLAccount Value.
Create Restricted Key Figure on Function Area, if necessary, especially for those regions that need to narrow down to the balance that could not be covered on the account level.
Then add calculated measure to calculate key figure, like below:
Add Characteristic Structure Element and then add “Restricted Structure Element”. Take “Current Period” and “Period increase/decrease rate” as an example.
Then save and publish the query.
3 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.
Customers can create new stories that show some of the required key figures and icons showing detailed information based on their business needs.
4 Creating an Application
Customers can publish the relevant stories or queries as apps according to their business needs.
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 dashboard can provide all the information the customer required, which fully meets their 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
- 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