OBIBB – PDF Backup
On this page I will keep a yearly backup of this weblog. I have used the software of BlogBooker.
My view on Oracle Business Intelligence (Applications)
On this page I will keep a yearly backup of this weblog. I have used the software of BlogBooker.
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
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;
http://www.rittmanmead.com/files/UKOUG%202008%20-%20Oracle%20BI%20EE%20Performance%20Optimization.pdf
Cheers,
Daan
Thank you Daan.It worked.
Pingback: Oracle BI By Bakboord – 2011 in review « Oracle BI By Bakboord