Track and Trace Power BI Reports Documentation
Track and Trace Market Operational Report
Version: 1, effective date: 22-Feb-2023
Contents
1 Standard description
This document will define the PowerBI report that is based on the collected email alerts received in shared mailbox, receptions, aggregations and shipments status and details regarding EPC’s.
2 Data Source
Data parsed in database TPC from emails received from shared mailbox.
3 Refresh Schedule
Refresh frequency: daily
Time zone: UTC + 02:00
Time: 07:00 AM
12:00 PM
17:00 PM
4 Content
T&T Market Operational Report contains 8 pages, 5 pages visible, 3 pages that can be accessed with Drill-through function or buttons from pages.
5 Pages
5.1 Menu
5.2 Overview
This page shows the evolution of OK & NOK shipments, receptions, aggregations and products. The messages can be filtered by Inbound, Outbound, Disposition and Shipments type. There is also the top 5 reasons for NOK messages.
5.3 Shipping
This page shows the evolution of OK & NOK shipments and products. The messages can be filtered by Inbound , Outbound, Location and Shipments type. There is also the top 5 reasons for NOK messages.
5.4 Receptions
This page shows the evolution of OK & NOK receptions and products. The messages can be filtered by Inbound , Outbound, Location and Shipments type. There is also the top 5 reasons for NOK messages.
5.5 Aggregation
This page shows the evolution of NOK aggregations. The messages can be filtered by Inbound , Outbound, Location and Shipments type. There is also the top 5 reasons for NOK messages.
Using the Drill-through function in the graphs, the user is sent to a details page specifying the reason of OK or NOK message and details regarding the EPC’s.
6 Document control
6.1 Contact person
Questions and feedback regarding this standard should be submitted to Alice Galoiu
6.2 Revision History
| Version | Effective date | Purpose of change | Author |
|---|---|---|---|
| 1 | 22-Feb-2023 | First version of the document | Alice Galoiu |
ANY QUESTIONS?