How to pass period number parameter to EPM Agent query when fiscal and calendar year don't match
Summary:
Hi All,
I am using EPM Integration Agent to integrate with PeopleSoft. My client's fiscal year and calendar year do not match and the queries require the passing of the period rather than date. For example, September 2021 is really their period 1 of FY22. In the query, I need to pass period = 1 and year = 2022, but using the $START_PERIODKEY$ token gives me period = 9 and year = 2021.
Any ideas on how to accomplish this would help. Thank you!
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
-1