Skip Headers
Oracle® Retail Data Model Reference
Release 11.3.2

Part Number E20361-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

13 Oracle Retail Data Model Sample Reports Continued

This chapter provides additional Oracle Retail Data Model sample reports.

This chapter includes the following sections:

Workforce Reports

Workforce includes the following areas:

Performance

Ranking includes the Salesperson Performance, Salesperson Ranking, Salesperson Profit, and Cashier.

Salesperson Performance

This report, as shown in Figure 13-1 provides monthly performance of sales person using sales measures. The report is used to identify the most or least productive salesperson.

Report dimensions are:

  • Business Time

  • Organization

  • Salesperson

Figure 13-1 Salesperson Monthly Performance Report

Description of Figure 13-1 follows
Description of "Figure 13-1 Salesperson Monthly Performance Report"

Salesperson Ranking

This report, as shown in Figure 13-2 provides salesperson ranking information based on the top sales value for each location. The report is used to identify the most or least productive salesperson in a particular location.

Report dimensions are:

  • Business Time

  • Organization

  • Salesperson

Figure 13-2 Salesperson Ranking Report

Description of Figure 13-2 follows
Description of "Figure 13-2 Salesperson Ranking Report"

Salesperson Profit

This report, as shown in Figure 13-3 provides salesperson productivity record, based on transaction and profit measures over time.

The report is used to identify the most or least profitable salesperson.

Report dimensions are:

  • Business Time

  • Organization

  • Salesperson

Figure 13-3 Salesperson Profit Report

Description of Figure 13-3 follows
Description of "Figure 13-3 Salesperson Profit Report"

Cashier

This report, as shown in Figure 13-4 provides contribution of cashiers to all cashiers. The report is used to identify the most or least productive cashiers.

Report dimensions are:

  • Business Time

  • Organization

  • Cashier

Figure 13-4 Workforce Performance Cashier Report

Description of Figure 13-4 follows
Description of "Figure 13-4 Workforce Performance Cashier Report"

Ranking

Ranking includes the Cashier Ranking and Salesperson Ranking.

Cashier Ranking

This report, as shown in Figure 13-5 provides cashier ranking information based on the top sales value for each location. The report is used to identify the most or least productive cashiers in a particular location.

Report dimensions are:

  • Business Time

  • Organization

  • Cashier

Figure 13-5 Workforce Ranking Cashier Ranking Report

Description of Figure 13-5 follows
Description of "Figure 13-5 Workforce Ranking Cashier Ranking Report"

Salesperson Ranking

This report, as shown in Figure 13-6 provides salesperson ranking information based on the top sales value for each location. The report is used to identify the most or least productive cashiers in a particular location.

Report dimensions are:

  • Business Time

  • Organization

  • Salesperson

Figure 13-6 Workforce Salesperson Ranking Report

Description of Figure 13-6 follows
Description of "Figure 13-6 Workforce Salesperson Ranking Report"

Transactions

Transactions includes the Employees Sales and Returns and Cashier Transaction Summary.

Employees Sales and Returns

This report, as shown in Figure 13-7 provides sales and return measures by location and employee.

Report dimensions are:

  • Business Time

  • Organization

  • Cashier

Figure 13-7 Employee Sales and Returns Report

Description of Figure 13-7 follows
Description of "Figure 13-7 Employee Sales and Returns Report"

Cashier Transaction Summary

This report, as shown in Figure 13-8 provides cashier productivity information based on sales measures and transaction activity over time. The report is used to identify the most or least productive cashiers.

Report dimensions are:

  • Business Time

  • Organization

  • Cashier

Figure 13-8 Cashier Transaction Summary Report

Description of Figure 13-8 follows
Description of "Figure 13-8 Cashier Transaction Summary Report"

Employee Analysis

Employee analysis includes the Employee Basket DT Profile, Employee Basket Factor Rank, Employee Basket Prediction, Employee Sales DT Profile, Employee Sales Factor Rank, Employee Sales Prediction and Employee Combination DT Profile reports.

