Solution Architecture

Employee.Details_Plus

by

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

Project.Revenue_History

by

Purpose For the calculation of Project Baseline Costs/Revenue Use Case Owner: Martyn ColeTypical Use Case: Project Reporting PortalStyle: Fact Code & Source related to Project.Cost(History) Source WHERE [ELEMENT_TYPE_DB_KEY] = ‘REVE’ Key Parameters CompanyProjectCustomer Sample Exec Response SEQ Dates Entity Measures Codes Project Other Codes

Project.Cost_History

by

Purpose For the calculation of Project Baseline Costs/Revenue Use Case Owner: Martyn ColeTypical Use Case: Project Reporting PortalStyle: Fact Data Marts CompanyProjectCustomer Code & Source related to Project.Revenue(History) Source FACT_PROJECT_HISTORY_LOG_OL Where Sample Exec Response SEQ Dates Measures Transaction Hours Cost Codes SQL

Employee.Hours

by

Purpose The Employee Hours 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: Sarah MartinoTypical Use Case: Calculation … Read more

Employee.Details

by

Purpose The Common View for Employee Details provides a unified and reliable source for core employee data, suitable for integration across departments and systems. It focuses on maintaining essential and concise information, enabling integration with fact tables for reporting and analysis while ensuring compatibility with slicers and dashboards. Use Case Owner: Data EngineeringTypical Use Case: Provides contents … Read more

Project.Details_Plus

by

Purpose The Project.Details_Plus dimension table provides an extended view of project details, offering a comprehensive set of attributes essential for data segmentation and analysis. This table consolidates information relevant to various aspects of project management, including project identification, attributes, codes, dates, and manager details. It integrates seamlessly with fact tables and other dimensions to support … Read more

Project.Details

by

Purpose The Common View for Project Details, excluding dates or measures, acts as a unified and reliable source for data on projects. 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 Owner: Data … Read more

Project.Expenses

by

Purpose The Project Expenses (& Time) fact tables are designed to display quantitative data related to the expenses (and time) associated with projects. This table integrates with dimension tables, such as project_details and employee_details to provide detailed insights into the utilisation of resources and the costs incurred. The primary purpose is to support project management … Read more

Project.Cost

by

Purpose The Project Cost (& Revenue) fact tables ares designed to display quantitative data related to the costs (and revenues) associated with projects. This table integrates with dimension tables, such as project_details and client_details, to provide detailed insights into the financial performance of projects. The primary purpose is to support project management and strategic decision-making … Read more

Project.Revenue

by

Purpose The Project Revenue (& Cost) fact tables are designed to display quantitative data related to the revenues (and costs) associated with projects. This table integrates with dimension tables, such as project_details and client_details, to provide detailed insights into the financial performance of projects. The primary purpose is to support project management and strategic decision-making … Read more