Delivery domains covering projects, resources, and programmes.
Purpose The Project Supplier Invoice (value) fact table is designed to display quantitative data related to invoices generated for projects. This table integrates with dimension tables, such as supplier_details and project_details, to provide detailed insights into the financial aspects of projects, including invoicing, revenue, and billing trends. The primary purpose is to support forecasting, budgeting, and … Read more
Purpose The Common View for Resource Details, excluding dates or measures, acts as a unified and reliable source for data on project resources. 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 Customer Invoice, provides high-level invoice details primarily focused on essential customer and financial information. It is structured to include invoice metadata, billing details, amounts, and various identifiers. The view originates from multiple snapshots and iterations, with each change tracked meticulously to support functionality and flexibility for different reporting and integration requirements. Use Case Owner: Soon … Read more
Purpose The Customer Order Line view provides essential details for individual order lines within customer orders. It serves as a granular component, detailing each line item’s specifics, such as quantity, pricing, revenue, dates, and relevant codes. Designed to align closely with the Customer Order view, this view enables precise tracking of each line item in … Read more
Purpose The Project Forecast fact table is designed to display projected data related to future project performance, including anticipated costs, revenues, timelines, and resource requirements. This table integrates with dimension tables, such as Project_Details, to provide detailed insights into future planning and strategic decision-making. The primary purpose is to support forecasting, budgeting, and proactive project … Read more
Purpose The Common View for Employee Details. It provides dimension attributes essential for data segmentation of Employee data. It is accessible to multiple departments and systems across the organisation. An extension of BusOpp.Details Use Case Owner: Martyn ColeTypical Use Case: It provides dimension attributes essential for data segmentationStyle: Dimension, meaning a single row per Business Opportunity No. Source … Read more
Purpose The Common View for Business Opportunity Details, excluding dates or measures, acts as a unified and reliable source for data on business opportunities. 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 … Read more
Purpose The Employee Headcount fact table is designed to display quantitative data related to employees. This table integrates with dimension tables, such as Employee_Details, to provide detailed insights into various aspects of employee performance, compensation, and other metrics. The primary purpose is to support data-driven decision-making across the organisation. Use Case Owner: Sam Jopson-WhiteTypical Use Case: Resource … Read more
Purpose PRU and Programme Organisation Source Parameters PRU Sample Exec Response SQL
Purpose The Employee.Details_Plus view extends the foundational Employee.Details dataset, offering enriched employee data for segmentation, reporting, and integration across organisational systems. It consolidates employment, organisational, and job-related details into a comprehensive, consistent format to support analytical and operational needs. Use Case Owner: Sam Jopson-WhiteTypical Use Case: Integration with fact tables for enhanced reporting and analysis, such as … Read more