Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query to know the Forecast Summary- Combinations ignored, selected, forecasted

edited May 27, 2019 5:01PM in Supply Chain Planning and Collaboration 2 comments

Summary

SQL Query to know the Forecast Summary- Combinations ignored, selected, forecasted

Content

Hello,

 

When we run a Demand Plan and the engine process the history and forecast the output. How can we know the Forecast Summary

1) How many Combinations did the Engine -ignore ( How many dead combinations, young combinations)

2) How many Combinations did the Engine -Forecast at levels (Quality of the output-if we need to run different profiles)

3) Query to find the Forecast Method -Summary with the Qty of Items

Running a plan with Forecast Methods Options-switched on takes time and we need selected specific item--which is deep dive, but is it possible to also look at the macro picture with writing 2 SQL queries.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!