Store Performance reports

The reports in Store Performance dashboard are filtered by Sales Origin 8, which means that only data that is captured in point of sales systems is displayed.

Sales ticket information is transferred from the sales ticket input file (OPSALE) to the detailed sales statistics file (OSBSTD). See the Infor M3 Analytics for M3 CloudSuites Administration Guide for the setup information.

The measures used in Store Performance reports are sourced from the Sales Analysis fact. These measures are analyzed by Invoice Date and use the Sum aggregation.

Store Performance Details

Description: This report shows the sales performance details per store.

Measure: Gross Margin 1 Pct – Company, Invcd Net Amt – Company, Gross Profit 1 – Company, COGS Standard – Company, Invcd Qty

Chart type: Table

Sales Performance by Period

Description: This report analyzes product sales amount and margin performance based on sales by store over time. Analysis can be performed down to day level.

Measure: Gross Margin 1 Pct – Company, Invcd Net Amt – Company, Gross Profit 1 – Company, COGS Standard – Company

Chart type: 4 data series combo, 1 area chart on Y axis 1 and 3 spline charts on Y axis 2

Sales Performance by Store and Style

Description: This report shows the best-selling stores by styles based on sales, profit, and quantity.

Measure: Dynamic selection of measures with the Metric filter (Invcd Net Amt, Gross Profit 1, Invcd Qty)

Chart type: 1 data series heatmap chart

Top Sales per Unit Area by Store

Description: This report analyzes the top-performing stores by sales per unit area. Area can be in any unit of measure, depending on what is specified in M3.

Measure: Invcd Net Amt Per Unit Area

Chart type: 1 data series bar chart

Bottom Sales per Unit Area by Store

Description: This report analyzes the bottom-performing stores by sales per unit area. Area can be in any unit of measure, depending on what is specified in M3.

Measure: Invcd Net Amt Per Unit Area

Chart type: 1 data series bar chart

Top Stores

Description: This report shows the top-selling stores based on sales amount, profit, and quantity.

Measure: Dynamic selection of measures with the Metric filter (Invcd Net Amt, Gross Profit 1, Invcd Qty)

Chart type: 1 data series bar chart

Bottom Stores

Description: This report shows the bottom-selling stores based on sales amount, profit, and quantity.

Measure: Dynamic selection of measures with the Metric filter (Invcd Net Amt, Gross Profit 1, Invcd Qty)

Chart type: 1 data series bar chart

Top Styles

Description: This report shows the top-selling styles based on sales amount, profit, and quantity.

Measure: Dynamic selection of measures with the Metric filter (Invcd Net Amt, Gross Profit 1, Invcd Qty)

Chart type: 1 data series bar chart

Bottom Styles

Description: This report shows the bottom-selling styles based on sales amount, profit, and quantity.

Measure: Dynamic selection of measures with the Metric filter (Invcd Net Amt, Gross Profit 1, Invcd Qty)

Chart type: 1 data series bar chart