OBIEE 11g - Reports sourced from PostgreSQL Database using DataDirect 7.0.1 ODBC Driver Doesn't Execute Simultaneously
Last updated on OCTOBER 09, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 18.104.22.168.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms