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
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
<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
Till Next Time.....
No comments:
Post a Comment