Rolling 12 months Actuals/Forecast

[Former Member]

I remember coming across an SAP How To PDF showing how to create a query where user inputs a specific period/month and dynamically all periods before the selected period populate with actuals and an perios /months remaining in the year will display forecast. Again, this is dynamic depending on the period entered by the user and occurs on the same row.

Can someone send me the link if you have it handy or if you know a solution, please share.

[Former Member · Accepted solution]

<FONT FACE = "Tahoma", Font Color = "Blue">

Hi<br>

Let us assume you are storing the value of Fiscal Period entered by User in Variable ZPER. Also let us say you use characteristic Value Type to identify if data is Actuals or Forecast with Value Type 10 being Actuals and 20 being Forecast.<br>

Then create a Restricted Key Figure Actuals which is restricted to 3 things: Key Figure, Value Type and Fiscal Period. Restrict the Value Type to 10 and restrict Fiscal Period in that key figures to value less than or equal to Variable ZPER. Secondly create a Restricted Key Figure Forecast which is restricted to 3 things: Key Figure, Value Type and Fiscal Period. Restrict Value Type to 20 and restrict Fiscal Period in that key figures to value greater than Variable ZPER.<br>

Please check if you get desired results.

<br><br>

Hope it helps.<br><br>

Cheers Abhijit<br>

</FONT><FONT FACE = "Verdana", Font Color = "Red">

</FONT>

[Former Member · Accepted solution]

How do you restrict to "Less Than Or Equal To" and "Greater Than Or Equal To" on a characteristic variable?

Less than or Equal to can only be done at runtime....right?

[former_member188975 · Accepted solution]

Hi Mike,

In the when youright click to restrict a variable, in the pop-up, select a variable and in the dropdown box (left) choose Value Range, then in the right hand side drop down you can choose greater than, less than etc.

Hope this helps...

[Former Member]

Whatever time char you use, use variable offset of +1 for going forward ( for forecast) and -1 for backwards ( for actuals).

Ravi Thothadri

[Former Member]

Yes, I found how to do less than and greater than, however its appears you cannot do greater or less than on a variable (i.e. ZPER). You can only do it on a hard code period value. FOr example, hard coded Less than Period 1 and not Less than Period X (entered by user).

Any Ideas?

[former_member188975]

Hi Mike,

If you followed the steps I gave above, you can see that this is possible to do even with a variable.

Hope this helps...

[Former Member]

Ok, I got it to work...by default, my variables do not display when selecting Value Range (2004s SP12, Patch 1, Revision 449). I had to go to History dropdown to find one variable and select it. Once I did that, the next time I get the popup, variables in an option. This is so weird. I recorded my steps and played it back from the initial attempt and it works....now variables are displayed when returning to the selection screen, although it did not before.

Finally, now that it is finished and created as described, BEx analyzer throws error:

The characteristic 0P_PER3 for InfoObject 0FISCPER3 is not numerical.

Program error in class SAPMSSY1 method: UNCAUGHT_EXCEPTION.

[Former Member]

Did some troubleshooting and figured out there are some problems with my front end installation.

Solution works as I had hoped!

Points given to all those who helped. Thanks.

[Former Member]

I am getting exact similar error as you mentioned in your earlier note. What kind of troubleshooting you did to fix your error. I am currently on SPS 10 and SAP GUI 7.1.

Also do you know whether SPS greater than 10 is available?

Regards,

Sachin