Skip to Content
0
Former Member
Aug 01, 2016 at 08:02 AM

custom query in LOV

50 Views

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.