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

Gianni Ceresa

It sounds like you tried to "fix" it before to find out where time was spent.

If it takes 10 minutes you must be able to map out exactly which step took how long, as that is what will drive your "fix" approach.

Push logs and do a time profile for that analysis.

This will help you in finding where time is spent, and for each step you will be able to take appropriate actions.

(old but still totally valid: https://www.rittmanmead.com/blog/2013/03/performance-and-obiee-summary-and-faq/ )

[Deleted User]

Just to add to Gianni's input:

The "actions" above are the ones which normally have less impact on performance than the real culprits - database, DB design and data model. I.e. most of the time it's the queries and the databases that are the issue.

Look at Robin's blog post. Look at how to create a time profile. Look at WHERE the time gets lost.