OBIEE 11g - Reports sourced from PostgreSQL Database using DataDirect 7.0.1 ODBC Driver Doesn't Execute Simultaneously
(Doc ID 2117169.1)
Last updated on NOVEMBER 27, 2019
Applies to:Business Intelligence Server Enterprise Edition - Version 188.8.131.52.0 and later
On using Oracle Business Intelligence Enterprise Edition (OBIEE) 11g and getting data from PostgreSQL database using DataDirect 7.0.1 ODBC driver, it is noticed that the OBIEE reports are executed one after the other and there is an issue with the performance in the execution of the reports.
There are 2 reports as described below:
Report01, with small number of records-> This report returns results in seconds.
Report02, with huge number of records->This report returns results in minutes.
1. Execute Report01 by TestUser1.
2. Execute Report02 by TestUser2.
In this scenario, it is noticed that Report01 returns results in seconds and Report02 returns results in minutes.
1. Execute Report01 by TestUser2.
2. Execute Report02 by TestUser1.
In this scenario, it is noticed that Report01 returns results in minutes and it looks like Report01 is waiting for Report02 to finish.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document