This chapter describes how Demantra integrates with Demand Signal Repository.
This chapter covers the following topics:
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).
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.
Here is a summary of the DSR procedures available within Demantra:
Import DSR data from the staging tables by running the DSR Sales Data Download workflow.
Create multiple forecasts by running the DSR POS Forecast Calculation workflow.
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 Withdrawals
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
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.
Log into the Workflow Manager.
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.
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.
Log into the Workflow Manager.
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.