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.