Skip to Content
1
Former Member
Jul 30, 2007 at 09:56 PM

Change actuals to forecast depending on month ?

28 Views

Hello BW Experts,

Scenario:

1) i have 12 columns in the report. Jan - Dec

2) If the report is run in Jun, it should show Jan to Jun actuals; July - Dec forecast data

if the report is run in sep, it should show jan to sep actuals; oct - dec forecast data

3) i have a cube1 for actuals; cube2 for forecast

4) i have to change the text of the column along with the data in the column.

challenges:

1) change the actuals or forecast in the text of the columns according to the month the report is run

2) change the actuals or forecast data in the columns according to the month the report is run.

How to do this Bex ? Any suggestions appreciated.

Regards,

BWer