Skip to Content

Add an item to LOV

Hi experts,

I wanted to add "All values" as an extra item in the attached LOV object by creating an formula variable.

Can you please help with the formula change in webi

Thanks,

Dinya

capture.jpg (13.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 5 days ago

    Hi Din,

    In the DFX (Data Foundation Layer), you'll have to create an LOV based on SQL using the below SQL.

    Select 'All Values' from Dual
    Union
    Select Distinct MonthName from DateTable

    FYI: Dual can be used for Oracle. Let us know if it works.

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded