OBIEE Report is generated on the dashboard sometime after the session is finished

Question

Hi all,

I have an OBIEE dashboard report (OBIEE 12c) which is consuming data from a Global Temporary Table. Here is the flow.

1) Call the stored procedure in the "Execute before Query" in connection pool

2) Stored procedure populates a temporary table

3) Dashboard report consumes data from temporary table.

This logic is working fine. However sometimes the dashboard repot is running for very long time and when I checked the session logs, the session is already finished. But the Dashboard report is taking some more time to come up. At times the dashboard report runs for ever.

Any pointers on this issue is greatly appreciated.

Regards,

Dj

ArijitC · Answer

Is there a graph , Chart involved in the dashboard with flash ?

Does it have a report level aggregation?

Did you Check this in different browser like chrome etc ?

Is the data volume same in both cases when it runs and when it does not ?

Thanks

Arijit