This content has been marked as final. Show 2 replies
The obvious general answer is that the value that is being used to filter the column has no match. Try doing this:
1) On the column that will receive the dashboard prompt presentation variable, click on the fx button.
2) Apply the TRIMBOTH function and for the char, use a space (single quote, space, single quote).
3) Click the filter button on this modified column and set it equal to the PV.
Sometimes the column contains a leading or trailing space in it. No problem if you just display all values and hard to tell why filtering for a value known to be in the table results in "no results." Often the extra space is the culprit. Try it.
But still it is giving same error.Iam using combined request using union as set operator.
Is there any problem with combined request?
Though it is having data when we select particular value it is throwing error.
Could you pls suggest me here