Hello everyone,
Would you please let me know how to specify the LOV in @prompt of a Webi report which is created using Free Hand SQL?
For test purpose, I tried to create a report using the efashion-webi connection, with the below sql.
select state, city, shop_name from outlet_lookup
where state = @prompt('Enter State','A',,mono,free)
How do I specify the LOV here? I can't use a LOV from data foundation or business layer, as this is free hand sql. Please help.
Thanks,
Mahboob Mohammed
There is no option to display LOV's in Freehand sql as you cannot reference any universe object, or a LOV of a universe object.
you can pass static LOV's but can not display from any object.
other option you can try to add one more query in the webi report and define the same pormpt definition from any universe to display.
Thanks Amit for response! Great idea, I'll add another query (dummy), which displays LOVs. I'll keep you posted.
Mahboob Mohammed