OBIEE Report/Dashboard Performance Tuning

You come Morning to the office And all the users are complaining about the OBIEE reporting system is very slow (dashboards). What is your approach to resolve the issue?

Ans: 

1. First check NQServer.log 

2. Admin Tool -> click Session Manager. Check if there is any bottleneck and accordingly resolve.

      Refresh the sessions.........

3. Analytics or Answers -> Administration-> Manage Sessions

 Check the physical query and execute from the back-end(BE).

Performance Tuning at real time

Performance Tuning is the huge topic to answer;

let’s take step by step approach as follows...
       Check whether the same query is running or anyone update the query.If the same query is running then follow the steps given below,

• When you open the dashboard page, first figure out whether Prompt or Report is taking more time
• If it is prompt, check for any multi select prompts which are taking time to load all values.. (best practice is set default values).
• If Report is taking longer time, set some default filters and query for just couple of records and check the report performance.
• Take physical SQL from the session log (if SQL is not generated check for log level whether it is less than 2).
• Run this Physical SQL in the TOAD or any SQL Editor.
• Check Explain plan for the cost of the query.
• Hash Joins/Cartesian Joins are always kills performance.
• Some-times, Force Inner-join also helps to force the tables to have inner-join between two tables.
• Check are there any "Full Table Scans" happening instead of Index Scan.
• Consult your DBA for the Stats.

OBIEE real time questions

Interview questions on OBIEE