Introduction and Configuration
In the Power Framework App, the Timesheet module is enhanced by Timesheet Reporting, which combines data sets and reports into a single PBI file using DirectQuery Mode connection type to Dataverse.
To set it up, three parameters should be considered: Dataverse, AppID. Dataverse and AppID should be updated during configuration to connect to correct Environment and Application. The Version parameter indicates the reporting version, simplifying the tracking of updates for PF internal use only and not required for configuration.
Reports Details
The report comprises several sections and dashboards:
- Compliance: This section includes two dashboards:
-
- Timesheet Compliance Summary
- Timesheet Compliance Details
- Analysis: This section consists of four dashboards:
- Hours by Activity
- Hours by Role & TM
- Hours by Project
- Time Analysis
- Resource Demand
- My Timesheet
Compliance
This section shows Compliance for Timesheet within the application. It consists of two pages: Timesheet Compliance Summary and Timesheet Compliance Details, to make sure timesheet fulfilment and tracking.
Timesheet Compliance Summary
Timesheet Compliance Summary dashboard displays Timesheets created and missing (not created), categorized by various classification attributes including Processing Status, Project Role, Team Member, Timesheet Manager, and Period.
Timesheet Compliance Details
Timesheet Compliance Details dashboard provides Details for Timesheet including Disputed hours.
Analysis
This report offers versatile analysis of approved timesheets.
Hours by Activity
Presents an analysis of Actual hours by Period categorized by Activity Category, Work Type, Activity Type.
Hours by Role and TM
Presents an analysis of Actual hours by Period categorized by Work Type and Activity Type, within the context of Project Role and Team Member.
Hours by Project
Presents an analysis of Actual hours of Working Activity within the Project, Programme and Project Role context.
Time Analysis
Offers a table for analysing actual hours within various contexts, such as Project Name, Project Role, Timesheet Manager, Team Member, Work Type, and Activity Name. It allows filtering by various fields to facilitate detailed analysis and insights.
Resource Demand
This page offers an overview of the Resource Demand module within the application, focusing on actual hours from Timesheets related to forecasted and approved metrics in days and in currently amounts. Additionally, it offers the possibility to constrain projects, roles, and team members by the percentage of Timesheet actual versus approved, using a Threshold slicer.
My Timesheet
This report displays data related to a logged-in user. It consists of three bookmarks which highlight: My Timesheet, My Projects, My Activity.
My Timesheets
Provides general information about Timesheets in the application, including not-created Timesheets and Disputed hours.
My Projects
Shows hours worked for Projects, detailing hours for each project and classified by Month and Activity Type.
My Activity
Represents Benchmarking analysis of activities between logged-in user versus all team members, versus team members with the same Project role, and versus team members with the same Timesheet manager.