FIORI Custom analytical query. Restricted measure for year don´t work as expected

[ralfkahl]

Hi all,

please clarify the behevoir of custom analytical query. I want to have the difference between the actual amounts of two years.

I have created a restricted key figure "Actual Previous Year" with the user input field. And I see that the data in this column is empty if "Previous year" is not equal to "Ledger fiscal year". For example, if I add 2024 and 2025 to "Ledger Fiscal Year", I can use 2024 or 2025 in "Previuos Year" and see the data.

So it looks like the selection of data from the database is always done with the "Ledger Fiscal Year" and the restricted measure can only use the selected data.

Is this really so by design? I´ve expected, that the data will be selected for restricted measure separetely.