Track and Trace Power BI Reports Documentation
KG Codes Reports From DataLake
Version: 1, effective date: 22-Feb-2023
Contents
1 Standard description
This document will define the PowerBI report that shows the list of KG codes that can be exported in Excel.
2 Data Source
sqlod-msfnex22-10-curated-sqlsa-msfnex22-10-serving-prod-ondemand.sql.azuresynapse.net
Tables: [GSC_GLB_TTHardening_GATE].[v_GateCodes] and [GSC_GLB_TTHardening_TPM].[v_Report_Utilisation]
3 Refresh Schedule
Refresh frequency: Daily
Time zone: UTC + 02:00
Time: 12:00 AM
4 Code List Page
The list of codes can be filtered by PlantID and ProductionLine.
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?