Release 97

by

Business Opportunity Following validation and a basic data integrity review using the export JSON views, a number of minor corrections and enhancements have been applied to the Business Opportunity view suite. busopp_meta_codes_NA busopp_meta_codes_UKS busopp_meta_dates_UKS busopp_meta_dates_UKS_archive Customer customer_core_details_UKS Archive Views busopp_core_details_UKS_archive employee_core_details_UKS_archive project_core_details_UKS_archive Employee & Person employee_meta_codes_UKS person_meta_codes_UKS person_core_details_UKS person_meta_codes_UKS person_meta_dates_UKS person_core_details person_meta_codes person_meta_dates Resource resource_item_codes_activity … Read more

Release 96a

by

Over the past 20 days, Data Engineering has continued the staged delivery of the Common Data Model (CDM) transition into the new IFS-aligned architecture, while also addressing operational stability, identity governance, and historical reporting resilience. IFS Part 1 – Initial Core Delivery Complete The first complete editions of the IFS-aligned Part 1 CDM views have … Read more

Snapshot & Temporal Reporting – Technical Oversight Proposal

by

Purpose This document outlines the proposed technical direction for introducing governed snapshot reporting into the CDM-based Data Warehouse, while preserving the existing temporal and dynamic reporting capabilities. The intention is to support: without reverting to large static snapshot table architectures. Existing Temporal Capability The CDM already supports temporal replay using effective-dated rows. Core temporal fields: … Read more

Snapshot Reporting in the Data Warehouse

by

Overview The Data Warehouse supports both live operational reporting and historical replay through effective-dated CDM views. To support consistent month-end and period-end reporting, a lightweight Snapshot Reporting approach is being introduced. This allows the business to: Current reporting challenge Operational systems are continuously changing. As projects, people, forecasts, and assignments evolve, live reports may produce … Read more

Using asat Mode in get.myview

by

Overview get.myview now supports As At timestamping for CDM views that contain temporal history. This allows reports and analysts to request the state of a DataMart view as it existed on a specific date, rather than always returning the current active position. This is an important step toward consistent historical, trend, and period-end reporting. Why … Read more

CDM Rules of the Road

by

How to use the Common Data Model correctly Why this exists The CDM is designed to provide consistent, reliable, and scalable data across the business. It is not a flat reporting dataset. If used incorrectly, you will see: These rules ensure you get the right answers. 1. Respect Domain Boundaries Each domain has a specific … Read more

Introducing History Mode in get.myview

by

Overview As part of the continuing development of get.myview, we can now expose historical records from current CDM views through a controlled parameter-driven approach. This enhancement allows users and report developers to move beyond the current-state snapshot and review how values have changed over time, using the same trusted view structures already in use today. … Read more

IFS Cloud Datamart – Priority Order

by

🟥 Tier 1 — Foundation / Programme‑Critical If these are unclear or unstable, everything else becomes noisy. These views establish identity, structure, and comparability.They must come first. 1️⃣ Project (Core Project / Delivery Context) Why it’s #1 Minimum viable preparedness If Project is wrong or ambiguous, nothing downstream can be trusted. 2️⃣ Order / Contract … Read more

IFS Cloud Datamart – Preparedness Statement

by

Purpose This statement defines what “prepared” means for the IFS Cloud datamart during the ERP transition period. Its intent is to: This is a deliberately scoped definition. It describes minimum viable preparedness, not full production readiness. What the IFS Cloud Datamart Is For At this stage of the programme, the IFS Cloud datamart exists to … Read more