Relative Date Function in Analytical KPIs / Apps
Relative Date Function is a feature function to return a date that is relative to a base date. Depending on the date function chosen the corresponding start and end date gets automatically calculated. As part of standard delivery there are predefined date functions like for example
- PREVIOUSYEARTODATE: If current date is 30th August 2019, then this date function shall return date range: 01.01.2018 to 30.08.2019
MONTHTODATE : If current date is 30th August 2019, then this date function shall return date range: 01.08.2019 to 30.08.2019
so on and so forth. Given below is a screenshot of Value help for Relative Date Function from the Analytical KPI – Off-Contract Spend
Why is it necessary?
Dynamic filtering of data based on dates is a typical requirement in analytical apps / use cases, primarily the Smart Business Framework based KPIs. This enables you to use the pre-defined date ranges out of the box.
Can I create custom date range?
With the “Date Function” app, customer can define a date range that matches their own requirement. Refer to the help documentation here to understand how to create custom date ranges.
Can I define a custom date range without any pre defined base date?
No, currently it is not a supported feature
Can I display description instead of ID in the “Relative Date Function” Parameter?
No, currently it is not supported