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
Additions Employee.Employment 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 … Read more
Security Reminder Keep your SAS URL secure! Avoid sharing it with unauthorised individuals, as anyone with the link can perform the permitted actions. Impact of Expiry: The SAS token will expire on the se date in the URL (e.g., se=2024-10-22T18:23:02Z). If your SAS token expires before renewal: To prevent disruptions, ensure you renew your token … Read more
A SAS (Shared Access Signature) URL provides secure delegated access to resources in an Azure Storage account. The SAS URL you’ve shared grants specific permissions (like read, write, or delete) over a defined period. Here’s a guide on how to use it: Key Components of the SAS URL: Security Reminder Keep your SAS URL secure! … Read more
Security Reminder Keep your SAS URL secure! Avoid sharing it with unauthorised individuals, as anyone with the link can perform the permitted actions. Renewing the SAS Token Install Azure Storage Explorer Connect to Azure Storage A SAS (Shared Access Signature) URL provides secure, delegated access to resources in an Azure Storage account. The SAS URL … Read more
Alterations Employee Details Following recent discussions and a review of the current structure of the Employee datamart, we have identified the need to align more closely with the structure of the Employee panes in IFS, specifically the Employee Summary and Employee Employment sections. This action supports GMIS UK Optimisation Activity 008 – HR Processes Currently, … Read more
For the resolution of a serious duplicate/bug project_details_plus Observation EMPLOYEE_DETAILS_OL contains duplicates for PERSON_ID within in the same company Identified Actions Our immediate action is to gather more details from [QDIM_PERSON_INFO_OL$], and drop link to EMPLOYEE_DETAILS_OL for manager details, and resolve the in DataMart duplicate. Please could you verify if Colleen Martin (1000602) are valid … Read more
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
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