General OBIEE

Get Involved. Join the Conversation.

Topic

    Kingsley
    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 
    187 Views, 5 Comments
    Title:
    List of OTBI inefficient Reports
    Summary:
    looking for was to monitor OTBI reports performance and Frequency of use
    Content:

    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

     

    Thanks

     

    Kingsley

    Version:
    R13 - 18B

    Comment

     

    • 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

      hi,

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

      Regards,
      Sareesh

       

    • 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.

       

      Thanks

       

      Kingsley