OBIEE Hide the saved filter view link

In this article: http://oraclebiblog.blogspot.com/2009/07/how-to-hide-saved-filter-view-link.html John Andrzejek shows a way of doing this by editing a CSS file.

I prefer editing the viewmessages.xml.

Remove the text between the kmsgViewSavedFilterAnchorText tags. (you have to do this for every languages you use).

Till Next Time

Edit: Stijn found the orignal : http://obiee101.blogspot.com/2008/08/obiee-difference-between-two-rows.html

OBIEE "Combined with Similar Request" and filterview

If you use the "Combine with Similar Request"


method in OBIEE, for instance in the case of making a "DateTime" aware graph ( http://knowledge.ciber.nl/weblog/?p=93 or http://obiee101.blogspot.com/2008/03/obiee-continues-time-line.html) you will loose the filterview.
This is caused because the filterview only looks at the outer query of the UNION ALL statement:

This logically leads to "Request contains no filters
I have developed a workaround for this problem:
Open a new request with a dummy column:

The CASE when 1=0 statement prevent executing from the query so it won't use any resources.
On this request put all your "prompt"columns in the filter and set them on "is prompted"or use "named prompts" { } .
Be sure to also incoperate your "hard coded" filters!
Add the filterview to your compound layout and remove all other views:


Save your request as "Filterview" Add the request to your dashboard and now you have the content off your filter on your dashboard.

Till Next Time