Thomas Born
How to set dynamic date filter for KPI evaluation path
Thomas Born · 12 months ago · Question
Answered
Thomas Born

Hi;

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?

FilterStatic.pngFilterDynamic.png

 

Thanks

Thomas

Comments

Comments
Alumni