Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
41
Views
2
Comments
Swati Joshi
Swati Joshi Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Forum

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


image.png


Answers

  • John Hung-Oracle
    John Hung-Oracle Mod

    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.

  • Regie Mercado
    Regie Mercado Rank 4 - Community Specialist

    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

    image.png

    Thanks and best regards.

    Regie