No Data Fetched Still report slow

building reports webintelligence
1

Hi All,
I have some reports in BO XI R3 with about 7-8 queries and when I run them with certain prompt values they do not return any data for any queries but this takes about 1.5 minutes.
When I run the queries individually in the database (db2) then no data fetched is returned in seconds.
What could be the issue that is making the report return the error message much slowler than from the database.I have merged dimensions inthe report but since there is no data fetched I am not sure which part is taking much time.
Any comments/ suggestions please.
Thanks,

himu1980 (BOB member since 2010-06-30)

2

Coordinate with your DBA to track each of these data providers SQL on the database. In addition to that data providers SQL’s are executed sequentially… 1, 2, 3… N.

Execution process may also take some time !!

BO_Chief :us: (BOB member since 2004-06-06)

3

Thanks , i will investigate in these lines

himu1980 (BOB member since 2010-06-30)