For the resolution of a serious duplicate/bug project_details_plus Observation EMPLOYEE_DETAILS_OL contains duplicates for PERSON_ID within in the same company Identified Actions Our immediate action is to gather more details from [QDIM_PERSON_INFO_OL$], and drop link to EMPLOYEE_DETAILS_OL for manager details, and resolve the in DataMart duplicate. Please could you verify if Colleen Martin (1000602) are valid … Read more
Release 36 & 37: interim releases contained editorial changes to support identification of table resources for IFS efficiency optimisation Additions New views to support the implementation of Power BI – Live Order Intake and Pipeline Review – Power BI Customer.InvoiceValue Customer.InvoiceStatus Customer.OrderlineValue Customer.OrderlineStatus Alterations Customer.InvoiceChange Source: QFACT_BMT_DWH_INVOICE_TAB_IAS$ADD Pipeline reference for ORDER_NORemove Dates and Values to … Read more
Alterations BussOpp Validation exercise for Live Order Intake Report busopp.details_plus & busopp_value (202409) Resource resource.activity, further removal of references to ‘Job’ Customer Orderline customer_orderline, further alignment with customer.orderline with regard to Target date Notes Files sql/svw/project/project_customerinvoice.sql (DEV) and sql/svw/project/project_customerinvoice.sql (PRD) are different.Files sql/svw/project/202406/project_customerinvoice_202406.sql (DEV) and sql/svw/project/202406/project_customerinvoice_202406.sql (PRD) are different.Files sql/svw/customer/customer_orderline.sql (DEV) and sql/svw/customer/customer_orderline.sql (PRD) are … Read more
Additions employee_details_plus (202409) ADD Person.USER_ID (Windows Login)ADD User.UPN_EMAIL (Primary/Service Principle Email)Sourced EMAIL _ADDRESSS from User Associated Tickets and Actions myBMT | Employee Email Address (bmt-dwh-uks-app-my.azurewebsites.net)Change Request Register – Update data warehouse feed to include the users “identity” and “office” location information. (sharepoint.com) busopp_details_plus (202409) Change source to ifs.FACT_BUSINESS_OPP_OL$Include [CF$_PRU_VALUE] as PRU busopp_value (202409) Change source … Read more
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
Data Source Identification: Data Ingestion and Storage: Data Staging: View Creation: Automated Deployment: Snapshot Creation and Storage:
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
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
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