2 Replies Latest reply on May 31, 2019 10:58 AM by Christian Berg

    OBIEE- Report Performance Issue

    Sagar Tippe

      Hi Team,

       

      I'm in a quite strange situation where one of my OBIEE report is running very slow (10+ mins), whereas if I took out the same report's query and run it in SQL Developer, it runs in a few seconds. I have tried multiple ways to tackle this but that didn't help.

       

      1. Restart of OBIEE server

      2. Checked temp size for java host / presentation server

      3. Enable/disable the cache

      4. Pass exact parameters

      5. Ran that individual report, and not an entire dashboard (to get rid of any section level conditions)

       

      Kindly guide on whatever I tried is worth to achieve my goal or there's anything else that I need to dig in?

       

      Thanks in advance.

      Sagar Tippe