How You Aggregate Customer Data

Use the key customer data options collections template to identify key customers.

The data for these customers will be visible. For each Zone, all non-key customers' data will be aggregated to a member named All Other. By aggregating the planning data for non-key customers, you can focus your analysis on the key customers. You use the Supply Chain Planning Key Customer Options (ScpKeyCustomerOptionsImportTemplate.xlsm) import template to identify the key customers; the rest of the customers' data will be aggregated under an All Other member.

The data that are not identified in the upload template are aggregated to an all other member for each zone. You can view the key customers and the All Other member containing the aggregated non-key customer data when you analyze the forecasts and other data.

Identifying key customers and aggregating non-key customer data helps you to do the following:

  • Organize key customer data that are required for planning

  • Save time by collecting only the required data from Oracle Fusion Cloud Supply Chain Management

  • Build a plan specifically for your key customers