OBIBB – PDF Backup On this page I will keep a yearly backup of this weblog. I have used the software of BlogBooker. 2010 2011 2012 Spread the word:EmailPrintTweetPocketShare on TumblrMoreLike this:Like Loading...
MY obiee reports are running slow in the dashboard.I have checked on items listed below and all seems to be well.Someone suggested that i should check on the presentation server but don’t know how.Please advice )Aggregate tables 2) Cache ( Cache Management) 3) Turning off logging 4) Constructing result using where clause 5) Limiting Number of Initialization block 6) Setting Query limits 7) Modeling Dimension Hierarchies Correctly Setting NQSConfig Parameters LikeLike Reply
Hi, Could you be a bit more specific. When you are experiencing performance issues I would start with the following: I would first try to see which queries are fired to the database. So I wouldn’t turn off logging in advance. You could have a look at the Connection Pool settings (http://obieeblog.wordpress.com/2009/08/17/connection-pools-%E2%80%93-best-practices/) Check a presentation of Mark Rittman; Click to access UKOUG%202008%20-%20Oracle%20BI%20EE%20Performance%20Optimization.pdf Cheers, Daan LikeLike Reply
DaAnalytics Blog 
Thank you Daan.It worked.
LikeLike
MY obiee reports are running slow in the dashboard.I have checked on items listed below and all seems to be well.Someone suggested that i should check on the presentation server but don’t know how.Please advice
)Aggregate tables
2) Cache ( Cache Management)
3) Turning off logging
4) Constructing result using where clause
5) Limiting Number of Initialization block
6) Setting Query limits
7) Modeling Dimension Hierarchies Correctly
Setting NQSConfig Parameters
LikeLike
Hi,
Could you be a bit more specific. When you are experiencing performance issues I would start with the following:
I would first try to see which queries are fired to the database. So I wouldn’t turn off logging in advance.
You could have a look at the Connection Pool settings (http://obieeblog.wordpress.com/2009/08/17/connection-pools-%E2%80%93-best-practices/)
Check a presentation of Mark Rittman;
Click to access UKOUG%202008%20-%20Oracle%20BI%20EE%20Performance%20Optimization.pdf
Cheers,
Daan
LikeLike