BusinessObjects Board

@PROMPT with ALL key word

building semantic layer
#1

Hi,

When we use @PROMPT with ALL keyword users either can ENTER “ALL” or SELECT values from the LOVs. I am interested on when users enter “ALL” how business objects will interpt this syntax.
Since we do see the “ALL” in the where conditions list ( IN THE generated SQL), how BO knows to bring all values back to the results?

  1. Either will completely ignore this prompt ( sine no “ALL” valid KEYWORD in the database level)
  2. Or It will apply IN LIST (ALL VALUES FROM THE LOVs)

I am searched in most of the forums and I couldn’t get the answer for this, It would help for anyone to avoid usage of ALL for performance reasons… If you have any idea its really a great help. Thanks in advance???

I appreciate your prompt response…

Thank you,

s_iska (BOB member since 2009-08-21)

#2

If you are on XI R 3.x you can make the prompt optional, which will be equivalent to selecting “All”.

If you are in an older version, you can build the logic using the @prompt function. There are plenty examples in this forum.

I hope it helps

J.C. :us: (BOB member since 2010-09-21)

#3

Please read this and this.

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

#4

Thank you, I clear my doubt.

s_iska (BOB member since 2009-08-21)