Forum Stats

  • 3,838,255 Users
  • 2,262,346 Discussions
  • 7,900,558 Comments

Discussions

how to get first period of the fiscal?

User_U19UV
User_U19UV Member Posts: 1 Green Ribbon
edited May 25, 2022 5:54PM in Hyperion Query and Reporting

We need to build an FRS report.

We want to show the First period of the Fiscal year at any given point of time in the report.

Example:

IF we run the report for Mar-22, the report has to display the data for Mar-22 and Jan-22.

IF we run the report for Sep-22, the report has to display the data for Sep-22 and Jan-22.

IF we run the report for Apr-21, the report has to display the data for Apr-21 and Jan-21.

How can we achieve this?

Answers