Purpose The Customer Order Line Value view provides a detailed financial overview of customer order lines, including key pricing and cost information, quantities, dates, and currency-based amounts. This view is specifically designed to facilitate reporting and analysis on the financial performance of individual order lines. It includes fields that capture gross and net amounts, tax-inclusive … Read more
Purpose The Customer Order Line Status view provides detailed tracking of the operational state of each customer order line. It monitors statuses, user actions, and error messages for each line item within customer orders, offering insights into the progress and any potential issues in order line processing. This view is essential for maintaining transparency and … Read more
Purpose The Customer Invoice Value view provides detailed financial information on customer invoices, including gross, VAT, and net amounts across multiple currencies. This view is focused on delivering a comprehensive breakdown of financial values, allowing for detailed reporting and analysis of invoice data. Use Case Owner: Soon TanTypical Use Case: Designed for financial reporting and … Read more
Purpose The Customer Invoice Status view provides insight into the operational state of customer invoices by tracking statuses and reporting errors. This view is intended for monitoring the life-cycle and status changes of invoices, including entry dates, user actions, and error messages. It supports operational reporting by offering visibility into any issues or errors that … 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
Stored Procedure Summary Purpose: This stored procedure, [get].[myhistory], is designed to retrieve historical views from a data mart for use in PowerBI analysis. It is flexible and allows users to specify various parameters to customise the view that is returned. Key Features: Typical Use Example Usage: PowerBI: Parameters:History_Host: bmt-dwh-uks-syn-prd-ondemand.sql.azuresynapse.netHistory_Endpoint: BMTDWHGLDBDataMart_Token: <my_token>
Purpose The Supplier Purchase Order Line Fact TableDesigned to display detailed quantitative data related to purchase orders from suppliers. This table integrates with various dimension tables to provide comprehensive insights into purchase order lines, including project associations, supplier details, and order statuses. The primary purpose is to support procurement tracking, cost analysis, and supplier management … Read more
Purpose The Supplier Purchase Order Line Fact TableDesigned to display detailed quantitative data related to purchase orders from suppliers. This table integrates with various dimension tables to provide comprehensive insights into purchase order lines, including project associations, supplier details, and order statuses. The primary purpose is to support procurement tracking, cost analysis, and supplier management … Read more
Purpose The Common View for Supplier Details, excluding dates or measures, acts as a unified and reliable source for data on business suppliers. It is accessible to different departments and systems across the organisation. This view supports integration with fact tables for reporting and analysis and provides a limited set of dimension attributes. Use Case … Read more
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