BO Prompt - set default value with exclusion

[Former Member]

Hi All,

I need to set default value in prompt with exclusion.

for example, Prompt Status is NOT EQ DEL.

If the report based on Bex, we can set the prompt default value with exclusion in Bex end. Currently I have created Webi report on top of HANA VDM.The issue is that, I have added all prompt in BO end. So I need to set this default value in BO.

As BO webi is not supporting NOT EQ prompt, I have tried in IDT Universe. But I couldn't find any option for the same in IDT.

Could you please let me know if you have any idea.

HANA VDM - > IDT Universe -> Webi

Thanks,

Angavai Elangovan

[Former Member]

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

[kohesco]

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