Skip to main content

SAP S4HANA Embedded Real-Time Analytics - 3/4 Indicator Management

· 4 min read
Tiven Wang

In our previous two articles, we introduced:

This article will explore how to manage indicators in the S4 system using CDS View and other models to build a comprehensive business indicator system.

Xpert Analytics Cloud, leveraging semantic models, offers powerful indicator management functions, designed to help users efficiently manage and monitor indicators within data models. By establishing a unified semantic modeling of enterprise data based on a core OLAP engine, Xpert Analytics Cloud eliminates the need for cumbersome data conversion and ETL. Through unified indicator definition functions, it enables unified management and certification of enterprise operational data. Ultimately, indicators are used for analyzing and evaluating company business and financial data through the indicator applications and story dashboards provided by Xpert Analytics Cloud.

Outstanding Analysis
Outstanding Analysis

Key Performance Indicator System (Indicator System) is a set of indicators used to measure and monitor business performance. These indicators help enterprises evaluate the achievement of their strategic goals and the efficiency of their business processes, thereby guiding management decisions.

Background Review

CDS Views in the SAP S/4HANA system development package VDM_SD_ANALYTICS are standard sales analysis views provided by SAP. We selected the Sales Volume and Outstanding Sales query view for analysis, related CDS views include:

  • Analytics Catalog: 2CISDSLSANACUBE1 Analytics - Sales Volume and Outstanding Sales
  • Query 2CISDSLSANACUBE1/2CCSDSLSANALYTICQ1 Analytics - Sales Volume and Outstanding Sales
CDS Query
@Analytics.query: true
@AbapCatalog.sqlViewName: 'CSDSLSANALYTICQ1'
define view C_SalesAnalyticsQry_1
CDS Cube
@Analytics.dataCategory: #CUBE
@AbapCatalog.sqlViewName: 'ISDSLSANACUBE1'
define view I_SalesAnalyticsCube_1

We created the corresponding semantic model and enhancements for this. Next, we will use the Sales Volume and Outstanding Sales semantic model to create a complete set of indicators.

Indicator Design

There are the following methods for designing indicators for SAP S4 CDS models:

  • Define basic Measures in CDS, which are metric data directly extracted from the data source, such as sales amount, inventory quantity, etc.
  • Design calculated measures, which are indicators derived from calculations based on basic measures, such as year-over-year growth rate, average inventory turnover rate, etc.
  • Use Restricted Measures to constrain metric data based on specific conditions or dimensions, such as sales during a specific period, inventory in a particular region, etc.

Dimension Members Retrieval

Dimension Members Retriever is a key feature of Copilot Command Agents, providing more precise and efficient support for data analysis by dynamically synchronizing and quantifying dimension member information. Retrieve and vectorize the dimension members of the CDS View in the semantic model to ensure subsequent AI command agents accurately index key information of dimension members.

Indicator Registration

Register the corresponding indicators for the CDS View in the project interface.

/indicator-architect Indicator Architect

The Indicator System Architect command, based on user prompts and model information, can construct an analysis indicator system by referring to business role examples, creating indicators one by one. Use the following command to create a complete set of indicators:

/indicator-architect @2CISDSLSANACUBE1/2CCSDSLSANALYTICQ1 Create a complete set of data analysis indicators for this model

The command will suggest which indicators to construct, and after confirmation, they will be created one by one.

/indicator Single Indicator

In addition to using the Indicator Architect command to create a complete set of indicators, you can also directly create a single indicator for the CDS View in the project interface. Use the quick AI generation button in the interface, or use the /indicator command in the copilot dialog box to create a single indicator.

/indicator @2CISDSLSANACUBE1/2CCSDSLSANALYTICQ1 Create a sales volume indicator for product group "XXX"

Indicator Application

Once the indicators are created, you can view the corresponding indicator list in the indicator application and use these indicators in the story dashboard creation.

Summary

SAP S4HANA Embedded Real-Time Analytics provides powerful data analysis and indicator management functions for enterprises. Based on CDS Views semantic models, flexible analysis models and business indicator systems can be constructed. With the indicator management functions of Xpert Analytics Cloud, enterprises can efficiently manage and monitor indicators within data models and apply them to actual business analysis and decision-making.