Oracle Demantra Integration with Demand Signal Repository

Important: The Demantra Local Application replaces Collaborator Workbench. You may see both names in this text.

This chapter covers the following topics:

• Solution Overview
• Importing DSR Data into Demantra
• Running Multiple Forecasts

Solution Overview

The integration with DSR requires a number of new Levels, Series, Workflows, Profiles, and Worksheets (a full listing of these objects is provided in the section Objects for DSR Integration below).

Business Process

The DSR integration provides the following benefits:

• Synchronizes DSR data for item and geography.

• Provides a data extract from the DSR at the required level using Demantra's internal identifiers, e.g. Demantra's item and geography members at Demantra's lowest level.

• Provides a data extract from the DSR at the required level using manufacturer's internal identifiers, e.g. manufacturer's master data for item and geography at the lowest level.

• Provides a Demantra import integration profile and corresponding workflow for loading DSR output data into Demantra's internal tables.

Overview of Procedures

Here is a summary of the DSR procedures available within Demantra:

1. Import DSR data from the staging tables by running the DSR Sales Data Download workflow.

2. Create multiple forecasts by running the DSR POS Forecast Calculation workflow.

Objects for DSR Integration

The following objects are utilized in the Demantra integration with Demand Signal Repository. Detailed specifications for these objects are given at the end of this chapter.

Series

• Retailer POS Sales by Site

• Retailer POS Forecast

• Retailer DC WHSE Forecast

• Retailer Stores OnHand Total by Site

• Retailer Store Orders Total by Site

• Retailer DC WHSE OnHand

• Retailer DC WHSE Intransit

• POS Override

• Baseline POS Forecast

• POS Forecast Override

• Final POS Forecast

• POS Simulation

Series Groups

• DSR

Workflows

• DSR Sales Data Download

• DSR POS Forecast Calculation

Workflow Groups

• DSR

Engine Profiles

• DSR POS Forecast

• DSR POS Simulation

• DSR POS Forecast Calculation

Integration Profiles

• DSR Sales Import

Importing DSR Data into Demantra

Prerequisites

• Before running the DSR Sales Data Download workflow, data must already be exported from DSR into the Demantra staging tables. See the DSR Integration Guide for that procedure.

Running the DSR Sales Data Download workflow

For running a workflow see the Starting Workflow Instances section of the Managing Workflows chapter of the Demantra Implementation Guide.

1. Log into the Workflow Manager.

2. Locate the DSR Sales Data Download workflow in the table and click the corresponding Start button on that row. This starts a new workflow instance that transfers exported DSR data from the staging area into the Demantra production area of the database.

Running Multiple Forecasts

The DSR POS Forecast Calculation workflow runs the forecast engine using the DSR POS Forecast engine profile to generate multiple forecasts.

Running the DSR POS Forecast Calculation workflow

For running a workflow see the Starting Workflow Instances section of the Managing Workflows chapter of the Demantra Implementation Guide.

1. Log into the Workflow Manager.

2. Locate the DSR POS Forecast Calculation workflow in the table and click the corresponding Start button on that row. This starts a new workflow instance that generates multiple forecasts.