Show TOC

Function documentationWaterfall Analysis

 

You can use this function to run a waterfall analysis on customer forecasts and download the results to a Microsoft Excel table in a structured way. This enables you to display forecasts of different periods to see if there are deviations in the data, and thus helps you respond to these changes if necessary.

Features

  • The system exports a list of key figure values for various time stamps (according to the time horizon and granularity you specify).

  • Based on the key figure values, the Microsoft Excel file calculates total, minimum and maximum quantities.

Activities

  • You define the parameters for the analysis run on the Waterfall Analyis screen. You can access the screen in SAP NetWeaver Business Client under Start of the navigation path Customer Forecast Management Next navigation step Waterfall Analysis End of the navigation path or on the SAP Easy Access screen underStart of the navigation path  Advanced Planning and Optimization Next navigation step Demand Planning Next navigation step Planning Next navigation step Customer Forecast Management Next navigation step Waterfall Analysis End of the navigation path.

  • You specify the relevant location, product (or product group), key figures, and time horizon for the analysis, and you also define a granularity.

  • You specify the name of the Microsoft Excel file for exporting the results of the analysis and the path for saving the file.