Import Data at Aggregate Levels

(Doc ID 2385395.1)

Last updated on APRIL 11, 2018

Applies to:

Oracle Demand Management Cloud Service - Version 11.13.17.11.0 and later
Information in this document applies to any platform.

Goal

How can one load Initial Shipment History data, ongoing sales forecast, and customer forecast data at a level higher than the stored level?

Description:
Planning data load files are at the lowest ("stored") level (item/customer/day).
Business requires the ability to load data at higher levels,
such as product category*customer*month or item*customer*week etc.

Use Case:
Given this is new plant, initial seed data will be only at product category level and not item level
because this plant has no history yet.
Similarly, forecasts provided by customer will not be at a day level.

Business Benefit/Value:
During forecast analysis process,
need ability to review forecast inputs from customers and sales/marketing team before overriding statistical forecast.

Comments:
Work around - Build external program to explode data down from higher to lower levels before loading data into SaaS.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms