This content has been marked as final. Show 7 replies
Maybe you have not understood what has been said above?
You will get "All column values" displayed at the top of your list of values. If you want to change the label of this to simply "ALL" then you will need to edit the XML files found in <MW_HOME>/Oracle_BI1/bifoundation/web/msgdb/l_en/messages/
You have to go with SQL Results in the prompt something like below.
The 2nd statement can be other way so that its return all values..
Make sure that similar you have in report too so that you get all values for ALL
SELECT COL1 FROM "SA"
SELECT CASE WHEN COL1 IS NOT NULL THEN 'ALL' ELSE COL1 END FROM "SA"
instead of not null you may go for like '%'
if helps mark