How to display searching message while Direct Database Query based analysis?

Question

Hello,

Wondering if anyone can suggest some ideas to let users know that the Direct Database Query based analysis is still running and they should stop clicking 'Apply' button in dashboard prompt section.

We are using on-prem OBIEE 12c.

Thanks

Amit

Steve F-2 · Answer

Thank you for the video demonstration.

I observed all the different filter/prompt combinations took no longer than 4 seconds to return. Perhaps, you have others that take longer. The simplest solution is what Gayathri mentioned. I wouldn't mess with JS customization, myself, the maintenance costs of backing up and reimplementing when patching could be time consuming and will not carry over when you migrate to OAC, or may not carry over when you update to OAS.

Gianni Ceresa · Answer

(Many) Years ago, I remember having seen a thing where you could define a piece of javascript executed when "apply" was pushed and before to execute the query or something like that. I just don't remember if it was OBIEE 10g or 11g.

As you are on OBIEE 12c, it could maybe still be there if it was 11g (while if it was a 10g thing it's maybe gone).

I just can't remember a name, resource, or keyword to search for it. But maybe somebody else remember something about executing a script when submitting a prompt. Can't remember if it was executed in the background or frontend.

As an alternative thing, what you could do is a purely javascript hack: with javascript & CSS you hide the "apply" button, display your own "apply" button that will execute a piece of JS when clicked. Your JS will disable the button, submit the prompt (simulating the click of the real "apply" button, it's there even if hidden and you should be able to submit it by JS), and then waits to check if the result is loaded before to re-enable your "apply" button.

Will it work? Absolutely: OBIEE is just a webpage. Is this a simple "click here to enable" option? Not at all: you have to code it and maintain it yourself (OBIEE 12c comes with some JS libraries available making your life easier, but it also has a fairly rubbish HTML with tons of JS events attached to many objects, therefore you could easily break a default behavior if you aren't careful).

GayathriAnand-Oracle · Answer

I am not sure what fix you are looking for because this is just the DDR taking longer to start displaying results. You could re-evaluate to see if you can use a subject area based report instead of DDR report where you can see the spinning sign to indicate to end users that the query execution is in progress. You could add a narrative view with help text to let users know that it takes 5-10 secs for results to refresh, do not click Apply more than once. Other ideas welcomed.