Julian.Kellett What this view is for Project.item_values provides the numeric and financial measures for projects. Where: If you’re asking:“how much has this project cost?”,“how much revenue has it generated?”, or“what is the current forecast or contingency?” — this is where you look. Architectural maturity This view is delivered as a cvw (collated view). It is assembled … Read more
The MP8 and MP9 import process is used to bring regional opportunity and order-intake information from Finance spreadsheets into the Data Warehouse in a consistent and repeatable way. What this process is for This process ensures that: It is primarily used where opportunities exist in regional or pre-IFS systems and are not yet fully represented … Read more
What this view is for Project.meta_dates provides the date-based and lifecycle attributes for projects. Where Project.core_details defines what a project is,and Project.meta_codes defines how a project is classified,Project.meta_dates defines when things happen in the life of a project. If you’re asking “when did this project start?”, “when is it due to finish?”, or “when did … Read more
What this view is for Project.meta_codes provides the categorical and classification attributes for projects. Where Project.core_details defines what a project is,Project.meta_codes defines how a project is described and grouped. If you’re asking “what type of project is this?”, “which programme does it belong to?”, or “how should this project be categorised?” — this is where … Read more
What this view is for Project.core_details is the starting point for all project-based reporting. Where: This view defines the project as a business object and provides the identity and links needed to relate delivery activity back to opportunities, orders, customers and ultimately invoicing. If you’re asking “what projects are we running, for whom, and how … Read more
Purpose evw.project_core_export_meta is a serverless-friendly export view that prepares Project objects for downstream document-style consumers (e.g. Cosmos DB, AI/ML pipelines, Graph preparation), without relying on unsupported Synapse On-Demand constructs such as stacked / correlated FOR JSON queries. It combines: This view is designed as a Stage-1 export: it yields tabular rows with embedded JSON strings … Read more
Scope: 72 changes (Collation alterations)Theme: Regional collation & preparation for IFS Cloud integration Overview This release delivers the final architectural step to support regionalisation and future IFS Cloud integration (with IFS Cloud treated as a logical “region”). A new collation layer (cvw views) has been introduced to assemble regional child sources into unified domain views.These … Read more
1. Treat the DWH as the system of record for the week Our existing rhythm is actually very strong: That already gives you something most organisations lack: a weekly data contract. Reports must key off that. 2. Reports should always trail the DWH by one controlled step With DEV → UAT → LIVE workspaces, you … Read more
1. Core View Corrections – Collation Fix Files affected Change Reason Impact 2. Project Item Values – Meta Type Standardisation Files affected Change Reason Impact 3. Project Meta Dates – Meta Type Reorganisation File affected Change Reason Impact 4. Person Absence Item Views – Join Binding Improvements Files affected Changes Reason Impact
This release focuses on improving the structure, consistency, and reliability of Sales Pipeline and Project reporting, while maintaining full historic coverage. Sales Pipeline Review and Refit A full review and refit has been completed across the core Sales Pipeline domains: Views have been refactored to follow the same structural pattern, including: The updated model adopts … Read more