Hi All,
i need a list of 20 product names in a prompt, i wrote a custom query in LOV and assigned that to a dimension, when i evaluate, it is showing an error as
"Failed to execute the expression of the object"
then in the SQL Definition of the dimension i added the particular column, but its not showing only the values in the query its showing all the values in the column,
how to acheive this, can any one give a suggetion.
thanks in advance,
sravya.