Skip to Content
0
Former Member
Mar 19, 2014 at 10:49 AM

HOW TO GET FISCAL PERIOD WISE DATA BY GIVING FISCAL YEAR AS INPUT

436 Views

Hi All,

I am creating a report where input field is FiscYear(0FISCYEAR). My fiscal year is Oct to Sep and 4 spl periods.

If we give input as 2014 (current FY) it has to show all fiscal periods as on date. i.e., Oct’13 to Feb’14. Which should show in columns each period
separately, like Oct 13, Nov’13, …. Feb’14.

If we give 2013, it has to show all fiscal periods separately each period in columns. i.e., Oct’12 to Sep’13.

InfoProvider Data: We have a cube, containing data for 0CALMONTH and Fiscal Year. No fiscperiod in the cube.

Could any one assist here as it’s a bit odd scenario never come across. All your suggestions and assistance are highly appreciable.

Best Regards

Venkat...