Show actual values before current month and forecast values after

[Former Member]

This is a tricky one (but I guess it will be easy for you clever guys out there), so my apologies for the heading.

Thanks for reading.

I need to build a report in BEx (BW3.5) that does the following:

I will get actual values and forecast values for a year, grouped per period.

But in the report, I don't want to display the actual and forecast values of every period.

I want to display the actual values for the past, and the forecast values for the future.

So, if we are now in period 6 (which is June) all the actual values must be displayed for Jan, Feb, Apr and May.

But from June onwards to December, only the forecast must be displayed for each month.

Is this possible?

Thanks in advance, points will be assigned

Rudolph

Edit: This might help. The actual value is based on KF 0AMOUNT, where value type = 10. The forecast is based on the same KF, value type = 20, version = F2

[Former Member · Accepted solution]

Hi Rudolph,

This is possible, you just need to create restricted key figures using fiscper or period/fiscal year. And use offset property. Create a customer exit variable which will derive current month and then use this for each columns with offset -1,-2.......

hope this helps. if need more details ...let me know...

Regards

Rajesh

[Former Member · Accepted solution]

I think this will work....

[Former Member]

Hi Rudolph,

No need to write any code for this one.

Have done couple of forecast reports using following logic.

Hope historical data getting from R/3 & Forecast values from APO.

these are seperate 2 keyfigures.

1.created restricted key figure (keyfigure1) for historical values & drag drop time characterstic with off set till date (means offset -6 to 0)

2.created restricted key figure (keyfigure2) for forecast values & drag drop time characterstic with off set till date (means offset +1 to +6).

create calculated keyfigure Add up above(keyfigure1+keyfigure2) two restricted keyfigure.

Thnx,

Vijay Reddy.

[Former Member]

Hi Rudolph,

if I fully got your requirements, you may think of creating a formula / calculated key figure with the following logic

a * (0AMOUNT restricted to value type 10) + b * (0AMOUNT restricted to value type 20)

where a and b are boolean expressions based on current month: figure out current month by variable and compare to month that is valid in row. Result of a has to be 1 if current month > month in row and 0 else, result of b has to be 0 if current month > month in row and 1 else.

Best regards,

Björn