Employee Basket DT Profile

This report, as shown in Figure 13-9 provides Employee Basket Analysis with DT rules.

Report dimensions are:

  • Business Time

  • Organization

  • Cashier

Figure 13-9 Workforce Employee Basket DT Profile

Description of Figure 13-9 follows
Description of "Figure 13-9 Workforce Employee Basket DT Profile"

Employee Basket Factor Rank

This report, as shown in Figure 13-10 provides Employee Basket Analysis Ranking with SVM Factors.

Report dimensions are:

  • Business Time

  • Organization

  • Cashier

Figure 13-10 Employee Basket Factor Rank Report

Description of Figure 13-10 follows
Description of "Figure 13-10 Employee Basket Factor Rank Report"

Employee Basket Prediction

This report, as shown in Figure 13-11 provides employee basket prediction.

Report dimensions are:

  • Business Time

  • Organization

  • Cashier

Figure 13-11 Employee Basket Prediction Report

Description of Figure 13-11 follows
Description of "Figure 13-11 Employee Basket Prediction Report"

Employee Sales DT Profile

This report, as shown in Figure 13-12 provides Employee Sales Analysis.

Report dimensions are:

  • Business Time

  • Organization

  • Cashier

Figure 13-12 Employee Sales DT Profile Report

Description of Figure 13-12 follows
Description of "Figure 13-12 Employee Sales DT Profile Report"

Employee Sales Factor Rank

This report, as shown in Figure 13-13 provides Employee Sales ranking.

Report dimensions are:

  • Business Time

  • Organization

  • Cashier

Figure 13-13 Employee Sales Factor Rank Report

Description of Figure 13-13 follows
Description of "Figure 13-13 Employee Sales Factor Rank Report"

Employee Sales Prediction

This report, as shown in Figure 13-14 provides Employee Sales perdition.

Report dimensions are:

  • Business Time

  • Organization

  • Cashier

Figure 13-14 Employee Sales Prediction Report

Description of Figure 13-14 follows
Description of "Figure 13-14 Employee Sales Prediction Report"

Employee Combination DT Profile

This report, as shown in Figure 13-15 provides Employee Sales to identify combination of employees which is likely to perform better at a store on a shift.

Report dimensions are:

  • Business Time

  • Organization

  • Cashier

Figure 13-15 Employee Combination DT Profile

Description of Figure 13-15 follows
Description of "Figure 13-15 Employee Combination DT Profile"

Point of Service Reports

The points of service reports include the following areas:

Conversion

Conversion includes the Sales Conversion, Sales Comparison, Store Traffic Day and Store Traffic Week reports.

Sales Conversion

This report, as shown in Figure 13-16 provides the purchase rate per visit for store by year, Quarter, and Month.

Report dimensions are:

  • Business Time

  • Organization

Figure 13-16 Point of Sale Sales Conversion

Description of Figure 13-16 follows
Description of "Figure 13-16 Point of Sale Sales Conversion"

Sales Comparison

This report, as shown in Figure 13-17 provides the yearly or quarterly moving of sales for various stores.

Report dimensions are:

  • Business Time

  • Organization

Figure 13-17 Point of Service Sales Comparison

Description of Figure 13-17 follows
Description of "Figure 13-17 Point of Service Sales Comparison"

Store Traffic Day

This report, as shown in Figure 13-18 provides the Daily transaction activity based on store traffic measure for one or more division.

Report dimensions are:

  • Business Time

  • Organization

Figure 13-18 Point of Sale Store Traffic Day

Description of Figure 13-18 follows
Description of "Figure 13-18 Point of Sale Store Traffic Day"

Store Traffic Week

This report, as shown in Figure 13-19 provides the weekly transaction activity based on store traffic measure for one or more division.

Report dimensions are:

  • Business Time

  • Organization

