Add an item to LOV

[former_member402770]

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

[mhmohammed · Accepted solution]

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