Oracle® Retail Data Model Reference
Release 11.3.1
Part Number E20361-01

PDF · Mobi · ePub

List of Figures

2-1 Entity Types and Populating Oracle Retail Data Model Tables
6-1 Intra-ETL Main Process Flow
6-2 Intra-ETL Derived Process Flow
6-3 Intra-ETL Independent MV Process Flow
6-4 Intra-ETL Aggregate Process Flow
6-5 OLAP Map Process Flow
6-6 Mining Flow Process
10-1 Mining Model Components
12-1 Frequent Shopper Penetration Report
12-2 Frequent Shopper Sales Analysis
12-3 Frequent Shopper Transactions
12-4 RFM Scoring Report
12-5 RFMP Trending Report
12-6 Cluster Analysis
12-7 Frequency Defection
12-8 Promotional Planning
12-9 Promotion Comparison
12-10 Promotional Forecast Planning
12-11 Contribution by Promotion Event Type Store
12-12 Contribution Scorecard
12-13 Item Profit on Cost Report
12-14 Profit on net Cost Contribution Report
12-15 Cost Trend Report
12-16 Class Item Level Profit Contribution Report
12-17 Bottom Performance by Sales
12-18 Bottom 10 Performing Items by %Profit Report
12-19 Top Performer Report
12-20 Comp Sales and Inventory by Category Report
12-21 Organization Pricing Detail Report
12-22 Price Analysis Report
12-23 Category, Sales By Banner Report
12-24 Candidates for Delisting (Bottom 10% SV) Report
12-25 Cross Sell Profit Potential by Item Report
12-26 Vendor Sales by Channel Report
12-27 Gross Profit by Department Report
12-28 Sales, Profit and Returns by Channel (Local) Report
12-29 Sales, Profit and Returns by Channel (Local) Report
12-30 Item Sales and Profit by Product Cluster Report
12-31 Product Cluster Sales & Profit Report
12-32 Sales and Profit by Customer Cluster Report
12-33 Sales Profit and Returns by Location Trait Report
12-34 Product Price Elasticity Sales Prediction Batch Mode Report
12-35 Product Price Elasticity Dynamic Sales Prediction Report
12-36 Fast Moving Items Report
12-37 Product, Sales, Profit Value Against Last Year Report
12-38 Area Sales Contribution to Chain Report
12-39 Organization Sales and Profit
12-40 Organization, Department Sales & Stock Report
12-41 Sales, Profit and Return by Store Trait Report
12-42 Sales, Profit and Returns by Channel Report
12-43 Contract Detail by Item Report
12-44 Vendor Performance Report
12-45 Margin Contribution Top Performance
12-46 Vendor Product Summary Report
12-47 Performance Commitment Summary
12-48 Monthly Performance Trend Report
12-49 Pack Compared to Standalone Sales
12-50 Comp Sales and Inventory & Sales by Department Report
12-51 Product Sales & Return Report
12-52 Item, Profit Base Cost Contribution and net cost contribution Report
12-53 Sales Analysis Net Cost and Net Profit Report
12-54 Department Sales Report
12-55 Vendor Sales by Channel Report
12-56 Sales Scorecard Report
12-57 Store Sales Scorecard Report
12-58 Vendor Product Compliance Scorecard Report
12-59 Receipts by Vendor Report
12-60 Stock Movement: Stock Ledger
13-1 Salesperson Monthly Performance Report
13-2 Salesperson Ranking Summary Report
13-3 Salesperson Profit Summary Report
13-4 Cashier Weekly Performance Trend Report
13-5 Cashier Ranking Report
13-6 Salesperson Ranking Summary Report
13-7 Employee Sales and Returns Report
13-8 Cashier Transaction Summary Report
13-9 Sales Conversion Report
13-10 Sales Comparison Report
13-11 Store Traffic-Conversion Rate (Day) Report
13-12 Store Traffic-Conversion Rate (Week) Report
13-13 Store Traffic Communication Rate (Week) Report
13-14 Hourly Transaction Profile Report
13-15 Sales Productivity Scorecard Report
13-16 Location Sales Productivity Scorecard Report
13-17 Selling Location Productivity Scorecard Report
13-18 Till History Totals
13-19 Customer Transaction by Associates Report
13-20 Hourly Transaction Profile Report
13-21 Defection Monetary Report
13-22 Defection Profitability Report
13-23 Department Trending Shrink and Theft Report
13-24 Transaction by Tender Report
13-25 Statistical Emp Outlier Report
13-26 Statistical Store Outlier Report
13-27 Store Credits Reports
13-28 Stock Ledger Gross Margin Report
13-29 Adjustment Summary Report
13-30 Inventory Adjustment Report
13-31 Availability Analysis Report
13-32 Inventory & Receipts Report
13-33 Ending On Hand (EOH) Value Report
13-34 Sales Analysis Report
13-35 Sales Comparison Report
13-36 Contribution Report
13-37 Store Performance Report
13-38 Store Performance Ranking Report
13-39 Store Performance Scorecard Report
13-40 Employee Over/Short Report
13-41 Store Over/Short Report
13-42 Traffic Store Traffic Day Report
13-43 Store Traffic Week Report
13-44 Store Operation Transaction Report

Copyright © 2009, 2012, Oracle and/or its affiliates. All rights reserved.
Legal Notices