Skip to main content
Apr 12, 2017 9:31 AM UTC
Solved

Overview of current forecasting method

Hi,

Can I download/extract a table with the current forecasting method per material for a selected location?

Thx!

hkumarAnswer
Apr 12, 2017 11:12 AM UTC

In database you should use IPCS_SKU_STREAM table, which stores the final output for a pair-stream.

Also you can map the ProcID in IPCS_PROCESS_TABLE equal to the ForecastMethodID to find name of the method.

4 replies

Apr 12, 2017 10:15 AM UTC

Hi,

You can use 'Forecast Analysis' page to export information about a Part, Location, Stream and Forecast Method used in the stream.

1. If you set up the Filter Records by:

Part- null

Location - select the location

Forecast Stream - All

Filter - Not Filtered

Display Options - Value

2. Click on Play(Filter Records) icon on top tab. This will display all the pairs of that location and their streams with information about their Forecast Method.

3. Click on Export to Text File button next to Play icon, then click on attachment icon to download the file.

Regards,

Hemant

Apr 12, 2017 11:03 AM UTC

Hi Hemat,

Thx for the quick reply, but I was more looking for a solution to download it from the database directly as I want all materials to be able to do some analysis after a best fit run. (also, we are still on 9.3 so I guess not all the functionalities you describe above are available for us)

Anyhow I've found a table IPCS_FORECAST_SKUS_PARMS which could help me out I guess.

Here I have all the data, just still have to figure out how to convert the Forecast method ID (formatted as number) into text 🙂

Regards,

Elke

hkumarAnswer
Apr 12, 2017 11:12 AM UTC

In database you should use IPCS_SKU_STREAM table, which stores the final output for a pair-stream.

Also you can map the ProcID in IPCS_PROCESS_TABLE equal to the ForecastMethodID to find name of the method.