Purpose The Customer Order view provides a high-level “document header” for customer orders, designed to summarise and contextualise individual order lines within customer orderline views. It includes essential details such as order number, customer information, order dates, and status codes, serving as a consolidated source for tracking and reporting on customer orders. By connecting order-level … Read more
Purpose The Customer Order Status view provides comprehensive insights into the operational state of customer orders. By tracking statuses, user actions, error messages, and lifecycle changes, it enables monitoring and reporting on the order lifecycle. This view is essential for identifying and addressing operational issues or errors that may impact order processing. Use Case Owner: … Read more
The introduction of the array version of data marts is designed to enhance flexibility and consistency, particularly in managing regional data that may vary in field type and structure. This approach involves grouping related data fields into JSON-like arrays or structures within SQL. Here’s an explanation of its benefits and mechanics: Key Points of the … Read more
The data mart token in the myBMT system is a system-generated identifier designed to indicate which Power BI report has requested the data view. Since Power BI cannot send specific environmental identifiers (such as report titles or GUIDs) as part of its payload, this token acts as a substitute, providing a simple yet effective way … Read more
Purpose The Project Value fact table is designed to display summarised financial data related to project hours, costs, and revenues. It integrates with dimension tables, such as project_details and client_details, to provide a comprehensive view of the financial performance of each project. The primary purpose is to support project management, strategic decision-making, and financial analysis … Read more
Purpose: The purpose of this DataMart view is to provide a comprehensive timeline overview of a project’s key dates, from its creation to completion. It consolidates important project milestones such as planned and actual start and finish dates, delivery estimates, and project modifications. This view is designed to help stakeholders monitor project timelines, identify delays, … Read more
Purpose: 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 HR … Read more
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