The SQL stored procedure [cont].[upsert_bulk_entity] is designed to handle the bulk insertion or updating (upserting) of entity data from a source table into a target entity table. Here’s a summary of the key steps involved: Overall, this procedure is designed to efficiently manage the bulk upsertion of entity data from a specified source to a … Read more
Alterations project_expenses update to code comment history Notes Files sql/svw/project/project_expenses.sql (DEV) and sql/svw/project/project_expenses.sql (PRD) are different
use masterCREATE LOGIN <user> use DatabaseCREATE USER <user> The EXECUTE permission was denied on the object ‘myhistory’, database ‘BMTDWHGLDB’, schema ‘get’. ALTER ROLE [exec_get] ADD MEMBER <user>;ALTER ROLE [read_hvw] ADD MEMBER <user>; DataSource.Error: Microsoft SQL: Error!! Error Number: 15151, Stored Procedure get_myHistory, Table Name: [hvw].[employee_details], Returned the following error : Cannot find the CREDENTIAL ‘https://bmtdwhuksstrprd.dfs.core.windows.net/gold/snapshot/employee/details/*.parquet’, … Read more
Stored Procedure Summary Purpose: This stored procedure, [get].[myhistory], is designed to retrieve historical views from a data mart for use in PowerBI analysis. It is flexible and allows users to specify various parameters to customise the view that is returned. Key Features: Typical Use Example Usage: PowerBI: Parameters:History_Host: bmt-dwh-uks-syn-prd-ondemand.sql.azuresynapse.netHistory_Endpoint: BMTDWHGLDBDataMart_Token: <my_token>
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
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.’]
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
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
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
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