cancel
Showing results for 
Search instead for 
Did you mean: 

GR: Previous period of Fiscal Year Period dimension in Custom Analytical Queries App

cristina_29
Explorer
0 Kudos

Hi all,

I need to bring the previous period of the Fiscal Year Period dimension based on the period selected by the user in this dimension through Custom Analytical Queries app. For example, if user selects period 001.2023, the query should bring the data to period 012.2022. I have tried to create user input filter with the derivation functions "Fiscal year period shift" but the system only brings the selected period through the Fiscal Year Period variable. Does anyone know what I can do?

Thanks in advance!

Regards.

View Entire Topic
sapherm1
Discoverer
0 Kudos

Hello Cristina,

May I ask, how did you solve this problem regarding fiscal year shift comparison with custom analytical query ?

Thanks !