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