Figure 13-19 Store Traffic-Conversion Rate (Week) Report

Description of Figure 13-19 follows
Description of "Figure 13-19 Store Traffic-Conversion Rate (Week) Report"

Entry Methods

Entry methods includes the Entry Methods (Column Total), and Entry Methods (Row Total) reports.

Entry Methods (Column Total)

This report, as shown in Figure 13-20 provides the (by employee) entry method analysis at detail level transaction.

Report dimensions are:

  • Business Time

  • Organization

  • Employee

  • Entry Method

Figure 13-20 Point of Sale Associate Entry Method (Column Total)

Description of Figure 13-20 follows
Description of "Figure 13-20 Point of Sale Associate Entry Method (Column Total)"

Entry Methods (Row Total)

This report, as shown in Figure 13-21 provides the (by employee) entry method analysis at detail level transaction.

Report dimensions are:

  • Business Time

  • Organization

  • Employee

  • Entry Method

Figure 13-21 Point of Service Associate Entry Method (Row Total) Report

Description of Figure 13-21 follows
Description of "Figure 13-21 Point of Service Associate Entry Method (Row Total) Report"

Flow Analysis

Flow analysis includes the Store Traffic, Sales Trend Transaction Count, Sales Trend, and Transaction Profile reports.

Store Traffic

This report, as shown in Figure 13-22 provides the weekly transaction activity information based on store traffic measure for one or more stores.

Report dimensions are:

  • Business Time

  • Organization

Figure 13-22 Point of Service Flow Analysis Store Traffic Report

Description of Figure 13-22 follows
Description of "Figure 13-22 Point of Service Flow Analysis Store Traffic Report"

Sales Trend Transaction Count

This report, as shown in Figure 13-23 provides the total number of sales transactions processed hourly. The report is used to identify the most or least productivity store.

Report dimensions are:

  • Business Time

  • Organization

Figure 13-23 Hourly Sales Trend Transactions Count Report

Description of Figure 13-23 follows
Description of "Figure 13-23 Hourly Sales Trend Transactions Count Report"

Sales Trend

This report, as shown in Figure 13-24 provides the hourly net sales amount and % contribution sales unit based on one or more stores.

Report dimensions are:

  • Business Time

  • Organization

Transaction Profile

This report, as shown in Figure 13-25 provides hourly store traffic information based on no of sales transaction activity at a store.

Report dimensions are:

  • Business Time

  • Organization

  • Time of Day

Figure 13-25 Hourly Transaction Profile

Description of Figure 13-25 follows
Description of "Figure 13-25 Hourly Transaction Profile"

Scorecard

Scorecard area includes the following reports: Sales Productivity, Location Sales Productivity and Selling Location Productivity.

Sales Productivity

This report, as shown in Figure 13-26 provides the total number of transaction sales units sold hourly, at a location. This report can also identify the most or least productive location.

Report dimensions are:

  • Business Time

  • Organization

Figure 13-26 Sales Productivity Scorecard Report

Description of Figure 13-26 follows
Description of "Figure 13-26 Sales Productivity Scorecard Report"

Location Sales Productivity

This report, as shown in Figure 13-27 provides by store, hourly sales details based on sales measures.

Report dimensions are:

  • Business Time

  • Organization

  • Time of Day

Figure 13-27 Location Sales Productivity Scorecard Report

Description of Figure 13-27 follows
Description of "Figure 13-27 Location Sales Productivity Scorecard Report"

Selling Location Productivity

This report, as shown in Figure 13-28 provides business unit productivity information based on sales measures for one or more locations by register and hours.

Report dimensions are:

  • Business Time

  • Organization

  • Time of Day

Figure 13-28 Selling Location Productivity Report

Description of Figure 13-28 follows
Description of "Figure 13-28 Selling Location Productivity Report"

Till Analysis

This report, as shown in Figure 13-29 provides various sales audit total values by store, day and week.

