Hi,
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!
Dries