Home › Discussions › Questions & Answers › Getting all horizontal with ASCP planning

Getting all horizontal with ASCP planning

Avatar photoCustomer Questions & Answers 7 replies

Our Oracle Advanced Supply Chain Planning (ASCP) team needs to frequently export complex, related data sets, such as detailed pegging paths and horizontal planning data, for in-depth Excel analysis that goes beyond what the Planner Workbench easily allows. How can Blitz Report provide ‘advanced functions’ for ASCP data extraction?

7 replies

  • Support Enginatics

    Blitz Report provides the capability to simplify reporting across critical planning areas, specifically addressing the extraction of complex data types like horizontal planning data and detailed pegging exports. By using customized SQL defined within Blitz Report, your planners can bypass the limitations and complexity of standard ASCP interfaces.

  • Is this simply replacing ASCP exception reports, or does it offer broader capabilities within the planning lifecycle?

  • Support Enginatics

    It offers broader support. While Blitz Report can effectively replace Oracle ASCP exception reporting , eliminating the tedious reliance on the Planner Workbench , its application in advanced areas like pegging and horizontal planning demonstrates its full data extraction potential. This allows for deep analysis into supply/demand linkages that standard reports struggle with.

  • Since this data is highly dynamic, how fast is the report execution time when querying these large planning tables?

  • Support Enginatics

    Report creation and execution are highly optimized, benefiting from Blitz Report’s reduced processing overhead. The philosophy is to execute proven SQL quickly and deliver the output instantly as native Excel. This ensures that your planners spend less time waiting and more time analyzing the most current horizontal plan or pegging results.

  • If we create a few critical ASCP reports, how do we easily share them with the entire global planning team?

  • Support Enginatics

    Once the custom SQL report is saved in Blitz Report, it can be assigned to the relevant user responsibilities. Users can then either run the report on demand or utilize the enhanced delivery options within the concurrent request mechanism to schedule reports and automatically distribute the resulting Excel files to the entire team via email or shared locations.

  • You must be logged in to reply to this post.