BO Prompt - set default value with exclusion

Question

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

Answer 1

Koen Hesters Answered Feb 20, 2017 at 08:30 AM

0

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

Share

Comment

Answer 2

Angavai Elangovan Answered Mar 08, 2017 at 06:11 AM

0

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.)