Report dimensions are:

  • Business Time

  • Organization

  • Till Tender

Figure 13-29 Till History Totals Report

Description of Figure 13-29 follows
Description of "Figure 13-29 Till History Totals Report"

Transactions

Transactions area includes the following reports: Transaction by Associates, Transaction Profile, Store and Transaction Types, and Loss Prevention Transactions.

Transaction by Associates

This report, as shown in Figure 13-30 provides the summary of customer transactions and identifying exceptional number of transactions between an associate and customer for a particular store.

Report dimensions are:

  • Business Time

  • Organization

  • Employee

  • Customer

Figure 13-30 Customer Transactions by Associate Report

Description of Figure 13-30 follows
Description of "Figure 13-30 Customer Transactions by Associate Report"

Transaction Profile

This report, as shown in Figure 13-31 provides hourly store traffic information based on of sales transaction.

Report dimensions are:

  • Business Time

  • Organization

  • Time of Day

Figure 13-31 Hourly Transaction Profile Report

Description of Figure 13-31 follows
Description of "Figure 13-31 Hourly Transaction Profile Report"

Store and Transaction Types

This report, as shown in Figure 13-32 provides (by store) transaction detail on different transaction types.

Report dimensions are:

  • Business Time

  • Organization

Figure 13-32 Retail Transaction Type by Store Report

Description of Figure 13-32 follows
Description of "Figure 13-32 Retail Transaction Type by Store Report"

Loss Prevention Transactions

This report, as shown in Figure 13-33 provides the reduction in inventory (due to damage, spoilage and so forth).

Report dimensions are:

  • Business Time

  • Organization

  • Tender Trend

Figure 13-33 Loss Prevention Transactions Report

Description of Figure 13-33 follows
Description of "Figure 13-33 Loss Prevention Transactions Report"

Loss Prevention Reports

The Loss Prevention reports include the following areas:

Defection

Defection area includes the following reports: Monetary and Profitability.

Monetary

This report, as shown in Figure 13-34 provides the year level "Customer Monetary Defection Analysis" information for each customer.

Report dimensions are:

  • Business Time

  • Customer

Figure 13-34 Defection Monetary Report

Description of Figure 13-34 follows
Description of "Figure 13-34 Defection Monetary Report"

Profitability

This report, as shown in Figure 13-35 provides the year level "Customer Profitability Defection Analysis" information for each customer.

Report dimensions are:

  • Business Time

  • Customer

Figure 13-35 Defection Profitability Report

Description of Figure 13-35 follows
Description of "Figure 13-35 Defection Profitability Report"

Shrink and Theft

Shrink and Theft area includes the following reports: Category Trending, and Transaction by Tender.

Category Trending

This report, as shown in Figure 13-36 provides product department trending information.

Report dimensions are:

  • Business Time

  • Organization

  • Product

Figure 13-36 Category Trending Shrink and Theft Report

Description of Figure 13-36 follows
Description of "Figure 13-36 Category Trending Shrink and Theft Report"

Transaction by Tender

This report, as shown in Figure 13-37 provides the month level "Transaction" information for each organization division, store and tender.

Report dimensions are:

  • Business Time

  • Organization

  • Tender

Figure 13-37 Transaction by Tender Report

Description of Figure 13-37 follows
Description of "Figure 13-37 Transaction by Tender Report"

Customer Transaction

This report, as shown in Figure 13-38 provides the summary of customer transaction and identifying exceptional numbers of transactions between an associate and customer for a particular store.

Report dimensions are:

  • Business Time

  • Organization

  • Employee

  • Customer

Figure 13-38 Customer Transactions by Associate Report

Description of Figure 13-38 follows
Description of "Figure 13-38 Customer Transactions by Associate Report"

Associate Tendering

This report, as shown in Figure 13-39 provides the quarter level "Associate Tendering" information for each organization division, store and employee.

Report dimensions are:

  • Business Time

  • Organization

  • Employee

