Release Notes

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 … Read more

Additions New CTE Array Version for Customer OrderLine series Alterations Remove Company filter from Project.PurchaseOrderLine_202407 Notes 1. 🔴 MISSING IN PRD CONTAINER: customer_details_202411.sql2. 🔴 MISSING IN PRD CONTAINER: customer_orderlinestatus_202411.sql3. 🔴 MISSING IN PRD CONTAINER: customer_orderlinevalue_202411.sql4. 🔴 MISSING IN PRD CONTAINER: customer_orderline_202411.sql5. 🔴 MISSING IN PRD CONTAINER: customer_orderstatus_202411.sql6. 🔴 MISSING IN PRD CONTAINER: customer_order_202411.sql7. ⚠️ DIFFERENT: … Read more

Alterations Busopp.Details_Plus (beta) Complete the CTE (modular array) to include Dates and Measures/Values Busopp.Value Full version of CTE (modular array) Busopp.Dates Add New SEQ (Link sequence style) Customer.Orderline_202409 Include Project ID from QFACT_PRE_ACCOUNTING_OL$ as coalesce(cfv.CF$_PROJECT_ID,precfv.CODENO_D,src.DIM_PROJECT_ID) as PROJECT_ID, Notes Total number of different files: 2Total number of missing files in DEV CONTAINER: 0Total number of missing files in … Read more

Additions Customer Invoice for Array Version (202411) Notes Numbered Comparison Results:1. 🔴 MISSING IN PRD CONTAINER: customer_invoicestatus_202411.sql2. 🔴 MISSING IN PRD CONTAINER: customer_invoicevalue_202411.sql3. 🔴 MISSING IN PRD CONTAINER: customer_invoice_202411.sql4. ⚠️ DIFFERENT: customer_orderstatus.sql Total number of different files: 1Total number of missing files in DEV CONTAINER: 0Total number of missing files in PRD CONTAINER: 3

Additions: customer_order The customer_order view serves as a document header for the customer_orderline views, providing essential summarised information about customer orders. USD New Project views for North America (USD) myBMT Link for data perusalThese are planned to be delivered as APPEND/UNION to get.myview Alterations: Order Pipeline Further improvements to the ‘array version’ of Customer Pipeline … Read more

Release includes 23 improvements and 8 new views, affecting Project, Business Opportunity (Busopp), Customer, and Employee data views. DataMarts Affected 1. Project-related Views: 2. Business Opportunity (Busopp) Views: 3. Customer-related Views: 4. Employee-related Views: Notes Files sql/svw/project/project_activitydetails.sql (DEV) and sql/svw/project/project_activitydetails.sql (PRD) are different.Files sql/svw/project/project_forecast.sql (DEV) and sql/svw/project/project_forecast.sql (PRD) are different.Files sql/svw/project/project_details_plus.sql (DEV) and sql/svw/project/project_details_plus.sql (PRD) … Read more

New Versions 202410 Content Reviewed by AI Project Details Removal of legacy Project_Item_ID as HASHADD project [STATUS] Project Details_Plus ADD Project Manager EmailRemove Project Dates (for Project.Dates)Remove FINANCIALLY RESPONSIBLE (for Project.RoleAssignment)Remove CUSTOMER RESPONSIBLE (for Project.RoleAssignment) Project Dates First Version since Beta Project_Cost ADD PRU CodeREMOVE Dates (for Project.Dates)Include Currency (of Company)COALESCE(dim_proj.PROJECT_CURRENCY_CODE, dim_company.CURRENCY_CODE) AS CURRENCY_CODE Project_Value … Read more

Additions Employee.Employment The purpose of this DataMart view is to provide a clear snapshot of an employee’s current and historical employment status within a company. It captures essential details such as employment dates, employment type, and agreement, with a focus on determining whether an employee is currently active or not. This view is useful for … Read more

Alterations Employee Details Following recent discussions and a review of the current structure of the Employee datamart, we have identified the need to align more closely with the structure of the Employee panes in IFS, specifically the Employee Summary and Employee Employment sections. This action supports GMIS UK Optimisation Activity 008 – HR Processes Currently, … Read more