Analytical Queries play an important role in SAP S/4HANA analytics. Analytical Queries sit on top of cubes and generate meaningful data sets that business users can explore using their own front-end tools, such as Fiori Review Booklets, SAP Analytics Cloud and Analysis Office (XL). Analytical Queries are developed using ABAP CDS in the ADT tools of Eclipse.
A new, free-of-charge Learning Journey is provided to help you quickly develop skills in this popular topic. The Learning Journey can be found here.
The CDS source files and data used in the course are available to all learners, along with instructions to setup your own cloud ABAP environment. This means you can follow along with the course, or practice what you have learned in your own environment and even try out your own ideas without having to setup a data model from scratch. You will find the course files and instructions for importing into your own system here.
We updated the course recently (July 2025) and it now includes the important topic 'Working with Structures' plus some clean-ups and corrections.
For the next update of the course (planned end of year 2025) we will add content for:
- How to implement time dependency hierarchies and attributes
- How to implement commenting
- Elimination of internal business volume
- Advanced OLAP features
For subscribers to the SAP learning platform (learning.sap.com), we also offer access to unlimited SAP Live Sessions where you can engage with experts in short, live sessions on topics around any SAP topic, including CDS analytical query development. We have already run various sessions covering CDS analytical query development and more are already scheduled. You can also access recordings of Live Sessions that you missed. For details click here.
Bluesky
