Skip to Content
Aug 25, 2020 at 08:51 AM

Default Filter for fiscal period for Custom Analytical Queries



Not sure if I am missing something obvious, but there seems to be no support to define a default filter for custom analytical queries based on fields related to fiscal variant, e.g. Fiscal Period, Fiscal Year, Fiscal Week etc. You would think the system allows you to build a default filter and set it to current FY or to current fiscal period.

The date functions that are available are all related to the calendar year. Also there is no option to set a dynamic filter for fiscal period fields

The only way I can see this working is to include the Fiscal Period Start and End Dates as part of the underlying custom cds view and then use date function in the filter

This can work when a fiscal period relates to a month, however in our case it does not work well because we are using a 5-4-4 weeks fiscal year variant. Does anyone have a solution for this.

Same obviously applies when creating KPI's.




31044-image.png (33.9 kB)
31045-image.png (33.4 kB)