Release 49

by

Additions

Business Opportunity Details for APAC

We are pleased to inform you that the list of current opportunities from APAC is now an integral part of the Data Warehouse (DEV Environment).

The source data can be viewed as an SQL table here:
https://bmt-dwh-uks-app-my.azurewebsites.net/index.php?module=app/splash/sql&grid=table&schema=sales&table=APAC_cr5a0_pipeline&rows=300&end=stg&region=apc&env=dev

Data Mapping

We have mapped the fields from the source data to the target/template fields.

This mapping is available for review:
https://bmt-dwh-uks-app-my.azurewebsites.net/index.php?module=items/items&path=25-15/26-763/27

1️⃣ The source field name as provided.
2️⃣ The target DataMart for the field (e.g., BusOpp.Details, BusOpp.Details_Plus, BusOpp.Value).
3️⃣ The template/target model applied (i.e., the specific field or data area in the DataMart).
4️⃣ The MetaType defining how the field is handled.
5️⃣&6️⃣ Use filters and search to identify fields within the data source, as there are over 90!

DataMarts

These fields have been used to create field data in three DataMarts (currently available in DEV only):

  1. BusOpp.Details_APC
  2. BusOpp.Details_Plus_APC
  3. BusOpp.Value_APC

For Power BI

The intention is for the APC DataMarts to use the same field structure as the current DataMarts.
You can access these DataMarts using the same query structure:

EXEC get.myView @token = ‘<mytoken>’, @DataMart = ’BusOpp’, @ViewName = ‘details_APC’, @version = ‘beta’

Guidance for using these views is consistent with the existing views:

  1. https://bmt-dwh-uks-app-wp.azurewebsites.net/busopp-details/
  2. https://bmt-dwh-uks-app-wp.azurewebsites.net/busopp-details_plus/
  3. https://bmt-dwh-uks-app-wp.azurewebsites.net/busopp-value/

Union/Append Query in Power BI

We recommend using a UNION/APPEND query in Power BI for combining data:

= Table.Combine({‘BusOpp_Details’,’Busopp_Details_APC’})

Further details can be found here:

https://learn.microsoft.com/en-us/powerquery-m/table-combine

BugFix

BugFix to improve ORDERLINE_SEQ

Notes

1. 🔴 MISSING IN PRD CONTAINER: busopp_details_APC.sql
2. ⚠️ DIFFERENT: busopp_details_plus_APC.sql
3. ⚠️ DIFFERENT: busopp_value.sql
4. 🔴 MISSING IN PRD CONTAINER: busopp_value_APC.sql
5. ⚠️ DIFFERENT: customer_orderline.sql
6. ⚠️ DIFFERENT: customer_orderlinestatus.sql
7. ⚠️ DIFFERENT: customer_orderlinevalue.sql
8. ⚠️ DIFFERENT: customer_orderline_202411.sql

Total number of different files: 6
Total number of missing files in DEV CONTAINER: 0
Total number of missing files in PRD CONTAINER: 2

Leave a Comment