How can I create a report in OTBI that shows scheduled hours and the deviation from reported hours?

Question

I am looking for to generate OTBI report to report reported hours, scheduled hours and scheduled deviation as shown in attached screenshot. Can someone please help to know which subject area has all these details or how to generate this report from OTBI

Regie Mercado · Answer

Hello and good day!

Dearest Swati,

I am not sure if this will satisfy your requirement. Try to re-arrange table, Column 1 will be your date, column 2 will be your reported hours, column 3 will be your scheduled hours then create another column for deviation. See my sample formula and try to work around on this.

Delivery Date

Expiration Date

Stored in warehouse (Days)

Shelf life remaining before expiry (Days)

Shelf life remaining before expiry (Months)

5/16/23

5/31/25

484

262

8.73

5/21/23

5/31/25

479

262

8.73

Thanks and best regards.

Regie

John Hung-Oracle · Answer

Hi, To better serve you, please post this question in the Reporting and Analytics for HCM forum since its specific to HCM subject areas/use cases. Thank you.