BYOD Power BI Reports

1. Item Physical Dimension Details 
   1. BYOD – UTSQLDB and PRODSQLDB
   2. Stored procedure – SP_HGR_ItemPhysicalDim
   3. Entities – WHSItemPhjysicalDimensionDetailStaging, EcoResReleasedProductV2Staging, EcoResProductV2Staging

2. Multi-Level BOM with Primary Vendor Information 
   1. BYOD – UTSQLDB and PRODSQLDB
   2. Stored procedure – SP_HGR_ExtractMultiBOMInfo
   3. Entities – BOMBillOfMaterialsLineV3Staging, EcoResReleasedProductV2Staging, BOMBillOfMaterialsVersionV4Staging, VendVendorV2Staging
   4. Temporary SQL tables – HGR_BOMLinesMultiLevel
   5. Power Automate Script - scheduled to run every day at 7:15AM CST to call stored procedure above. 

3. Route Operations Relations Report 
   1. BYOD – UTSQLDB and PRODSQLDB
   2. Stored procedure – SP_HGR_Route_Operations_Relations
   3. Entities – RouteRouteOperationsStagingV2, RouteOperationPropertiesV2Staging, RouteVersionV2Staging

Power Automate script: