I have seen so many questions regarding Edit box control in Dashboard prompt for getting ‘All Choices’ like drop down list control when you have a presentation variable to carry the prompt value to a report.
To achieve this we have had enough techniques from our vast OTN and BI blogs.
As usual apart from that I want to contribute my 2 cents worth solution to our BI world.
When you set the edit box prompt value to a presentation variable in dashboard prompts you don’t have any option to set to “All choices” by default, So at this stage as we don’t have any value for prompt our report will return No results message until and unless if you have set to any default value.
So in this scenarios if we want to show the report for all values just put % symbol in Default to ->Specific value box.
Examples for Dashboard prompt:
Here % means “All values” for Edit box in OBIEE language :)
For eg: I have an answers Report with Year and Revenue columns and having a filter on Year column with Presentation variable var_year.
Now I placed these prompt and report in a dashboard page. By default my report is showing full data without filtering i.e. our prompt is giving all values to report.
That’s it by default our prompt is sending all values to filter.
Hope it helps you..