Hi,
if your list of values is limited you can create parameter lists in your universe.
for example if you have 4 values :DEL, ACT, CHA, UPD
, you can set lists like not del (ACT, CHA, UPD) if the user set not del, the filter is include ACT CHA and UPD.
SO your parameter list is:
not DEL, not ACT, not CHA, not UPD
adding some logic to the universe will achieve your solution
Koen
Hi Koen,
Thanks for your reply.
I have created formula field in IDT to set the values for NOT EQ in BO as the BO is not supporting NOT EQ/ exclusion for default values. Now it is working fine.
For example, (Formula variable) Status= if Status <> DEL, Then "!DEL" Else DEL. Then I have included this variable in BO prompt & set default value as =!DEL.
I have added original field in input control for showing the values (what are all the status in !DEL, if user want again they can make their selection in input control.)
Thanks,
Angavai Elangovan
Add comment