- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Dashboard prompt and user defined filter?
edited Oct 1, 2008 5:57PM in Business Intelligence Suite Enterprise Edition (OBIEE)
Do anyone know if it is possible to add a defined filter to a dashboard prompt - for instance a dropdown (to limit values in dropdown)? The idea with the filter is to reuse it (and maintain it one place) several places.
In the "Show" field of a dashboard prompt, change "All Values" to "SQL Results." Add the filter as a WHERE clause then save the prompt as a shared prompt. Other report designers can then use the prompt which would have the filter already defined and it is in one location so maintenance is easy.
Just to clarify - can i add a reference/name from a filter in the where clause?
Thanks a lot for fast reply and your interest.
No. You would actually have to define what the WHERE clause would be. Can you not define your filter using a WHERE clause? Why is it necessary for the filter to have a name to reference? I believe there is more to your question than what "meets the eye."
The reason why i want to reuse the filter (if it was possible) was to use it both in dropdowns but also in answer reports (based on filters). And again if it is a filter - it's possible to show the filter on a page as well - as in information.
Okay, then do this:
For dashboard prompts, do what I outlined above. For use in Answers, create a Saved Filter which you can use over and over. Granted it is now two places that you have to maintain, but it is still better than recreating the filter parameters from scratch every time you need it.
This discussion has been closed.