Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
uladzislau_pralat
Contributor
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
Labels in this area