Standardisation of DataMart View Queries for SQL OnDemand To enhance query consistency and readiness for SQL OnDemand, we have implemented a major standardisation across all DataMart view queries. Key Enhancements: ✅ Uniform Aliases for Data Sources – All table references now include consistent and meaningful aliases, improving readability and maintainability. ✅ Standard Positioning of — … Read more
An interim release with no functional changes Notes 1. 🔴 MISSING IN PRD CONTAINER: customer_details_CAD.sql2. ⚠️ DIFFERENT: customer_details.sql3. ⚠️ DIFFERENT: project_cost_CAD.sql4. ⚠️ DIFFERENT: project_details_plus_CAD.sql5. ⚠️ DIFFERENT: project_details_CAD.sql6. ⚠️ DIFFERENT: project_revenue_CAD.sql Total number of different files: 5Total number of missing files in DEV CONTAINER: 0Total number of missing files in PRD CONTAINER: 1
Notes 1. ⚠️ DIFFERENT: project_cost_CAD.sql2. ⚠️ DIFFERENT: project_cost_USD.sql3. ⚠️ DIFFERENT: project_details_CAD.sql4. ⚠️ DIFFERENT: project_details_plus_CAD.sql5. ⚠️ DIFFERENT: project_details_plus_USD.sql6. ⚠️ DIFFERENT: project_details_USD.sql7. ⚠️ DIFFERENT: project_revenue_CAD.sql8. ⚠️ DIFFERENT: project_revenue_USD.sql Total number of different files: 8Total number of missing files in DEV CONTAINER: 0Total number of missing files in PRD CONTAINER: 0
Additions Employee.Absence This view combines employee data (DIM_EMPLOYEE_OL) with absence details (QFACT_ABSENCE_DETAILS_OL$) to facilitate the creation of a dataset used for tracking and analysing employee absences in detail. It generates structured JSON data for efficient reporting, compliance, and analytical purposes. Employee.AbsenceLimit This view creates a structured dataset for tracking and analysing employee absence limits. It … Read more
Additions Marketing New [Marketing] DataMart is designed to support Customer Acquisition and Campaign Management efforts. It provides a centralised, standardised structure for analysing marketing activities, optimising campaign performance, and understanding customer engagement across multiple channels. 12 standardised views. This structure allows for seamless integration and analysis of marketing performance across platforms (e.g., Advertising, Traffic, Email … Read more
Alterations Business Opportunity Reporting with APAC The team are delighted to inform you that the current Opportunities from APAC are now available in PRD and can be reported upon I have crafted a report for your perusalhttps://app.powerbi.com/groups/5875d12b-85b8-434f-a42b-4d473cb8afe0/reports/573c53a0-cb82-4c98-a3c1-7d90c374ad0d/ReportSection?experience=power-bi Notes 1. ⚠️ DIFFERENT: busopp_details_APC.sql2. ⚠️ DIFFERENT: busopp_details_plus.sql3. ⚠️ DIFFERENT: busopp_details_plus_APC.sql4. ⚠️ DIFFERENT: busopp_value.sql5. ⚠️ DIFFERENT: busopp_value_APC.sql Total … Read more
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®ion=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