It's all about Enterprise Performance Management

Many of you may have created Dynamic reports in FR, using the User Prompts.

I once got an opportunity to create one dynamically changing report, client had 4 Forecast scenarios and an Actual scenario.

They would like to get the report in the below given format

IF a User selects Forecast 1

Report should show Forecast 1 from Oct-Sep. (No Actual should be shown)

IF a User selects Forecast 2

Report should show Forecast 2 from Jan-Sep and Actual from Oct-Dec

IF a User selects Forecast 3

Report should show Forecast 3 from Apr-Sep and Actual from Oct-Mar

IF a User selects Forecast 4

Report should show Forecast 4 from Jul-Sep and Actual Oct-Jun

I can use a prompt to get the user input (for different forecasts), but the challenge was to show and hide Actual scenario and Forecast scenarios according to the user prompt.

I thought of making use of Advanced Suppress options and see whether that will work.

Here is the solution: http://www.orahyplabs.com/2011/04/dynamically-changing-fr-forecast-report.html#.UUAucNZJOSp