Skip to Content
avatar image
Mahboob Mohammed

How to specify LOV in @prompt in Report created using FreeHandSQL?

Oct 26, 2017 at 12:52 AM | 196 Views

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

SAP BusinessObjects - Web Intelligence (WebI)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    AMIT KUMAR
    Oct 26, 2017 at 09:35 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded