BusinessObjects Board

using ALL in prompt

building semantic layer
#1

Hi All,
I have a prompt which have list of ten values like a,b,c etc. User can select multiple values and run report. I want to add one more values in the list of values called “ALL” so that when user select ALL, the report generates result as if user select all LOV individually. I mean to say, user can to select only “ALL” , if he wants to see report with all prompt values.
I am in BO Xi3.1 Your help will be appreciate…
Thank you

alex1234 (BOB member since 2010-09-14)

#2

Hello,

Here we go. I assume you have object city which displays 10 cities and you want to add ‘ALL’.

  1. Edit existing City LOV query from universe and below statement:
    select sitinct city from Customer union select ‘ALL’ . Pasre the query and select option ‘Do not generate SQL before running’.

This will all ‘ALL’ in your City object LOV.

  1. Create prompt with below def:

@Select(Customer\city) in @Prompt(‘Select city’,‘A’,‘customer\city’,MULTI,FREE)
or ‘ALL’ in @Prompt(‘Select city’,‘A’,‘customer\city’,MULTI,FREE)

So when you run the prompt, if user selects any city, then sql would be like:
select US from US or select ALL from US

And if user selects ALL, then statement is like:
select ALL from city or select ALL from ALL

Hope this helps you :smiley:

chinmay1383 :india: (BOB member since 2010-05-11)

#3

The entire answer is covered in the FAQ (I wonder why that is… :wink: )

Allowing a user to select ALL in a prompt

Adding ALL to a LOV

Dave Rathbun :us: (BOB member since 2002-06-06)

#4

Thanks a lot

alex1234 (BOB member since 2010-09-14)