Report for specified pay period that shows time card hours paid and costs

Summary:

I need a report that can be run by department to show hours reported and the associated pay costs thru payroll. I am attempting in OTBI with Payroll Run Real time Results and Reported Time Cards but while I can get the reported time accurate I cannot correctly pull the cost piece. Does anyone have a report they completed they could share? We also have FDI but I only see the payroll balances subject area.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):