Release Notes

Release 33

by

Alterations customer.invoice (beta version test release)Change of Information Source to QFACT_BMT_DWH_INVOICE_TAB_IAS$ and QFACT_BMT_CUST_ORD_INV_HE_IAS$ (for Ready to Send and Invoice Sent) employee.details_plus (beta version test release)ADD WORK_LOCATION_DESCRIPTIONEMPLOYEE_STATUS_CODE IN (1,7,8) (keeps Employee Category for Secondment visible) Addition busopp.details_202409Change source to ifs.FACT_BUSINESS_OPP_OL$Include [CF$_PRU_VALUE] as PRU Notes Files sql/svw/customer/customer_invoice.sql (DEV) and sql/svw/customer/customer_invoice.sql (PRD) are differentFiles sql/svw/employee/employee_details_plus.sql (DEV) and sql/svw/employee/employee_details_plus.sql (PRD) are differentFile sql/svw/busopp/202409 found in DEV but not … Read more

Use Case: API vs CSV

by

When comparing the integration of CSV files and APIs with the DataWarehouse, several factors impact data integrity, including data accuracy, consistency, security, and the ability to handle large datasets. Below are some key comparisons and potential risks associated with each method: 1. Data Accuracy and Consistency CSV Integration: API Integration: 2. Data Security CSV Integration: … Read more

Release 32

by

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

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

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

Release 27

by

Released immediately due to data error discovered in [QFACT_BMT_ACTUAL_HOURS_BY_IAS$] PRD 20240731 Alterations Employee.Hours Change UPLIFT to CAST(GROSS AS DECIMAL(10, 3)) – CAST(NETT AS DECIMAL(10, 3)) AS UPLIFT, As UPLIFT was being delivered with discrepancies between rounding of GROSS and NETT i.e. 21.8104 – 21.81 = -4.0E-4 This was causing an error in both CAST and … Read more

SharePointList To Staging Pipeline

by

Purpose: Transfer SharePoint List data through azure blob storage and into the DataWarehouse Requires: Prerequisites: Process Steps: 4. Data Pipeline 5. Create pipeline parameters. Create two pipeline parameters. 5. Activities Tab 6. Look up Activity Click on the Lookup activity and go to settings, from there if not already set up create a new connection … Read more