BusinessObjects Board

How to get 'ALL' to show up in list of values?

building semantic layer
#1

Hi, I have a problem I hope someone can help me with. I have made up a prompt/condition in the designer that should allow a user in webi to select ‘All’ or mulitple processing plants. The prompt behaves the way it is supposed to, but instead of offering ‘All’ as a choice in the list of values, the user has to type in ‘All’. Here is the code in the condition. How can I get ‘All’ to be displayed with the other values in webi? Thanks for any help you can give me.

’ ALL’ in @Prompt(‘Select a Plant’,‘A’,‘Filter Only Objects\Processing Plant’,multi,free) or @Select(Filter Only Objects\Processing Plant) in @Prompt(‘Select a Plant’,‘A’,‘Filter Only Objects\Processing Plant’,multi,free)

fdfjc (BOB member since 2009-03-10)

#2

Welcome to B :mrgreen: B!

Check this topic.

Jansi :india: (BOB member since 2008-05-12)

#3

Check the Designer FAQ. 8)

#4

Hi
This is analogous to ur requirement.Try this.
Product.Prod_nm=@prompt(‘SELECT Product or ALL’,‘A’,{‘ALL’,‘P1’,‘P2’,‘P3’},mono, constrained)
OR
‘ALL’=@prompt(‘SELECT Product or ALL’,‘A’,{‘ALL’,‘P1’,‘P2’,‘P3’},mono, constrained)

shilps (BOB member since 2005-06-28)

#5

Thanks so much Jansi, the solution in FAQ worked. I appreciate your help.

fdfjc (BOB member since 2009-03-10)