I am using ver 220.127.116.11
My requirement is to see all data in dashboard prompt as well as there should be another item its 'ALL' which return the all data.
There is a dashboard filter on a field type (like: Value1,Value2) , our client want to see the data on filter (like: ALL,Value1,Value2) the ALL will filter the boat Value1and Value2.
Please explain with steps.
Sorry, let me put it clearly
the values from my database are as below:
but i need in the dashboard prompt the values as :
Note where "All" is not a value in my database .
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