- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 65 Insurance
- 536.7K On-Premises Infrastructure
- 138.4K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Dashboard prompt performance
We have one choice list prompt that is exceptionally slow. It will take over a minute to show some values.
I've tried recreating the query I expect the choice list would run but that returns the desired result in a few milleseconds.
So what I would like to do in the first place is determine what is happening when BI is loading this prompt. What query is being executed.
In the nqquery log I can see the analysis query, but not the one for the prompt.
An analysis filter you can "convert to SQL".
But for a prompt, I can't find the query anywhere.
Is there a way to find this query or another way to go about improving this prompts performance?
Been searching my n*ts off. Asking a question to the community is always my last resort.
We're on OBIEE 12c / database is also 12c.
Thanks in advance!