Track and Trace Power BI Reports Documentation /

Mailbox Reports

Dentsu PR Notification Factory DB Report

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

Alice Galoiu

---

Contents

• 1 Standard description

• 2 Data Source

• 3 Refresh Schedule

• 4 Pages

  • 4.1 Factory - BY InstanceID
  • 4.2 Factory – Day Status
  • 4.3 Factory – By Email

• 5 Document control

  • 5.1 Contact person
  • 5.2 Revision History

1 Standard description

This document will define the PowerBI report that shows the factory issues in PowerBI 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 Factory - BY InstanceID

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

4.2 Factory – Day Status

This page shows the number of daily messages by Code, Action and Line Location Type. Also shows the number if InstanceID’s by Code and bizstep.

4.3 Factory – By Email

This page shows the number of messages by day and bizstep or by Alert and Partner.

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