Month: September 2024

Release 38

by

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

Customer.OrderlineValue

by

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

Customer.OrderlineStatus

by

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

Customer.InvoiceValue

by

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

Customer.InvoiceStatus

by

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

10 Crucial Facts about APIs every QA Software Tester Should Know

by

1) What is API API stands for Application Programming Interface. That means it is an interface between two applications/computers that enables them to communicate with each other through some program. You can imagine the API as a postal pigeon delivering your request to the other side and receiving what you (hopefully) expect. In order for the … Read more

Questions you should ask about their API before selecting a platform

by

When evaluating an API for a platform, asking the right questions is critical for ensuring the platform can meet your needs. Here are some important questions to consider: 1. Authentication & Security 2. Data Access & Structure 3. Documentation & Support 4. API Rate & Limits 5. Performance & Reliability 6. Customisation & Extensibility 7. … Read more

Marketing.CampaignData

by

Purpose This set of Power Query transformations has been designed to consolidate data across multiple digital marketing channels—such as social media, email campaigns, events, and page performance—into a unified master dataset. The goal is to automate and streamline the integration of data from disparate systems like HubSpot, Meltwater, and internal campaign databases, ensuring consistency and … Read more

Marketing.Events

by

Purpose The purpose of these queries is to streamline the integration and transformation of marketing and campaign data from multiple sources into a unified format. These Power Query scripts address various types of campaign-related data—ranging from email campaigns, social media posts, and advertising, to events, page performance, and form submissions. Process