General OBIEE

Get Involved. Join the Conversation.


    List of OTBI inefficient Reports
    Topic posted September 7, 2018 by KingsleyRed Ribbon: 250+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Customizing Reports, Data Models, Fusion, Fusion Performance Mgmt, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Report Layouts, Report Output, Reports, Sample Reports, Scheduling or Agents, SQL 
    185 Views, 5 Comments
    List of OTBI inefficient Reports
    looking for was to monitor OTBI reports performance and Frequency of use

    Hi All,

    I am looking for ways to monitor the performance of OTBI Reports in fussion cloud environment. We have BIP and OTBI reports that are running poorly and I wish to find out how I can do that. Admin session mager provides the cursor cache where I can see the OTBI report run-time, logs and path but this information is only held for a very short time in the production environment. 

    Has anyone an idea on how i can get this information for a time period of over a month?

    - Report name with path

    - Runtime

    - Execution time and date





    R13 - 18B



    • Christian Berg

      The problem with OTBI is, that it lacks a lot of the features of the "real" OBI. Whether left out or just not exposed to you.

      OBI has Usage Tracking for that exact purpose. It's a DB storage for everything you see in the "Manage Sessions" so it persists the information and you can use OBI itself to analyze what's happening.

      Not really useful in terms of solving your issue, I know, but that's how it is.

    • Saresh Namboorissery


      Does this SRDC - Fusion Application OTBI Report Performance (Doc ID 2007833.1) help?



    • Kingsley

      Christian/ Saresh,

      how helpful will the pod logs be in providing this information? I don't mind requesting it via SR if it will provide a solution to this issues.