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

User_6BLTJ

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

SteveF-Oracle

Hi Amit,

I "assume" that only a minority of the population have the Direct Database Query permissions. Can you just communicate/train the users?

Additionally, can you provide more details such as screenshot flows, short video recordings, etc. We are unable to see the same screen of the users that are encountering the issue.

User_6BLTJ

2025-01-28_13-32-23.mp4

Here is the quick video of the report how it's working currently. Due to the lag between clicking apply button and new results display, users are sometimes getting confused whether the apply button is working or not.

I agree it's user training issue. However, if there is any easy fix then I wanted to try so that it improved user experience.

Appreciate your response.

GayathriAnand-Oracle

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.

Gianni Ceresa

(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).

SteveF-Oracle

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.