Assignment of people or assets to project activities.
Overview The resource.item_values_activity view provides a structured, item-level representation of planned resource effort, linking employees to project activities through planned hours. It expresses resource planning as measurable activity, enabling clear visibility of how effort is distributed across projects, activities, and time-based snapshots. Purpose This view standardises planned resource effort into the CDM item_values pattern, allowing: … 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 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 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
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
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
Purpose The Project Time (& Expenses) fact tables are designed to display quantitative data related to the time and (expenses) 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
Purpose For the calculation of Resource Utilisation Use Case Owner: Martyn ColeTypical Use Case: Project Reporting PortalStyle: Fact Code & Source related to Resource.Capacity Source Key Parameters CompanyResourceProject Sample Exec Response SEQ Entity Dates Measures Codes SQL
Purpose For the calculation of Resource Utilisation Use Case Owner: Martyn ColeTypical Use Case: Project Reporting PortalStyle: Fact Code & Source related to Resource.Activity Source Key Parameters CompanyResource Sample Exec Response SEQ Entity Dates Measures Codes SQL
Purpose For the Calculation of Resource Utilisation Use Case Owner: Martyn ColeTypical Use Case: Project Reporting PortalStyle: Fact Code & Source related to Resource.Capacity Source Key Parameters CompanyResourceAbsence Group Sample Exec Response SEQ Entity Dates Measures Codes Resource Other Codes SQL