Skip to Content
0
Former Member
Jan 10, 2012 at 02:40 PM

Webi Prompt vs BEx Variable performance

49 Views

Hi

We are using SAP BO 3.1

We have a Webi report built on a Universe. This Universe in turn is created on top of a BEx query.

From a purely performance point of view (so ignoring other factors) is it better to use a Webi Prompt or BEx Variable?

In other words, if a Webi Prompt is used, is the select on the database restricted accordingly by the user's selection, or does the query fetch all data according to the BEx query (and it's restrictions) and the Webi Prompt is merely to limit the data displayed in the Webi Document?

Does the behaviour of the above differ from BO 3.1 to 4.0 ?

Thanks in advance

Anton