BusinessObjects Board

All values in prompt

Hi All,

I have a prompt defined in universe something like the below code.
@Select(Organization\Division) IN @Prompt(‘Please select division’,‘A’,‘Organization\Division’,multi,free,not_persistent,user:0) or
‘ALL’ IN @Prompt(‘Please select division’,‘A’,{‘ALL’},multi,free,not_persistent,user:0)

But due to this the LOV is only showing ALL value.
Can anyone tell me if there is something wrong with this prompt.


rittu (BOB member since 2008-11-02)

The second prompt has {‘ALL’} as the LOV, and it is overriding the first prompt.

Please see this FAQ post for how to add ALL to the LOV. Thanks.


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

@Select(Organization\Division) IN @Prompt(‘Please select division’,‘A’,‘Organization\Division’,multi,free,not_persistent,user:0) or
‘ALL’ IN @Prompt(‘Please select division’,‘A’,‘Organization\Division’,multi,free,not_persistent,user:0)

this is the way to use it. Assuming you have included ALL in object (Organization\Division) definition using UNION


koilada :india: (BOB member since 2007-04-03)