Skip to Content
SAP BusinessObjects - Semantic Layer

@PROMPT with ALL key word

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,

SAP BusinessObjects - Semantic Layer
0
Add a comment
10|10000 characters needed characters exceeded

author's profile photo Former Member
Former Member Nov 20, 2010 at 07:48 PM

0

86

Actions

1 Answer

Sort by: by:
author's profile photo Former Member
Former Member Answered Nov 20, 2010 at 10:23 PM
0

It takes all values from the LOV and, as you point out, this will lead to poor performance when using the prompts. It's recommended best practice to specify a custom LOV in the Webi query prompts rather than simply using the default.

Add a comment
10|10000 characters needed characters exceeded

  • Former Member
    Nov 21, 2010 at 05:02 PM

    Thank you verymuch for your response.. I think the best way to use OPTIONAL prompt from the reporting side which supports from XI 3.1..

    The Optional PROMPT in the reporting would be nullified rather using all LOVS.. Please confirm if I am wrong. It increases the performance.

    Thank you,