Disable 'Search' option for some prompts

Sagar Tippe

Hi,

I have 10 prompts on my dashboard from which 4 are coming from fact table (contains hundreds of millions of rows). When user clicks on Search button, it generates a query just to slow down the DB instance. From Usage Tracking data, I can analyse that it is near about 50% of the total time consumed by the actual report queries..

Is there any way, (Java Script / Configuration files change, etc) to disable that search option for particular prompts?

Thanks in advance.

Sagar Tippe

Gianni Ceresa

Hi,

As far as I remember 11g (don't have one in front of me right now) it's not something you can manage in the UI and for sure (I would say) not a per prompt setting where it's available for few and disabled for others.

Your problem I would first say it would be better solved by design: have a different design of your model.

If you have prompts on a table column having with hundreds of millions rows removing the search will not really change a lot as the number of values the prompt is displaying is really limited and so you risk to miss values.

If your column would be indexed or things like that it's not supposed to be as slow.

So ... is the current design really the best one from a dimensional modelling point of view?

You can for sure play with JS to hide the "search", but it's handmade code requiring maintenance at each update/upgrade to test and retest if it still works the way you expect.