Skip to Content
author's profile photo Former Member
Former Member

BO Prompt - set default value with exclusion

Posted on Feb 20, 2017 at 06:45 AM 295 Views

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

SAP BusinessObjects - OLAP
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Koen Hesters
    Koen Hesters
    Posted on Feb 20, 2017 at 08:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 08, 2017 at 06:11 AM

    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
    10|10000 characters needed characters exceeded