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
Implementing Row‑Level Security in Microsoft Fabric Using Delta Tables and Security Policies Row‑Level Security (RLS) is essential when multiple users access shared datasets but should only see data they are authorized for. In Microsoft Fabric, you can implement RLS using Delta tables, table‑valued functions, and security policies — similar to SQL Server, but adapted for … 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
Delta tables are a core feature of the Microsoft Fabric Lakehouse. They solve a lot of the problems you normally hit with data lakes, especially around trust, auditing, and knowing what actually happened to your data. At a basic level, Delta tables give you ACID transactions on top of lake storage, but the real value … Read more
1. Treat the DWH as the system of record for the week Our existing rhythm is actually very strong: That already gives us 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, we … 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
This template is designed to work as a reusable starting point for Sales Pipeline reporting across Busopp, Order and Invoice, using consistent datamart views and a parameter-driven connection pattern. The template can open and run “out of the box” if default values are provided (or if you enter the parameters when prompted). What you get … Read more
The Sales Pipeline is modelled as three connected domains, each representing a different stage in the commercial lifecycle. They are not duplicates of the same data.They are different truths at different moments in time. Understanding how they relate is the key to building accurate, trustworthy reporting. The three domains at a glance Think of the … Read more
What this view is for Invoice.item_values_lines provides the numeric values associated with invoices. Where: Invoice values represent what has actually been billed. This view is the authoritative source for invoiced amounts, tax and realised value. A note on “lines” in the CDM In the Common Data Model, lines indicates a value-bearing version, not necessarily a … Read more