Oracle Demand Signal Repository User's Guide

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Introduction to Demand Signal Repository

Introduction
Business Intelligence Dashboard
Data
Measures
Goals and Thresholds
Reports and Scorecards
Multiple Hierarchies
Clusters
      Retail Clusters
      Store Clusters
      Item Clusters
Calendars
Data Allocation and Aggregation
Currencies

Data Model

Data Model Overview
Organization and Business Units
Customer Organization Hierarchy
Reference Data Load Process
Fact Data Load Process

Users and Security

User and Security Overview
User Roles

Dashboards and Scorecards

Category Sales Analysis Dashboard
Manufacturer Promotions Dashboard
Sales Performance by Account Dashboard
Scorecards
      Sales Scorecard
      Supply Chain Scorecard
      Operations Scorecard
Reports

Exceptions

Exceptions Overview
Exception Criteria
Exceptions Dashboard
Exceptions Setup
Processing Exceptions

Measures

Measures Overview
      Customer Shipments Measures
      Customer Shipments - Previous Period Measures
      Customer Shipments - Same Period Last Year Measures
      Customer Shipments - Same Period Last Year YTD Measures
      Customer Shipments - YTD Measures
      Organization Measures
      Point of Sale Measures
      Exceptions Measures
      Forecast Measures
      Forecast - Previous Period Measures
      Forecast - Same Period Last Year Measures
      Forecast - Same Period Last Year YTD Measures
      Forecast - YTD Measures
      Goals & Thresholds Measures
      Goals & Thresholds - YTD Measures
      Manufacturer Promotion Plan Measures
      Manufacturer Shipment Measures
      Manufacturer Shipments - Previous Period Measures
      Manufacturer Shipments - Same Period Last Year Measures
      Manufacturer Shipments - Same Period Last Year YTD Measures
      Organization Measures
      Point of Sale Measures
      Point of Sale - Previous Period Measures
      Point of Sale - Same Period Last Year Measures
      Point of Sale - Same Period Last Year YTD Measures
      Point of Sale - YTD Measures
      Promotion Plan Measures
      Replenishment Rules Measures
      Sales Inventory Measures
      Sales Inventory - Previous Period Measures
      Sales Inventory - Same Period Last Year Measures
      Sales Inventory - Same Period Last Year YTD Measures
      Sales Inventory - YTD Measures
      Store Orders Measures
      Store Orders - Previous Period Measures
      Store Orders - Same Period Last Year Measures
      Store Orders - Same Period Last Year YTD Measures
      Store Orders - YTD Measures
      Syndicated Consumption Data Measures
      External Measures
Loading Syndicated Consumption Measures
Setting Goals
Setting Thresholds

Working with Data

Data Overview
Hierarchy Loading
Alternate Organization Hierarchies
Time and Organization Allocations
Data Loading Interface Tables
Replenishment Rules
Materialized Views
User-Defined Fields
Forecast Types and Purpose Codes
Manufacturer Promotions
Enabling Third Party Distributors
Manufacturer Shipments

Implementing Demand Signal Repository

Implementation Overview
Setting Up Codes and Calendars
Loading Organizations and Hierarchies
Loading Items and Hierarchies
Importing Fact Data
Loading Syndicated Consumption Data
Implementing User-Defined Fields
Manufacturer Promotions
Third Party Distributors
Manufacturer Shipments
Alternate Organization Hierarchy

Demand Signal Repository Integration

Business Process Task Flow
Web Services
Loading TDLinx Store/Outlet Data
Enterprise Resource Planning to Demand Signal Repository Integration
Demand Signal Repository to Demantra Demand Management Integration
Demand Signal Repository to Retail Merchandising System Integration
      RMS Configuration Steps
      Attribute Mappings

Index