Skip to Content
avatar image
Former Member

WEBI prompts and Filtering

Hi all,

I am new to BO and I am working in BO XI R3.

I have to create a WEBI report which will have two prompts.

1.first prompt is based on AMOUNT column in my report eg: Amount(LOV): $55000

2.second prompt is not based on any column in the report or universe. but it should accept the value from the user eg: Range value: $3500

The result should show all the rows that are having Amount>= $51500 (i.e $55000-3500) and Amount<=$58500 (i.e $55000+3500)

Can any one suggest what steps I need to follow in webI or designer to get this type of results.

Thanks!

Edited by: undefined on Dec 14, 2009 5:07 AM

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 14, 2009 at 05:11 AM

    Hi,

    This can be done in the following steps:

    Create two prompts which will ask for the input from the user. You can create prompts at the report level or universe level.

    Say the prompts string are : Enter Amount and Enter Range.

    Now at the report level retrieve the two user response in the two separate variables.

    v Amount = ToNumber(UserResponse("Enter Amount"))

    v Range = ToNumber(UserResponse("Enter Range"))

    Now create two more variables as:

    v Max Amount = v Amount + v Range

    v Min Amount = v Amount - v Range

    Now apply the global filters on the Amount as Amount <= v Max Amount and Amount >= v Min Amount.

    Note: you need to take care of $.

    Regards,

    Rohit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 14, 2009 at 02:17 PM

    Hi,

    As rohit said you can create two variables and assign the prompts to them. Same for validating also.

    For your requirement I think creating prompts at report level is better.

    Cheers,

    Suresh Aluri.

    Add comment
    10|10000 characters needed characters exceeded