Track and Trace Power BI Reports Documentation /

Mailbox Reports

Dentsu PR Notification Factory and Warehouses 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 Error
  • 4.2 Duplicate of Error

• 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 and warehouse issues.

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 Error

This page shows the number of InstanceID’s by Factory/Warehouse and Alerts.

4.2 Duplicate of Error

This page shows the number of InstanceID’s by Factory/Warehouse and Alerts that have Code = 400.

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