| Oracle® Retail Data Model Reference Release 11.3.1 Part Number E20361-01 |
|
|
PDF · Mobi · ePub |
| Oracle® Retail Data Model Reference Release 11.3.1 Part Number E20361-01 |
|
|
PDF · Mobi · ePub |
This chapter provides Oracle Retail Data Model sample reports.
This chapter includes the following sections:
The customer reports include the following:
Figure 12-1 shows frequent shopper transaction as percent of total transactions (time series analysis).
Report dimensions are:
Business Time
Organization
Figure 12-1 Frequent Shopper Penetration Report
Figure 12-2 shows how much the frequent shoppers contribute to total sales (by item-class).
Report dimensions are:
Business Time
Product
Figure 12-2 Frequent Shopper Sales Analysis
Figure 12-3 provides frequent shopper transactions.
Report dimensions are:
Business Time
Organization
Figure 12-3 Frequent Shopper Transactions
Figure 12-4 provides RFMP groupings statistics over time.
Report dimensions are:
Business Time
Customer
This report, as shown in Figure 12-5 provides month to month RFMP group migration.
Report dimensions are:
Business Time
Customer
This report, as shown in Figure 12-6 provides sales and time information by customer cluster and product cluster.
Report dimensions are:
Business Time
Customer
Product
Figure 12-7 provides customer information for those at risk of defection based on frequency segment. The end user can view a list of frequency detection value and frequency segment of customers.
Report dimensions are:
Business Time
Customer
The promotion reports include the following:
Figure 12-9 provides response rate information for customers in the target group, all of whom received promotion, by frequency segment.
Report dimensions are:
Promotion
Figure 12-10 provides response rate information for customers in the target group, all of whom received promotion, by frequency segment.
Report dimensions are:
Promotion
Figure 12-10 Promotional Forecast Planning
Figure 12-11 provides response rate information for customers in the target group, all of whom received promotion, by frequency segment.
Report dimensions are:
Promotion
Figure 12-11 Contribution by Promotion Event Type Store
The category reports include the following areas:
This report, as shown in Figure 12-12 provides sales contribution information based on department. The end user can compare last year compared to current year scorecard sales contribution for each department, class and subclass.
Report dimensions are:
Business Time
Product
This report, as shown in Figure 12-13 provides item percent profit on base cost and net cost to department information. The end user can compare the %Contribution Profit on Base Cost and Net Cost of a department with last year's metrics.
Report dimensions are:
Business Time
Product
Figure 12-14 provides item percent profit on net cost information for each in a department. The end user can compare the %Profit Contribution on Net Cost for stores in a department with last year's metrics.
Report dimensions are:
Business Time
Product
Organization
Figure 12-14 Profit on net Cost Contribution Report
Figure 12-15 provides information on item to category sales and market sales contribution. The end user can see a list of %base cost, net cost, net-net cost and dead net cost for each item.
Report dimensions are:
Business Time
Product
Organization
Vendor
Figure 12-16 provides class-wise item level profit information. The end user can compare the %Profit on Net Cost, %Profit on Net-Net Cost and %Profit on Dead Net Cost for item in a class with last year's metrics.
Report dimensions are:
Business Time
Product
Figure 12-16 Class Item Level Profit Contribution Report
Figure 12-17 provides "Bottom 10 Performing Items By Sales Amount information for each year. The end user can compare EOH and BOH retail value and %Profit Amount for items with last year's metrics.
Report dimensions are:
Business Time
Product
Figure 12-18 provides "Bottom 10 Performing Items By % Profit" information for each year. The end user can compare EOH and BOH retail value and %Profit Amount for items with last year's metrics.
Report dimensions are:
Business Time
Product
Figure 12-18 Bottom 10 Performing Items by %Profit Report
Figure 12-19 provides list of the top ten items based on sales. The information enables effective assortment efficiency and product positioning initiatives. The end user can compare the performer with last year's metrics such as: Sales Value, Sales Value LY, %Chg Sales Value Vs LY, Profit Amt, Profit Amt, Profit LY, %Contrib. Sales Value to Category, % Chg Profit Vs LY, %Contrib. Profit to Category.
Report dimensions are:
Business Time
Product
Figure 12-20 provides Comparable Sales, Profit, and Inventory analysis grouped by category. The end user can compare the comp sales and inventory with last year's metrics such as: Sales Value, Sales Value LY, %Chg Sales Value Vs LY, Comp Sales Value, comp Base Sales Value, %Change Comp Sales Value Vs Comp Sales, Profit Amt, Profit LY, % Chg Profit Vs LY, Comp Profit, Comp Base Profit,EOH Retail Val, EOH Retail Val LY, %Chg Retail Val vs LY, Comp EOH Retail Val, Comp Base EOH Retail Val, Receipts Retail Val, %Chg Receipt Retail Val vs LY.
Report dimensions are:
Business Time
Product
Figure 12-20 Comp Sales and Inventory by Category Report
Figure 12-21 provides pricing information based on sales, price and inventory measures, by organization.
Report dimensions are:
Business Time
Organization
Figure 12-21 Organization Pricing Detail Report
Figure 12-22 provides price analysis information. The report enables comparison of product pricing for stores and items.
Report dimensions are:
Business Time
Product
Figure 12-23 provides sales value organized by category and banner. The end user can compare the department, sales value and organization banner with last year's metrics.
Report dimensions are:
Business Time
Product
Organization
Figure 12-23 Category, Sales By Banner Report
Figure 12-24 provides list of the bottom ten percent of items per category a retailer carries, based on sales value.
The end user can view a list of category-wise items, EOH units, no of days with stocks, sales value, sales value LY, %chg sales value compared to LY, % contrib. sales value to department, percent contrib. profit amt to department, profit amt, profit LY, %chg profit against LY, % contrib. profit amt department for a given year.
Report dimensions are:
Business Time
Product
Organization
Figure 12-24 Candidates for Delisting (Bottom 10% SV) Report
This report, as shown in Figure 12-25 provides potential of items that have affinity to the customer selected.
Report dimensions are:
Business Time
Product
Figure 12-25 Cross Sell Profit Potential by Item Report
This report, as shown in Figure 12-26 provides vendor sales by channel information. The end user can compare vendor sales value for each channel type with last year's metrics.
Report dimensions are:
Business Time
Vendor
Channel Type
Figure 12-26 Vendor Sales by Channel Report
This report, as shown in Figure 12-27, provides "gross profit by department" information. The end user can compare the current year to the previous year profit on net-net cost measures at the item department level.
Report dimensions are:
Business Time
Product
Figure 12-27 Gross Profit by Department Report
This report, as shown in Figure 12-28 provides sales, profit and returns information by channel. The end user can compare sales value, profit, %profit, return value for channel type and stores with last year's metrics.
Report dimensions are:
Business Time
Channel Type
Organization
Figure 12-28 Sales, Profit and Returns by Channel (Local) Report
This report, as shown in Figure 12-29 provides sales, profit, and returns information by channel in local currency. The end user can compare sales value, profit amt, and return value, % profit amt for channel types with last year's metrics.
Report dimensions are:
Business Time
Channel Type
Figure 12-29 Sales, Profit and Returns by Channel (Local) Report
This report, as shown in Figure 12-30 provides sales and profit information by product cluster. The end user can view a list of sales value, profit amt, %profit amt for items in a product cluster.
Report dimensions are:
Business Time
Product
Figure 12-30 Item Sales and Profit by Product Cluster Report
This report, as shown in Figure 12-31 provides sales and profit information by product cluster. The end user can view a list of sales value, profit amt, %profit amt for items in a product cluster.
Report dimensions are:
Business Time
Product
Figure 12-31 Product Cluster Sales & Profit Report
This report, as shown in Figure 12-32 provides sales and profit information by customer cluster and customer spending habits. The end user can compare sales value, profit amt and %profit amt for each customer cluster with last year's metrics.
Report dimensions are:
Business Time
Customer
Figure 12-32 Sales and Profit by Customer Cluster Report
This report, as shown in Figure 12-33 provides sales, profit and returns information based on location trait. The end user can compare current year against last year sales value, profit amount, return value, %profit amt for the store types.
Report dimensions are:
Business Time
Organization
Figure 12-33 Sales Profit and Returns by Location Trait Report
This report, as shown in Figure 12-34 provides sales prediction.
Report dimensions are:
Product
Organization
Business Time
Figure 12-34 Product Price Elasticity Sales Prediction Batch Mode Report
This report, as shown in Figure 12-35 provides dynamic sales prediction.
Report dimensions are:
Product
Organization
Business Time
Figure 12-35 Product Price Elasticity Dynamic Sales Prediction Report
The merchandise reports include the following:
This report, as shown Figure 12-36 provides the year week-level "Fast Moving Items" information for each Store which can be compared with last year's metrics such as "Sales Units", "CP Sales Units", or "% Increase in Sales to Planned".
Report dimensions are:
Business Time
Product
Organization
This report, as shown in Figure 12-37 provides sales and profit information compared to last year, by product.
Report dimensions are:
Business Time
Product
Figure 12-37 Product, Sales, Profit Value Against Last Year Report
This report, as shown in Figure 12-38 provides area contribution to sales value for a chain.
Report dimensions are:
Business Time
Organization
Figure 12-38 Area Sales Contribution to Chain Report
This report, as shown in Figure 12-39 provides sales, inventory and variance measures chain Manager and department.
Report dimensions are:
Business Time
Organization
Figure 12-39 Organization Sales and Profit
This report, as shown in Figure 12-40 provides sales, inventory and variance measures chain Manager and department.
Report dimensions are:
Business Time
Organization
Product
Figure 12-40 Organization, Department Sales & Stock Report
This report, as shown in Figure 12-41 provides sales, profit and return information based on store trait.
Report dimensions are:
Business Time
Organization
Figure 12-41 Sales, Profit and Return by Store Trait Report
This report, as shown in Figure 12-42 provides sales, profit and return information by channel.
Report dimensions are:
Business Time
Organization
Figure 12-42 Sales, Profit and Returns by Channel Report
This report, as shown in Figure 12-43 contract detail by item. performance.
Report dimensions are:
Business Time
Product
Contract
Figure 12-43 Contract Detail by Item Report
This report, as shown in Figure 12-44 provides comparison for all supplier compliance and rating measure for current year compared to last year.
Report dimensions are:
Business Time
Vendor
Product
This report, as shown in Figure 12-45 provides the information about the top performance by vendors in delivery accuracy & timeliness.
Report dimensions are:
Business Time
Vendor
Figure 12-45 Margin Contribution Top Performance
This report, as shown in Figure 12-46 provides unit sales, inventory and return measures by supplier, item and vendor product number.
Report dimensions are:
Business Time
Vendor
Product
Figure 12-46 Vendor Product Summary Report
This report, as shown in Figure 12-47 provides commitment summary.
Report dimensions are:
Business Time
Vendor
Department
Figure 12-47 Performance Commitment Summary
This report, as shown in Figure 12-48 provides monthly store performance information based on transaction sales and profit measures compared to last year and plan.
Report dimensions are:
Business Time
Organization
Figure 12-48 Monthly Performance Trend Report
This report, as shown in Figure 12-49 compares and provides the yearly sales information of packed items with standalone items.
Report dimensions are:
Business Time
Product
Figure 12-49 Pack Compared to Standalone Sales
This report, as shown in Figure 12-50 provides the comparable sales, profit and inventory analysis group by department.
Report dimensions are:
Business Time
Product
Figure 12-50 Comp Sales and Inventory & Sales by Department Report
This report, as shown in Figure 12-51 provides sales, return and profit by product.
Report dimensions are:
Business Time
Product
Figure 12-51 Product Sales & Return Report
This report, as shown in Figure 12-52 provides the item profit of net cost contribution and base cost contribution.
Report dimensions are:
Business Time
Product
Figure 12-52 Item, Profit Base Cost Contribution and net cost contribution Report
This report, as shown in Figure 12-53 provides yearly, monthly net sales and profit details for each vendor, item.
Report dimensions are:
Business Time
Organization
Product
Vendor
Figure 12-53 Sales Analysis Net Cost and Net Profit Report
This report, as shown in Figure 12-54 provides sales value organized by department and banner. This report allows analysis of banner sales by department.
Report dimensions are:
Business Time
Product
This report, as shown in Figure 12-55 provides the sales value by different channel like distribution and selling.
Report dimensions are:
Business Time
Product
Figure 12-55 Vendor Sales by Channel Report
This report, as shown in Figure 12-57 provides.
Report dimensions are:
Business Time
Product
Organization
This report, as shown in Figure 12-57 provides (by store) department sales quantity, value and variance information compared to last year.
Report dimensions are:
Business Time
Product
Organization
Figure 12-57 Store Sales Scorecard Report
This report, as shown in Figure 12-58 provides (by vendor) department quality rating, sales value, margin and rebate.
Report dimensions are:
Business Time
Product
Vendor
Figure 12-58 Vendor Product Compliance Scorecard Report
This report, as shown in Figure 12-59 provides "receipts by vendor" information such as items, stores, business date, business week day and receipt units listed by business year for a vendor.
Report dimensions are:
Business Time
Vendor
Organization
This report, as shown in Figure 12-60 provides "Product, Stock Ledger Gross Margin" and Product, Stock Ledger Sales and Inventory information.
Report dimensions are:
Business Time
Organization
Figure 12-60 Stock Movement: Stock Ledger
|
 Copyright © 2009, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