Figure 13-39 Associate Tendering Report

Description of Figure 13-39 follows
Description of "Figure 13-39 Associate Tendering Report"

Statistical Outliers

Statistical Outliers area includes the following reports: Statistical Emp Outlier and Statistical Store Outlier.

Statistical Emp Outlier

This report, as shown in Figure 13-40 provides the month and quarter level "Associate Statistical Outlier" information for each organization store, employee, and tender.

Report dimensions are:

  • Business Time

  • Organization

  • Tender

  • Employee

Figure 13-40 Statistical Emp Outlier Report

Description of Figure 13-40 follows
Description of "Figure 13-40 Statistical Emp Outlier Report"

Statistical Store Outlier

This report, as shown in Figure 13-41 provides the "Statistical Outlier" information for each organization, store, and tender.

Report dimensions are:

  • Organization

  • Tender

Figure 13-41 Statistical Store Outlier Report

Description of Figure 13-41 follows
Description of "Figure 13-41 Statistical Store Outlier Report"

Store Credits

Store Credits area includes the following report: Store Credits.

Store Credits

This report, as shown in Figure 13-42 provides the yearly, monthly, quarterly and weekly "Store Credit" information.

Figure 13-42 Store Credits Reports

Description of Figure 13-42 follows
Description of "Figure 13-42 Store Credits Reports"

Inventory Reports

The Inventory reports include the following areas:

Accounting

Accounting area includes the following reports: Stock Ledger Gross Margin, Adjustments Summary, Inventory Adjustment (Detail), and Availability Analysis.

Stock Ledger Gross Margin

This report, as shown in Figure 13-43 provides the product and stock ledger gross margin report.

Report dimensions are:

  • Business Time

  • Organization

Figure 13-43 Stock Ledger Gross Margin Report

Description of Figure 13-43 follows
Description of "Figure 13-43 Stock Ledger Gross Margin Report"

Adjustments Summary

This report, as shown in Figure 13-44 provides yearly, monthly "Adjustment Summary" information for each item department and item.

Report dimensions are:

  • Business Time

  • Product

Figure 13-44 Adjustments Summary

Description of Figure 13-44 follows
Description of "Figure 13-44 Adjustments Summary"

Inventory Adjustment (Detail)

This report, as shown in Figure 13-45 provides yearly, monthly "Inventory Adjustment Details" for each department with reasons.

Report dimensions are:

  • Business Time

  • Product

  • Reason

Availability Analysis

This report, as shown in Figure 13-46 analyses the yearly, monthly "Availability" information for each item department.

Report Dimensions are:

  • Business Time

  • Product

Figure 13-46 Availability Analysis Report

Description of Figure 13-46 follows
Description of "Figure 13-46 Availability Analysis Report"

Compliance

Compliance area includes the following reports: Vendor Compliance and Vendor Performance.

Vendor Compliance

This report, as shown in Figure 13-47 provides the comparison information of current year's vendor compliance with last year for each vendor.

Report Dimensions are:

  • Business Time

  • Product

  • Vendor

Figure 13-47 Inventory Vendor Compliance Report

Description of Figure 13-47 follows
Description of "Figure 13-47 Inventory Vendor Compliance Report"

Vendor Performance

This report, as shown in Figure 13-48 provides the yearly, monthly "Vendor's performance" information for each vendor and item.

Report Dimensions are:

  • Business Time

  • Product

  • Vendor

Figure 13-48 Inventory Vendor Performance Report

Description of Figure 13-48 follows
Description of "Figure 13-48 Inventory Vendor Performance Report"

Merchandise

Merchandise area includes the following reports: Comp Sales, Vendor Product, RTV Trend, Sales and Inventory Item, Vendor Sales, and Sales and Inventory.

Comp Sales

This report, as shown in Figure 13-49 provides the yearly comparison information of sales and inventory by department. You can compare the current year with last year.

