Track and Trace Power BI Reports Documentation /

Mailbox Reports

Aggregation Issues Report

Version: 1, effective date: 22-Feb-2023

Alice Galoiu

---

Contents

• 1 Standard description

• 2 Data Source

• 3 Refresh Schedule

• 4 Pages

  • 4.1 Aggregation - BY InstanceID
  • 4.2 Aggregation – DayStatus

• 5 Document control

  • 5.1 Contact person
  • 5.2 Revision History

1 Standard description

This document will define the PowerBI report that shows the error messages by alert, partner and InstanceID from Folder = ‘Wordline-TPM-NOK’.

2 Data Source

Data parsed in database TPC from emails received from shared mailbox BUCTRACKT@jti.com, table dbo.MailMessages.

3 Refresh Schedule

Refresh frequency: Daily

Time zone: UTC + 01:00

Time: 11:00 AM

      13:00 PM

      15:00 PM

      19:30 PM

4 Pages

4.1 Aggregation - BY InstanceID

This page shows the number of InstanceID’s by Partner, Alerts, ContainerTypeChild and ContainerTypeParent.

4.2 Aggregation – DayStatus

This page shows the number of daily messages by Code, Action and Line Location Type

5 Document control

5.1 Contact person

Questions and feedback regarding this standard should be submitted to Alice Galoiu

5.2 Revision History

Version	Effective date	Purpose of change	Author
1	22-Feb-2023	First version of the document	Alice Galoiu

ANY QUESTIONS?

ASK TEAM