Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
1
Views
1
Comments
user10995416
user10995416 Rank 2 - Community Beginner
edited Aug 13, 2024 5:54PM in Oracle Analytics Cloud and Server

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

Answers

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    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