Skip to Content
0
Former Member
Aug 07, 2009 at 09:45 AM

Variable on Fiscal Year

26 Views

Hi All

Please help me urgently....there are a couple of reports in our system which is based on Fiscal Year (as Selection only)

In the Rows, the report designer has hardcoded the Months AND YEAR 2008.

So when management select FiscalYear 2010 (our Fiscal year Variant V3 runs from April -March), the report displays ie.

April 2008

May 2008

June 2008

In fact it it should start with April 2009 if we put in 2010 as FY(0FiscYear)

Please can you help me setting up a variable so that it can detect the correct year when displaying the query.

The hardcoded Months is =

Fiscal Year 0FISCYEAR restricted to OP_FYEAR;

Posting Period (0FISCPER3) restricted from 1-12 (In Rows but named eg,July etc) &

Key Figure

Please can you guide me step by step to have the rows display the correct year after the Month.

Thanking you