Analytics Software

Hello,

Using obiee 11.1.1
I created one presentation variable in the prompt using sql results.

Using that prompt in my anaysis.i..e which i am using in the filter.

Initailly when i run the dashboard since no value is selected from the filter its shows no results found
No Results
The specified criteria didn't result in any data.
This is often caused by applying filters and/or selections that are too restrictive or that contain incorrect values. Please check your Analysis Filters and try again. The filters currently being applied are shown below.


M_NAME is equal to / is in VarMName

Whar i want is
scenario 1->what to do so that the No results found msg should not come and just the filter should be displayed.
or
scenario 2-display all the values of filter in the report initially i.e. as though one has selected all the filter value.
or
scenario 3->By default select one filter value and show result for that.

I want to know how to do the 3 scenarios?

Thanks