Report Dimensions are:

  • Business Time

  • Product

Figure 13-49 Merchandise Comp Sales Report

Description of Figure 13-49 follows
Description of "Figure 13-49 Merchandise Comp Sales Report"

Vendor Product

This report, as shown in Figure 13-50 provides the yearly and monthly "Supplier Product Scorecard" information for each vendor.

Report Dimensions are:

  • Business Time

  • Product

  • Vendor

Figure 13-50 Merchandise Vendor Product Report

Description of Figure 13-50 follows
Description of "Figure 13-50 Merchandise Vendor Product Report"

RTV Trend

This report as shown in Figure 13-51 provides the yearly, monthly "RTV Trend" information for each vendor.

Report Dimensions are:

  • Business Time

  • Vendor

Figure 13-51 Merchandise RTV Trend Report

Description of Figure 13-51 follows
Description of "Figure 13-51 Merchandise RTV Trend Report"

Sales and Inventory Item

This report as shown Figure 13-52 analyses the yearly sales and profit for each vendor and product.

Report dimensions are:

  • Business Time

  • Product

Figure 13-52 Merchandise Sales and Inventory Item Report

Description of Figure 13-52 follows
Description of "Figure 13-52 Merchandise Sales and Inventory Item Report"

Vendor Sales

This report as shown in Figure 13-53 analyses the yearly sales and profit for each vendor and product.

Report Dimensions are:

  • Business Time

  • Vendor

  • Product

Figure 13-53 Merchandise Vendor Sales Report

Description of Figure 13-53 follows
Description of "Figure 13-53 Merchandise Vendor Sales Report"

Sales and Inventory

This report, as shown in Figure 13-54 provides the year level "Sales and Inventory" information for each Department and Item which can be compared with last year's metrics such as LY, and percent change LY.

Report dimensions are:

  • Business Time

  • Product

Figure 13-54 Merchandise Sales and Inventory Report

Description of Figure 13-54 follows
Description of "Figure 13-54 Merchandise Sales and Inventory Report"

Quality Assurance

Quality Assurance area includes the following reports: Delivery Accuracy, Quality Measure, and Timeliness.

Delivery Accuracy

This report, as shown in Figure 13-55 provides the yearly delivery accuracy information for each product and vendor.

Report Dimensions are:

  • Business Time

  • Product

  • Vendor

Figure 13-55 Quality Assurance Delivery Accuracy Report

Description of Figure 13-55 follows
Description of "Figure 13-55 Quality Assurance Delivery Accuracy Report"

Quality Measure

This report, as shown in Figure 13-56 provides the yearly quality measure details for each product division and vendor.

Report Dimensions are:

  • Business Time

  • Product

  • Vendor

Figure 13-56 Quality Measure Report

Description of Figure 13-56 follows
Description of "Figure 13-56 Quality Measure Report"

Timeliness

This report, as shown in Figure 13-57 provides the timeliness details for each product division vendor.

Report Dimensions are:

  • Business Time

  • Vendor

Figure 13-57 Quality Assurance Timeliness Report

Description of Figure 13-57 follows
Description of "Figure 13-57 Quality Assurance Timeliness Report"

Stock Movement

Stock Movement area includes the following reports: Inventory and Receipts, and Ending On Hand (EOH) Value.

Inventory and Receipts

This report, as shown in Figure 13-58 provides the yearly "Inventory and Receipts" information for each department. Also provides the organization, Inventory movement details.

Report Dimensions are:

  • Business Time

  • Product

  • Organization

Figure 13-58 Stock Movement Inventory and Receipts

Description of Figure 13-58 follows
Description of "Figure 13-58 Stock Movement Inventory and Receipts"

Receipts and Inventory by Vendor

This report, as shown in Figure 13-59 and Figure 13-60 the yearly receipts details for each vendor. Also provides the "Vendor Inventory Movement" details.

Report Dimensions are:

  • Business Time

  • Product

  • Organization

  • Vendor

