Custom Analytical Queries in S/4HANA

The integration of Embedded Analytics in S/4HANA provides users with a comprehensive reporting tool to access data from different business areas in real time. To meet individual reporting and analysis requirements, the Fiori-based technology of "custom analytic queries" offers flexible design options.

Published: Last updated:

Analytics, Blog, Finance & Compliance, SAP, Video

1 min. Reading time
Custom Analytical Queries
Custom Analytical Queries

Custom Analytical Queries in S/4HANA: Flexible reporting and data analysis in SAP

With embedded analytics integrated into S/4HANA, users are provided with a comprehensive reporting tool that can be used to access data from different areas of the company in real time. The challenge for companies is to structure and, if necessary, visualize the underlying data in such a way that their individual reporting and analysis requirements are met at all times.

In order to give companies flexible design options in the definition of their data analyses in this context, without having to leave the SAP standard, the Fiori-based technology of “Custom Analytical Queries” is available within Embedded Analytics.

The Custom Analytical Queries application is a powerful tool that helps transform and organize relevant data from the various SAP modules (see also Figure 1). The basis is always an individual and easily configurable query, which is used to display the required dimensions, selection criteria or key figures within an output structure. In addition, it is possible to combine different data from different SAP modules within one query via flexibly definable data sources. In this way, the technology of user-defined analytical queries makes a decisive contribution to companies gaining a deeper insight into their business processes and thus being able to make more informed decisions.

Grundlagen benutzerdefinierte analytische Abfragen
Grundlagen benutzerdefinierte analytische Abfragen
Grundlagen benutzerdefinierte analytische Abfragen
Grundlagen benutzerdefinierte analytische Abfragen

Key features and benefits of custom analytic queries include

  • Creation of company-specific analysis and evaluation structures based on various data sources
  • Definition of customizable key figures and ratios from various SAP modules such as FI, CO, SD or MM
  • Flexible design of report grids (row and column structure)
  • No extensive programming knowledge required, making the application accessible to a wider range of users
  • Reports can be displayed within Embedded Analytics, printed or exported to various formats such as Excel or PDF.
  • All standard functionalities from Embedded Analytics are available; these include drill-down, slice and dice functions or variable structure and dimension adjustments

By creating user-defined analytical queries within their own SAP Fiori apps, users can access data in a uniform and intuitive user interface and evaluate it in a goal-oriented manner. This creates the technological basis to further optimize data analysis processes and ultimately processes for decision-making.

Would you like to learn more about this?

Please feel free to contact us!

Your contact person

Victor Ehmann

Diverse Endgeräte für die Entwicklung mobiler Apps mit ansprechendem, blauen App UX-Design

Published on October 26, 2023

Charting Success in Mobile App Development: The Essentials You Need to Know

Mobile apps are invaluable in the business world for improving operations and engaging customers. But app development can be challenging. In our article, Anna Moleda, head of mobile technology at Convista, shares key recommendations for success. Focus: app security, privacy…

Mann arbeitet im Office am Laptop mit Commodity Hedge Management

Published on July 10, 2023

Commodity Hedge Management: How to maintain costing certainty despite volatile markets

In recent years, it has become increasingly apparent that commodity markets are particularly susceptible to crises. These cause enormous volatility in procurement prices, with immediate and long-term effects on costing certainty for companies, especially in the industrial metals sector. Many…

Predictive Maintenance

Published on May 12, 2023

The 7 biggest advantages of Predictive Maintenance

Machine maintenance plays an important role in industry to avoid unexpected breakdowns and high downtime costs. In this context, there are two different approaches: Classic reactive machine maintenance and the new predictive maintenance, also known as predictive maintenance. The advantages…