on 11-06-2015 9:09 AM
Hi,
I have run satatistical forecasting in IBP 4.0
However I am finding it challanging in IBP 5.0 . Not sure where to confure it. We have been able to copy SAP_IBP_PLANNER_APP into our roles and the tabs for statistical forecasting and supply planning are visible in the IBP excel ribbon
When we go to statistical forecast it shows us the following window:
We selected the time period as Monthly. Howevr we couldnt get anything in the "Forecast Model" selection pane. It was blank. Then we tried to run it. We got a message stating "Select a profile".
We are not sure where and how to select the profile in IBP 5.0.. Request your help.
Regards
Atri Kundu
Hi Atri,
Did you create any forecast model for your planning area? I assume there is no one available given that you are not able to select any from the excel drop down list <Forecast Model>.
Please follow these steps in order to define one:
Start Fiori Launchpad -> Manage Forecast Methods -> click Create button from the bottom right corner
After you select your planning area, you will have to input similar parameters as in IBP 4.0: historical and future periods, input and target KF, algorithm, coefficients.
If you would require further guidance in creating a forecast model, kindly check the application help:
Manage Forecast Models - SAP Integrated Business Planning - SAP Library
Regards
Alecsandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alecsandra,
Thanks ofr your inputs. Now I have been able to define the forecast models and also have assigned them.
I created a forecast model StatForecast1
Defined the preprocessing steps,
Substitute Missing Value: Input keyfigure " Actuals Qty" and Output Keyfigure "ActualsMissingVal"
Outlier Correction: Input key figure "Actuals Qty" and Output Keyfigure "Adjusted Actuals Qty"
Defined Forecasting Steps:
Overall Parameters: "Actuals Qty" is the input and "Statistical Fcst Qty" as "Target Keyfigure for Forecast" and "Target Key Figure for Ex-Post Forecast"
Single Exponential Smoothing: Save forecast in "STATFRCST1" and Save Expost forecast in "STATFORCST2"
Double Exponential Smoothing: Save forecast in "STATFRCST3" and Save Expost forecast in "STATFORCST4"
Defined Multiple Forecast "Choose Best Forecast" and "Measure Used for Forecast Comperison "MAD"
I saved all these as 1 forecast model. Now I can see the model. In "Simulate" button I can find StatForecast1 model under "StatisticaL Forecasting" . After selecting the relevant planning levels (ProductID and CsutomerID) I ran the model from "Simulate". I tried to populate the keyfigure "Statistical Fcst Qty" . However I am getting an error message "Error in refresh sheet". Not sure what is the problem. Can you please help?
Sorry for the long message.
Regards
Atri Kundu
Hi Atri,
I have seen this error only in connection with master data inconsistencies.
What I would test:
1. Run in simulate mode. If error pops up I would check the frontend log
C:\Users\xxx\AppData\Local\Temp\log
Check after last modified and open with a notepad++. If the error is related with data inconsistencies you might find some clues: e.g: invalid member
2. Run the forecasting model and use a filer limited to 1 combination. Check the status.
3. I would also try with a less sophisticated forecast model e.g - i would take out the pre-processing
If no success, i would raise an OSS.
Regards
Alecsandra
Hello Alecsandra,
I am kind of similar issue in IBP 5.0. I am not able to see the Stat forecasting in excel ribbon even though I have assigned the required Role SAP_IBP_PLANNER_APP". In IBP 5.0 when I tried to assign the Stat models to my planning area, while saving the configuration I am getting " Error while processing your query. You are not authorize to create a new forecast model"?
kindly suggest.
Thanks
Rahul Kumar
The standard roles have the object, but not the values assigned. It is not as in IBP4 that you have a kind of "SAP_ALL", but you need to copy the roles to Zxxxx and adjust the copied roles by assigning authorization for Planning AReas, forecast Model etc
That is valid for SAP_IBP_FMA_MAN_APP and SAP_IBP MFM_MAN_IBP
Same than normal roles in ECC system in transaction PFCG
Original Role:
Copied Role:
Yours
Irmi
Hi Rahul
I am the wrong person to provide answers on license questions, especially nothing that would be contractually or legally binding
PLease check out OSS message 2129867 yourself, especially the attachment
You will find for SOP to be included is Basic Statistic Forecast only "Statistically forecast using historical data with basic methods to consider baseline, trend and seasonality (moving average, and single, double and triple exponential smoothing)."
Included in Demand only is advanced methods ".... This includes pre-processing and post-processing steps."
And Outlier Correction belongs to the Preprocessing steps, so...
Yours
Irmi
Hi Irmi,
Could you please help me with a similar issue.
I have copied SAP_IBP_FMA_MAN_APP and SAP_IBP MFM_MAN_IBP roles and modified the authorizations, as a result I was able to create forecast profile for my planning area.
However, the Stat. Forecasting buttons are not visible on Excel Add-In (IBP 5.0). Do I need to modify authorizations for SAP_IBP_PLANNER_APP as well (IBP_Opertr is set as * currently) ?
Thanks,
Diwakar
You can log on and load data already, and just dont see the forecast operator?
Have you assigned the forecast operator to the planning area?
And yes you need the SAP_IBP_PLANNER_APP assigned.
I have heared that some people have issues if the operator IBP_OPERTR has the * assigned instead of having STAT_FCST assigned manually, but for me it works with *
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.