Flexible S/4HANA Embedded Analytics Report Scheduling Using Date Function

S/4HANA Embedded Analytics is coming with Date Functions. Date Functions allow to define dynamic date ranges for KPIs and Smart Business applications. But this is not the only use. Date Functions can also be used for flexible scheduling of S/4HANA Embedded Analytics report in Business Objects.

In my example, BOBJ Webi report built on top of S/4HANA ABAP CDS view is scheduled with PREVIOUSMONTH Date Function to report on previous month data. Any other standard or custom Dynamic Function can be used without need make any ABAP CDS view changes.

But what is the catch? ABAP CDS view need to be programmed to take Date Function as parameter and derive date range selection from it. In my blog I will explain how to do that.

What you need to do program ABAP CDS view according to Data Function requirements:

1. Define Date Function dimension
2. Define Date Function parameter with value help
3. Define Date From and Date To parameters with value derivation
4. Limit data with Date From and Date To parameters

Define Date Function dimension

Define Date Function parameter with value help

Define Date From and Date To parameters with value derivation

Limit data with Date From and Date To parameters

Source code can be downloaded from GitHub:

ZI_DateFunction

ZC_PriceChangeQuery