Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Avesh Ganodwala
    How to Calculate MTD and YTD in Oracle BI Analysis Reports
    Topic posted November 23, 2018 by Avesh GanodwalaBronze Medal: 1,250+ Points, last edited December 3, 2018, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Public Sector, Reports, Sample Reports, Tip 
    137 Views, 2 Comments
    Title:
    How to Calculate MTD and YTD in Oracle BI Analysis Reports
    Summary:
    How to Calculate MTD and YTD in Oracle BI Analysis Reports using Project Costing Actual Costs Real Time and Project Control Budgets Real Time
    Content:

    Hi,

     

    I am trying to create a budget vs actual comparison report for projects using Project Costing Actual Costs Real Time and Project Control Budgets Real Time in OTBI. 

     

    Could any help how do i calculate MTD and YTD value for budget and Actual. Attached the screenshot of the columns that i have added using both the subject area. Kindly let me know if i need to any column as well.

     

    Regards,

    Avesh Ganodwala

    Version:
    18B
    Image:

    Comment

     

    • Lak

      Hi Avesh,

      I have similar type of requirement, if you get the answer for this question please let me know.

      Thank you.

      --Lak

      • Avesh Ganodwala

        Hi Lak,

         

        We have raised an SR and currently with subject area we can not calculate MTD/YTD vlaue as per engineer.

        Unfortunately, this feature is unavailable with the subject area being used here. 
        QTD/YTD support is being added to this SA in the release : 11.13.18.10.0, you are currently on 11.13.18.05.0
        Regards,
        Avesh Ganodwala