Preparation of Order Pipeline for Array Version ‘beta’ only
Customer.Order
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
Release 44
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
Customer.OrderStatus
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
Step-by-Step Instructions for Parsing a JSON Column in Power BI:
Tips: Example Scenario: If you have a JSON column like this: By following these steps, you’ll be able to effectively parse and use JSON data in Power BI for analysis and reporting.
DataMarts.ArrayVersion
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
DataMart Token
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