Absent Member.. kev marks Absent Member..
Absent Member..
519 views

report for Time Sheet Compliance

We need to create a report (SQL or Portlet etc) that shows Time Sheet Compliance.

We know PPM has the Delinquent Time Sheet report, but this doesnt have enough info, like manager.

 

We want to have something that reports Compliance %'s. for example...

Manager A had 80% compliance for the week of Jan 1 to Jan 7, 4 out of 5 resources inputted time.

 

We also want to see which users did not put in the time sheet or has it still in the unsubmitted or rework status, like Delinquent Time sheets.

 

Anybody have any suggestion on where to start with this. Is there code from the Delinquent Time Sheet report that we can reuse?

 

Thanks in advance.

Kevin

0 Likes
3 Replies
Celil Absent Member.
Absent Member.

Re: report for Time Sheet Compliance

Hi Kevin,

You should use DataModel guide of HP. It has table names, what them consist and relations. With this book you can do SQL easily.
Celil

IT Governance Professional
& PPM Solution Architect
0 Likes
Absent Member.. AlexSavencu Absent Member..
Absent Member..

Re: report for Time Sheet Compliance

Hi, Kevin,

 

adding to Celil's post: in workbench, go to Configuration -> Report Types and from there you should find the link to the page that contains the code for this report.

 

I think the best option for you is to enhance this report with the extra information - therefore, this is the best place to start.

 

cheers

alex


--remember to kudos people who helped solve your problem
DavidW0DHG Absent Member.
Absent Member.

Re: report for Time Sheet Compliance

So what did you end up doing here? We have a similar desire and it would be great to see where you ended up, before I recreate the wheel!  We are using PPM and HP Executive Scorecard and want to show in Scorecard time sheet compliance....

 

Thanks! 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.