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

Dashboard prompts taking too long

Received Response
82
Views
5
Comments
ForSly
ForSly Rank 5 - Community Champion
in Oracle Analytics Cloud and Server

Summary

Dashboard prompts taking too long

Content

I have a  dashboard prompt that is taking too long to populate list values, the column is index and it seems to happen on one specific prompt selection, i have tried everything under the book but still not getting any resolution. anyone else that has come across this issue?

Answers

  • ForSly
    ForSly Rank 5 - Community Champion

    I have changed the order of the prompts so that each prompt filter filters data based on the filter above it, i have recreated the indexes for the columns and still having same issue.

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach 
    3337789 wrote:i have tried everything under the book but still not getting any resolution

    Like what? What have you tried? We can't know what "book" you mean and what it contains...

  • ForSly
    ForSly Rank 5 - Community Champion

    I dont have access to log file but i can look at SQL execution. what should i be looking at exactly on the SQL execution?

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    Well the explain plan...

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    Have you looked at the log files? Checked the exact SQL and execution?