Julian.Kellett

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

DataSource.SharepointList

by

Purpose: Transfer SharePoint list the Database environment for DataWarehouse Requires: Process Steps: 4. DataFlow Gen2 5. Power Query Window 6. Get Data 7. More… 8. SharepPoint Online List (NOT Sharepoint List) 9. Enter URL 10. Set Implementation to [2.0] 11. [Next] 12. Choose your list 13. [Create] 14 . Rename Dataflow 15. Select [Cog] on … Read more

Last Published Date

by

1. Create a blank query in Power Query Editor like so: 2. Keep “Include in report refresh” unselected. 3. Create a Card visual to show “LastPublishedDate”. 4. Before publishing the report, you need to refresh the data of the “LastPublishedDate” table, not refresh the report. 

Project.ActivityDetails

by

Purpose [FACT_PROJ_ACTIVITY_INFO_OL] unique based on ACTIVITY_SEQ, CONTROL_CATEGORY_KEY This table plans to be unique for ACTIVITY_SEQ only Use Case Owner: Martyn ColeTypical Use Case: Provide details for ACTIVITY_SEQ and Sub Project IDStyle: Dimension, Dimension i.e. Single row per ACTIVITY_SEQ Source Key Parameters CompanyProjectCustomerActivitySeq Sample Exec Response SEQ Dates Measures Codes SQL

Release 25

by

Notes Alterations project_customerorderlineproject_customerorderline_202407 ADD PRE_ACCOUNTING_IDAwaiting arrival of [QFACT_PRE_ACCOUNTING_OL$]Internal Notes project_timeproject_time_202407 ADD INTERNAL_COMMENTsParallel change with project.expenses Resource_Activity_202407 Remove Resource Title, to use DataView (dvw) Additions project_activitydetailsproject_activitydetails_202407 [FACT_PROJ_ACTIVITY_INFO_OL] unique based on ACTIVITY_SEQ, CONTROL_CATEGORY_KEYThis table plans to be unique for ACTIVITY_SEQ only employee.leaveentitlementemployee.leaveentitlement_202406 myBMT | CR354: Employee Leave Entitlements (bmt-dwh-uks-app-my.azurewebsites.net) get.myView2 New version of get.myView for UAT Auto … Read more

Customer.Details

by

Purpose The Customer Details view serves as a unified source for basic business customer information, accessible across departments for consistent reporting and analysis. It excludes transactional data (like dates or measures) and provides a limited set of dimensional attributes, designed for integration with fact tables in reporting scenarios. Use Case Owner: Data EngineeringTypical Use Case: … Read more