MSCM Analytics

User Productivity Dashboard

New feature for Receiving and Delivery to show the activities of each user to compare users' productivity.

PO vs Non PO Deliveries

New dashboard added for Receiving and Delivery containing these features:
  • Total Receipts - a count of all PO and Non PO Receipts within the specified period
  • Deliveries - a count of all Deliveries within the specified period
  • Charts - a count of all Charts within the specified period
  • Delivery By Location and User - Striped Bar Chart - Bars signify location while Stripes denote users
  • All Receipts - Area Chart - Receipts Count (PO and Non PO over time)
  • Deliveries by Location - Striped Column Chart - Bars represent Delivery Count while Stripes represent Location over time.

Model Change to Connect Delivery Ticket table to PO Receipts

The Delivery Ticket table is now linked with the PO Header and PO Receipt tables

Productivity report ER to include Sub Units

MSCM Model Updates - Changed Activity Sub Unit from an attribute to measure, with data type Float and width 20.

MSCM Consumer Updates - Added Activity Sub Unit measure in Efficiency Tracking CSA, removed Activity Sub Unit dimension in Efficiency Tracking CSA, added column measure Activity Sub Unit in Activity Log Detail report.

Undelivered PO Lines

A new designer report from delivery ticket fact with jump to distribution line by ticket ID and PO:
  • New Designer Report and Dashboard- Undelivered Tickets Detail
  • New Designer Report and Dashboard -Undelivered Tickets Distribution Line Detail
  • Drill across from Undelivered Tickets Detail to Undelivered Tickets Distribution Line Detail through Delivery Ticket ID and PO Number

PO vs Non PO Receipts in one table source

Added attributes for PO vs Non-PO to display both type receipts in one chart, for easy comparison, and filtering of attributes in dashboards.

Add Description on ID key fields in the charts

Added descriptions to chart labels that had been only key fields on MSCM content.

Add connection between Delivery Ticket and Delivery Event

Added the link between the Delivery Event and the Delivery Ticket in Receiving and Delivery

Convert time format from decimal to Hrs and mins

Man hours in the Efficiency Tracking dashboards and detail reports are now in hours and minutes time format for clarity.