We have created a Custom Analytical Query that is based on a Custom CDS View that joins following views: I_EngmntProjSalesMarginCube and I_EngagementProject.
We now want to use the query in a KPI to display (on a tile) the planned revenue for projects that start in the current month.
This works fine when we hard code the date in the Input Parameters and Filters of the KPI’s evaluation path.
However when using the Date Functions FIRSTDAYOFCURRENTMONTH AND LASTDAYOFCURRENTMONTH, the KPI tile returns and error.
How can we use a dynamic date for the KPI tiles?