Solution Architecture

Release 51

by

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

Marketing.Campaign_Details_Plus

by

The Marketing_Campaign_Details_Plus view provides an enriched and detailed representation of campaign metadata, serving as a foundational dataset for analysing and managing marketing campaigns. This view is designed to offer a structured, high-level summary of campaign attributes, ensuring clarity and consistency for reporting and decision-making. Key Features: Use Cases: The Marketing_Campaign_Details_Plus view offers a solid foundation … Read more

Release 50

by

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

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

Release 48

by

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

Release 47

by

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

Release 46

by

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

BusOpp.Dates

by

Purpose The Business Opportunity Dates view is designed to consolidate and standardise key date attributes related to business opportunities within the organisation. The Business Opportunity Dates view plays a critical role in tracking, analysing, and forecasting opportunity lifecycle events. By consolidating multiple date fields into a single structured dataset, it ensures better visibility, consistency, and … Read more

API Documentation: get.myhistory

by

Purpose The get.myhistory API and stored procedure facilitate interaction with the DataWarehouse, enabling users to retrieve historical views for analysis. Designed for PowerBI and Power Applications, it offers flexible parameters, customisable views, and outputs data in JSON format. By combining the adaptability of SQL stored procedures with a RESTful API, get.myhistory delivers a robust solution … Read more