Figure 13-59 Stock Movement Receipts and Inventory by Vendor Report

Description of Figure 13-59 follows
Description of "Figure 13-59 Stock Movement Receipts and Inventory by Vendor Report"

Figure 13-60 Stock Movement Vendor Inventory Report

Description of Figure 13-60 follows
Description of "Figure 13-60 Stock Movement Vendor Inventory Report"

Ending On Hand (EOH) Value

This report, as shown in Figure 13-61 provides the details about the stock at the end of a business year for each retail type.

Report Dimensions are:

  • Business Time

  • Retail Type

Figure 13-61 Ending On Hand (EOH) Value Report

Description of Figure 13-61 follows
Description of "Figure 13-61 Ending On Hand (EOH) Value Report"

Order Management Reports

Order Management Reports include the following areas: Order Status.

Order Status

This report as shown in Figure 13-62 provides the year month-level "Order Status" information for each "Organization Banner" which can be compared with "Customer Order Backorder Retail Value" and "Backorder Units".

Report dimensions are:

  • Time

  • Organization

Figure 13-62 Order Status Report

Description of Figure 13-62 follows
Description of "Figure 13-62 Order Status Report"

Store Operation Reports

The Store Operation reports include the following areas:

Comp Store

Stock Movement area includes the following reports: Sales Analysis, and Sales Comparison.

Sales Analysis

This report, as shown in Figure 13-63 provides the year level "Sales Analysis" information for each Region, Store and Item Department.

Report dimensions are:

  • Business Time

  • Organization

  • Product

Figure 13-63 Comp Store Sales Analysis Report

Description of Figure 13-63 follows
Description of "Figure 13-63 Comp Store Sales Analysis Report"

Sales Comparison

This report, as shown in Figure 13-64 provides the year month-level "Sales Comparison" information for each Region and each "Store" which can be compared with last year's metrics like LY, % Change LY.

Report dimensions are:

  • Business Time

  • Organization

Figure 13-64 Sales Comparison Report

Description of Figure 13-64 follows
Description of "Figure 13-64 Sales Comparison Report"

Profit Analysis

This report as shown in Figure 13-65 provides the year level "Profit Analysis" information for each Region which can be compared with last year's metrics such as LY, % Change LY.

Report dimensions are:

  • Business Time

  • Organization

Figure 13-65 Comp Store Profit Analysis Report

Description of Figure 13-65 follows
Description of "Figure 13-65 Comp Store Profit Analysis Report"

Store Performance

Store Performance area includes the following reports: Contribution, Store Performance, Ranking, and Scorecard.

Contribution

This report, as shown in Figure 13-66 provides the year level "Contribution" information for each Region and Store.

Report dimensions are:

  • Business Time

  • Organization

Figure 13-66 Store Performance Contribution Report

Description of Figure 13-66 follows
Description of "Figure 13-66 Store Performance Contribution Report"

Store Performance

This report, as shown in Figure 13-67 provides the year month week-level "Store Performance Trend" information for each "Store" with respect to each "Organization Region" which can be compared with last year's metrics like LY, % Change LY.

Report dimensions are:

  • Business Time

  • Organization

Figure 13-67 Store Performance Report

Description of Figure 13-67 follows
Description of "Figure 13-67 Store Performance Report"

Ranking

This report, as shown in Figure 13-68 provides the year level "Ranking" information for each Area and "Store".

Report dimensions are:

  • Business Time

  • Organization

Figure 13-68 Store Performance Ranking Report

Description of Figure 13-68 follows
Description of "Figure 13-68 Store Performance Ranking Report"

Scorecard

This report, as shown in Figure 13-69 provides the store sales scorecard,(Local) information for each Area and "Store".

Report dimensions are:

  • Business Time

  • Organization

Figure 13-69 Store Performance Scorecard Report

Description of Figure 13-69 follows
Description of "Figure 13-69 Store Performance Scorecard Report"

