Report Requirment for YTD and individual fisc periods

[Former Member]

Hi Team,

I have a requirement in the report that should have the below structure

Fiscal Year Actual Actual Actual Actual Actual Actual

YTD 2008 2009 2010 2011 2012

Char1 Char1 FiscalPer APR 2010 MAY2010 .... MAR2011

Fiscal Year and Fisc period are in column and Char1 and Char2 are in Rows of the report.

For a particular year alone, I need the actual amount splitted on fiscal year period and rest of the past and furture years the actual amount should be aggregated for the year.

Please let me know if have come across this scenario.

Regards,

Ramesh

Edited by: ramesh kumar on Aug 10, 2010 5:52 AM

[Former Member · Accepted solution]

Hi Ramesh,

I am assuming your scenario as followes -

If User enters year(user entry variable) - 'Y1', You need to display key figs by - 'Y1Period 1'....... 'Y1Period 12'. For rest of the years(future and past from Y1), data should be aggregated and displayed per year.

The solutions would be -

Create Restricted Key Figs, for Y1Period1 - restrict it to user entry variable for year(Y1) and then to posting period hard coded to 1. Similalry create rest of the key figs for each period by changing the hard coded period value for 1 through 12.

Create restricted key fig for past years from Y1 - restrict it to user entry variable for year(Y1) and then add offset of '-1'. Simmilarly create rest of key figs for other previous years by increaing offset -2, -3 so on.

Create restricted key fig for future years from Y1 - restrict it to user entry variable for year(Y1) and then add offset of '+1'. Simmilarly create rest of key figs for other future years by increaing offset +2, +3 so on.

Hope this helps.

Regards,

Pritesh.

[Former Member]

Hi,

If seperate definition is required for evry column the cell defintion using structure can solve your issue.

I hope it will help.

Thanks,

S

[Former Member]

Hi All,

Thanks for your inputs, I will go with individual KF's for every column. I guess the cell definition will affect the performnace of ther report.

Thanks,

Ramesh

[former_member212742]

HI Ramesh,

In this case you need one key figure definition for one columns. For example you need year 2008 and 2009 aggregated by year and 2010 by fiscal period , then create 12 restricted KF for 2010 by fiscal period and one each for 2009 and 2008 respectively with appropriate selections.

Hope this Helps.

Regards.

Shafi.