Purpose for Live order intake and Pipeline Review Single row (Summary Header) per Business Opportunity Use Case Owner: Soon TanTypical Use Case: Live order intake and Pipeline ReviewStyle: Tailored Fact Based on mvw.busopp_details_plus Source FROM WHERE src.[STATE] not in (‘Closed’,’Cancelled’) Parameters CompanyCustomerBusiness Opportunity Sample Exec Response SQL
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 Business Opportunity (Line) Value fact table is designed to display quantitative data related to individual line items of business opportunities. This table integrates with dimension tables, such as BusOpp.Details and Client/Cutomer_Details, to provide insight into potential revenue, sales pipeline, and opportunity management. The primary purpose is to support sales and business development analysis … Read more
Purpose Headline for Company Details Source Parameters Company Sample Exec Response SQL
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
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
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
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