Purpose The Customer Details view serves as a unified source for basic business customer information, accessible across departments for consistent reporting and analysis. It excludes transactional data (like dates or measures) and provides a limited set of dimensional attributes, designed for integration with fact tables in reporting scenarios. Use Case Owner: Data EngineeringTypical Use Case: … Read more
Purpose The Employee Leave Entitlement fact table is designed to display quantitative data related to employees. This table integrates with dimension tables, such as employee_details_plus, 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 … Read more
Purpose Role Assignments incl Project Manager etc Alternative to Project Manager in Project Details Plus Includes Sub-Project Assignment Use Case Owner: Martyn ColeTypical Use Case: Responsibility Assignment MatrixStyle: Fact Source Key Parameters CompanyProjectResource Sample Exec Response SEQ Dates Measures Codes SQL
Purpose The Project Customer Invoice (value) Fact TableDesigned to display quantitative data related to invoices generated for projects. This table integrates with dimension tables, such as client_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 proactive project … Read more
Purpose The Project Customer Orderline (value) Fact TableDesigned to display quantitative data related to orders generated for projects. This table integrates with dimension tables, such as client_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 proactive project … Read more
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 To construct and deliver a global marketing report capturing performance across channels and platforms, aligning results against campaign or core (BAU) KPIs and assumed customer behaviour. Use Case Owner: Emma O’NeillTypical Use Case: capturing performance across channels and platformsStyle: Fact Source Key Parameters CompanyDetails Sample Exec Response SEQ Dates Measures Codes SQL
Purpose General Ledger Period Budget Use Case Owner: Soon TanTypical Use Case: General Ledger Period BudgetStyle: Fact Source Key Parameters CompanyLedger_ID (Created)PRUProject_IDAccount_ID Sample Exec Response SEQ Dates Measures Codes SQL
Purpose General ledger Transaction Use Case Owner: Soon TanTypical Use Case: General ledger TransactionStyle: Fact Source Key Parameters CompanyLedger_ID (Created)PRUProject_IDAccount_ID Sample Exec Response SEQ Dates Measures Codes SQL
Purpose General Ledger Project Balance Use Case Owner: Soon TanTypical Use Case: General Ledger Project BalanceStyle: Fact Source Key Parameters CompanyLedger_ID (Created)PRUProject_IDAccount_ID Sample Exec Response SEQ Dates Measures Codes SQL