What parameters should be set to shorten the run time on Shipping & Booking Collection?
Currently using EBS/ASCP/Demantra version 12.2.4. Due to sheer data volume, the Shipping and Booking Collection (run weekly on Sunday evenings) is taking 8-9 hours to complete, and appears to be pulling data as far back as 6 months for shipments (equating to over 3/4 million records). This run time is negatively impacting the availability of the planning data to start each week. The settings currently used are default, out-of-the box for Shipping & Booking Collection.
- How much history is truly needed for Demantra to establish the anchor week?
- Is this history used for Demantra forecasting calculations and metrics?
If the Demantra forecasting engines are not being employed for our operations, and the previous forecasts are archived weekly as part of the update process, what would be the optimal settings to pull only the data needed to establish the Demantra anchor week for planning and where would those settings be changed in the ASCP Shipping & Booking collection?