Track and Trace Power BI Reports Documentation /

Mailbox Reports

Dentsu PR Notification Warehouses onlyErrors 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 Warehouse =ERROR=
  • 4.2 Warehouse =ERROR= DayStatus
  • 4.3 Warehouse =UI_SEQUENCE_ERROR=

• 5 Document control

  • 5.1 Contact person
  • 5.2 Revision History

1 Standard description

This document will define the PowerBI report that demonstrates the warehouse issues from Folder = ‘Wordline-WMS-MOV’.

2 Data Source

Data parsed in TPC database 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 Warehouse =ERROR=

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

4.2 Warehouse =ERROR= DayStatus

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

4.3 Warehouse =UI_SEQUENCE_ERROR=

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