Over/Short

Over/Short area includes the following reports: Employee Over/Short and Store Over/Short.

Employee Over/Short

This report, as shown in Figure 13-70 provides the year month week-level "Employee Over/Short" information for each Employee with respect to each "Organization Division" and "Store".

Report dimensions are:

  • Business Time

  • Organization

  • Employee

Figure 13-70 Employee Over/Short Report

Description of Figure 13-70 follows
Description of "Figure 13-70 Employee Over/Short Report"

Store Over/Short

This report, as shown in Figure 13-71 provides the year month week-level "Store Over/Short" information for each "Store" with respect to each "Organization Division".

Report dimensions are:

  • Business Time

  • Organization

Figure 13-71 Store Over/Short Report

Description of Figure 13-71 follows
Description of "Figure 13-71 Store Over/Short Report"

Traffic

Traffic area includes the following reports: Store Traffic Day and Store Traffic Week.

Store Traffic Day

This report, as shown in Figure 13-72 provides the year month weekday-level "Store Traffic-Conversion Rate" information for each "Store" with respect to each "Organization Region".

Report dimensions are:

  • Business Time

  • Organization

Figure 13-72 Traffic Store Traffic Day Report

Description of Figure 13-72 follows
Description of "Figure 13-72 Traffic Store Traffic Day Report"

Store Traffic Week

This report, as shown in Figure 13-73 provides the year month week-level "Store Traffic-Conversion Rate" information for each "Store" with respect to each "Organization Region".

Report dimensions are:

  • Business Time

  • Organization

Figure 13-73 Store Traffic Week Report

Description of Figure 13-73 follows
Description of "Figure 13-73 Store Traffic Week Report"

Transaction

Transaction includes the Hourly Sales and Hourly Sales Trend reports.

Hourly Sales

This report, as shown in Figure 13-74 provides the yearly hour-level "Hourly Sales" information for each "Store" with respect to each "Organization Region "which can be compared with Net Sales Amount and Number of Sales Transactions.

Report dimensions are:

  • Business Time

  • Organization

  • Time of Day

Figure 13-74 Store Operation Transaction Hourly Sales Report

Description of Figure 13-74 follows
Description of "Figure 13-74 Store Operation Transaction Hourly Sales Report"

Hourly Sales Trend

This report, as shown in Figure 13-75 provides the yearly hour-level "Hourly Sales Trend" information for each "Store" with respect to each "Organization Region "which can be compared with % Hourly No. of Transaction to Total Day.

Report dimensions are:

  • Business Time

  • Organization

  • Time of Day

Figure 13-75 Hourly Sales Trend Report

Description of Figure 13-75 follows
Description of "Figure 13-75 Hourly Sales Trend Report"

Store Loss Analysis

Store Loss DT Profile

This report, as shown in Figure 13-76 provides the reduction in inventory.

Report dimensions are:

  • Business Time

  • Organization

  • Tender Trend

Figure 13-76 Store Loss Analysis Store Loss DT Profile Report

Description of Figure 13-76 follows
Description of "Figure 13-76 Store Loss Analysis Store Loss DT Profile Report"

Store Loss Factor Rank

This report, as shown in Figure 13-77 provides the reduction in inventory (due to damage, spoilage and so forth).

Report dimensions are:

  • Business Time

  • Organization

  • Tender Trend

Figure 13-77 Store Loss Analysis Store Loss Factor Rank Report

Description of Figure 13-77 follows
Description of "Figure 13-77 Store Loss Analysis Store Loss Factor Rank Report"

Store Loss Prediction

This report, as shown in Figure 13-78 provides the reduction in inventory (due to damage, spoilage and so forth).

Report dimensions are:

  • Business Time

  • Organization

  • Tender Trend

Figure 13-78 Store Loss Prediction Report

Description of Figure 13-78 follows
Description of "Figure 13-78 Store Loss Prediction Report"