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