Purpose To provide a SharePoint list designed to map the source field names (attributes) with the corresponding target report column names. Data Fields Field Name Description Attribute Name The exact name of the field as it appears in the data source. Platform The name of the data source route (e.g., CRM, Website Analytics, etc.). Label … 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
Accuracy is the degree of closeness to true value. Precision is the degree to which an instrument or process will repeat the same value. In other words, accuracy is the degree of veracity while precision is the degree of reproducibility. What does accuracy mean? If a measurement is accurate, it means that it agrees closely … 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
Purpose Designed to display the output from the SharePoint List Change Request The myHistory version of the request is designed to evaluate the effectiveness of the change management process. Use Case Owner: Simon WillmoreTypical Use Case: Change Management Dashboard presents key metrics such as the number of open and closed change requestsStyle: Fact Dashboards Utilising … 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
The procedure [cont].[upsert_bulk_meta_fields] is a SQL Server stored procedure designed for bulk upsert operations on metadata fields from source tables into a target metadata table. The procedure accepts various parameters to define the source and target tables, as well as the metadata structure, and supports batch processing. Key Steps in the Procedure: Purpose: The procedure … Read more