Release 31

by

Alterations Project.PurchaseOrderLine (&202407)ADD DEMAND CODE Project.SupplierInvoice (&202408)REMOVE WHERE filter src.DIM_COMPANY_ID not in (‘1062’) Additional Supplier.PurchaseOrderline Notes [‘Files 20240819/svw_dev_flat\\project_purchaseorderline.sql and 20240819/svw_prd_flat\\project_purchaseorderline.sql are different.’,‘Files 20240819/svw_dev_flat\\project_purchaseorderline_202407.sql and 20240819/svw_prd_flat\\project_purchaseorderline_202407.sql are different.’,‘Files 20240819/svw_dev_flat\\project_supplierinvoice.sql and 20240819/svw_prd_flat\\project_supplierinvoice.sql are different.’,‘File project_supplierinvoice_202408.sql found in 20240819/svw_dev_flat but not in 20240819/svw_prd_flat.’,‘File supplier_purchaseorderline.sql found in 20240819/svw_dev_flat but not in 20240819/svw_prd_flat.’]

Release 30

by

NB Release 29 was Abandoned Additions Infrastructure.ChangeRequest for CAB report (description to follow) Project.PurchaseOrderline Changes Project.Expenses, changes from REPORT_CODE_GROUP NOT IN(‘Time’) >> REPORT_CODE_GROUP IN(‘Exp’), Validation: there is a risk there are other expense codes not included Project.SupplierInvoice, REMOVED HASH(Item_ID) Notes [‘File infrastructure_changerequest.sql found in 20240813/svw_dev_flat but not in 20240813/svw_prd_flat.’,‘Files 20240813/svw_dev_flat\\project_expenses.sql and 20240813/svw_prd_flat\\project_expenses.sql are different.’,‘File project_purchaseorderline.sql … Read more

Project.PurchaseOrderline

by

Purpose The Supplier Purchase Order Line Fact TableDesigned to display detailed quantitative data related to purchase orders from suppliers. This table integrates with various dimension tables to provide comprehensive insights into purchase order lines, including project associations, supplier details, and order statuses. The primary purpose is to support procurement tracking, cost analysis, and supplier management … Read more

Medallion.Platinum

by

Overview: The Platinum Layer is the most advanced tier in the data warehouse, dedicated to performing complex business transformations and machine learning (ML) exercises. This layer leverages advanced analytics to generate insights that support budget, forecasting and predictive analytics. The resulting transformed data and predictive models are then returned to the Gold Layer for delivery. … Read more

Medallion.Gold

by

Overview: The Gold Layer serves as the delivery centre of the data warehouse, providing secure and efficient access to the finalised data. This layer is responsible for delivering data to end-users and applications, ensuring that it is ready for analysis, reporting, and other business intelligence activities. Key Characteristics: Workflow Summary: Importance: RAID Risks: Issues: Dependencies: … Read more

Medallion.Silver

by

Overview: The Silver Layer, also referred to as the ‘Staging’ SQL database, is where data undergoes further refinement and transformation. This layer focuses on structuring the data into well-defined snapshots, adhering to a common data model. The goal is to create standardized and consistent data sets that are ready for analytical purposes and easy integration … Read more

Medallion.Bronze

by

Overview: The Bronze Layer is the initial raw data storage tier in the data warehouse, representing the true start of the data lake. It is designed to store data in its raw, untransformed state, yet in an organised and accessible manner. This layer ensures that the data is preserved in its original form, allowing for … Read more

Import Layer of Data Warehouse

by

Overview: The Import Layer serves as the initial landing zone for all incoming data into the data warehouse. This layer is designed to handle and store data in a variety of formats and from different sources, ensuring a flexible and robust intake process. It acts as a staging area where data can be validated, archived, … Read more

Supplier.Details

by

Purpose The Common View for Supplier Details, excluding dates or measures, acts as a unified and reliable source for data on business suppliers. It is accessible to different departments and systems across the organisation. This view supports integration with fact tables for reporting and analysis and provides a limited set of dimension attributes. Use Case … Read more

Release 28

by

Alterations Busopp.Details_Plus (&202407) Remove CONVERT(NVARCHAR(32),HashBytes(‘MD5’, CONCAT_WS(‘|’,src.COMPANY,src.OPPORTUNITY_NO)),2) as busopp_item_id, as this is now generated in get.myView Created dvw.customer_item_202406 as part of removing Company reference from customer (& Supplier) Customer.Details Removed reference to COMPANY (and the associated check of customer.invoice) Customer (and Supplier) COMPANY defaults to 9900 Check for Alterations to Customer.InvoiceCutomer.OrderlineProject.CustomerInvoiceProject.CustomerOrderlineProject.ActivityDetails get.myView COMPANY now included as … Read more