1. Opportunity Pipeline Data Sources (NA & EUR) Files: Summary:New data sources created to support the Opportunity Pipeline Dashboard covering North America and Europe. Details: 2. Customer Feedback Meta Codes Files: Summary:Initial release of the remaining components required to complete the CSMS dataset. Details: 3. Project Meta Codes – PMN File: Summary:Enhancement to stabilise the … Read more
Release Date: 18 November 2025 Overview This release introduces a number of improvements across customer, supplier, order, employee, and project data. Most updates focus on strengthening data quality, improving historical accuracy, and preparing for future Common Data Model (CDM) enhancements. No breaking changes are expected for reports. Key Improvements 1. Better Employee and Person Data … Read more
Release Notes – Week Ending 10 November 1. Feedback Meta Views Files: Summary:The former feedback_meta_codes_satisfaction view (over 800 lines) has been decomposed into its logical components to improve maintainability and clarity. These sub-views—covering Customer Voice, Customer Thermometer, Legacy External, and Legacy Internal—are now individually managed and combined through the new feedback_meta_satisfaction UNION view. This marks … Read more
Weekly Release Note – Week Ending 03 November 2025 New Views project_meta_codes_pmn A new DataMart view based on data sourced from the SharePoint List PMN, processed via a GEN2 Dataflow to the Bronze layer.🔗 View Documentation This view enables portfolio and project management insights by transforming Project Manager Narratives (PMNs) into a structured, analysable format. … Read more
DataMart views changed since 01-Oct-2025. Executive summary New views Renamed / globalised Downstream dependencies: Corrections Improvements to source identification & aliasing Purpose: Ensure tables are identified using their non-dollar names for lineage and metadata consistency. Change pattern:'{“Source”:”ifs.[QFACT_BMT_DWH_INVOICE_TAB_IAS$]”}’ as SOURCE_SYSTEM→'{“Source”:”ifs.[QFACT_BMT_DWH_INVOICE_TAB_IAS]”}’ as SOURCE_SYSTEM Views updated: Global query structure change (Beta & 202409 queries) Adopted a consistent CTE … Read more
This release delivers the first CDM-compliant Customer Satisfaction view, bringing together legacy CSMS and Customer Thermometer data, with extensions for Dynamics data planned next. Work has also begun to align General Ledger reporting to CDM standards, focusing only on the two views required for finance. In addition, improvements have been made to Customer Orderline reporting, … Read more
This release documents updates to the Data Warehouse covering changes made since 30 June. It focuses on the continued rollout of CDM-aligned views and early implementation of Resource views. 🔁 Customer & Supplier Domains customer_core_details supplier_core_details 👥 Employee Domain employee_hours Absence-Related Views employee_item_codes_absenceemployee_item_dates_absenceemployee_item_values_absence employee_meta_codes 📁 Project Domain project_item_codes_forecastproject_item_values_forecast 🔧 Resource Domain (Initial Release) resource_item_codes_activityresource_item_values_activity
Changes busopp_dates_202409 Updated to source Wanted Delivery Date from the refactored QFACT_BUSINESS_OPP_OL (formerly FACT_BUSINESS_OPP_OL$). project_value_202410 Now filtered to exclude rows where CONTROL_CATEGORY is NULL. OCNS / CEFAS DataViews These views provide an overview of the product-related DataViews derived from OCNS (Offshore Chemical Notification Scheme) and CEFAS (Centre for Environment, Fisheries and Aquaculture Science) regulatory sources. … Read more
View: project_forecast_202409 Enhancements: Spark-SQL Compatibility and Safe-Code Updates Changes Implemented To improve compatibility with Spark SQL and prepare views for future transition into Fabric or Lakehouse environments, the following adjustments have been made: Outstanding Compatibility Issues 1. IIF() in object CODE should be CASE 2. Square brackets on reserved words (e.g. [identifier]) 3. CF$ field … Read more
🔧 Summary of Changes This week’s release includes updates to four DataMart view SQL files, all related to a recent data unification issue affecting the CAD domain. The issue arose due to conflicting records across two client lists. This has now been resolved by aligning with the authoritative CL extracted from the Vision database (last … Read more