Release Notes

Additions: customer_order The customer_order view serves as a document header for the customer_orderline views, providing essential summarised information about customer orders. USD New Project views for North America (USD) myBMT Link for data perusalThese are planned to be delivered as APPEND/UNION to get.myview Alterations: Order Pipeline Further improvements to the ‘array version’ of Customer Pipeline … Read more

Release includes 23 improvements and 8 new views, affecting Project, Business Opportunity (Busopp), Customer, and Employee data views. DataMarts Affected 1. Project-related Views: 2. Business Opportunity (Busopp) Views: 3. Customer-related Views: 4. Employee-related Views: Notes Files sql/svw/project/project_activitydetails.sql (DEV) and sql/svw/project/project_activitydetails.sql (PRD) are different.Files sql/svw/project/project_forecast.sql (DEV) and sql/svw/project/project_forecast.sql (PRD) are different.Files sql/svw/project/project_details_plus.sql (DEV) and sql/svw/project/project_details_plus.sql (PRD) … Read more

New Versions 202410 Content Reviewed by AI Project Details Removal of legacy Project_Item_ID as HASHADD project [STATUS] Project Details_Plus ADD Project Manager EmailRemove Project Dates (for Project.Dates)Remove FINANCIALLY RESPONSIBLE (for Project.RoleAssignment)Remove CUSTOMER RESPONSIBLE (for Project.RoleAssignment) Project Dates First Version since Beta Project_Cost ADD PRU CodeREMOVE Dates (for Project.Dates)Include Currency (of Company)COALESCE(dim_proj.PROJECT_CURRENCY_CODE, dim_company.CURRENCY_CODE) AS CURRENCY_CODE Project_Value … Read more

Additions Employee.Employment The purpose of this DataMart view is to provide a clear snapshot of an employee’s current and historical employment status within a company. It captures essential details such as employment dates, employment type, and agreement, with a focus on determining whether an employee is currently active or not. This view is useful for … Read more

Alterations Employee Details Following recent discussions and a review of the current structure of the Employee datamart, we have identified the need to align more closely with the structure of the Employee panes in IFS, specifically the Employee Summary and Employee Employment sections. This action supports GMIS UK Optimisation Activity 008 – HR Processes Currently, … Read more

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