Order Supply Chain reports
The reports Shortage by Responsible and Shortage by Warehouse show the top N values by main attribute. The additional attribute used for color is not considered in the ranking. Dense rank is used; in cases of a tie, the chart might display more categories than the cut-off value.
The measures used in Order Supply Chain reports are sourced from the Sales Orders fact. These measures are analyzed by Planning Date and use the Sum aggregation.
Order Quantity Overview
Description: This report shows a high-level overview of the order quantity by stopped/stocked status. In this report, the user can see the order quantity distribution of customer orders that are on stop and with stock issues.
Measure: Order Qty
Chart type: 1 data series donut chart
Shortage by Responsible
Description: This report shows the top responsible based on the order quantity measure. This report is filtered by Stopped/Stocked Status = Not Stopped w/o Stock or Stopped/Stocked Status = Stopped w/o Stock to identify customer orders by responsible that have shortages.
Measure: Order Qty
Chart type: 1 data series stacked bar chart
Partition: The Stopped/Stocked Status is used as color to partition the chart.
Shortage by Warehouse
Description: This report shows the top warehouse based on the order quantity measure. This report is filtered by Stopped/Stocked Status = Not Stopped w/o Stock or Stopped/Stocked Status = Stopped w/o Stock to identify customer orders by warehouse that have shortages.
Measure: Order Qty
Chart type: 1 data series stacked bar chart
Partition: The Stopped/Stocked Status is used as color to partition the chart.
Top Items On Orders Not Stopped Without Stock
Description: This report shows the top items based on the order quantity measure. This report is filtered by Stopped/Stocked Status = Not Stopped w/o Stock to identify items that have shortages but are not stopped. These items will cause problem in the order process because the company cannot supply that specific item on a customer if it is not available in the stocks.
Measure: Order Qty
Chart type: 1 data series tree map chart
Items On Orders Not Stopped Without Stock Details
Description: This report shows a detailed analysis of the items on orders not stopped with shortage, sorted descending by line amount. Additional detailed measures for further analysis are made available in the report.
Measure: Line Amt – Company, Order Value – Company, Order Qty
Chart type: Table