Friday, November 8, 2013

[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








2 comments:

  1. Could you please change the background of your website. Cant able to read the content properly with a funky background

    ReplyDelete
  2. Could u please try to change the background .
    Thanks in advance.

    ReplyDelete