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
Purpose Date table for Financial Year Source Spreadsheet of Period Dates Parameters Date_KeyCompany Sample Exec Response SQL
Purpose Calendar Year Sample Exec Response SQL
Purpose Combined Date Table (myDate & Period) filtered for single company Sample Exec Parameters [Date_Key] Response Holiday Period SQL