[OBIEE 11g] Presentation Variable To Prompts In 11g

  

Presentation variable to prompts in 11g

When we are using Presentation variables, Prompt functionality is very limited. One of those is using option 'All Column Values'.Here I'm trying to depict a Tip to make use of option 'All Column Values'.To demonstrate the same here I'm defining a Presentation variable as '' using Page or Dashboard Prompt.

When I select 'All Column Values' we see the report with 'No Results' message as shown below since the criteria is not set properly

Use the below case statement to so that the condition matches as shown in the image

<COLUMN> LIKE (CASE WHEN '@{U}{}'='' THEN '%%' ELSE '@{U}' END)

On the Dashboard page, the prompt with option 'All Column Values' is selected and the report results are as below