We are in need of help.
We have a performance problem in a universe BO that on top of a BW query.
The BW query contains many variables and exit as well, but runs in 1 minute and returns just over 3500 lines, but the reports WEBI we take over the universe more than 25 minutes each to run.
We did some tests, for example, create a WebI with few features on the same universe, and the result is that this report runs quickly.
As we increase the amount of features in the report, the performance drops.
The flag "Use query drill" in the properties of the report was marked, and remove it even after the performance has not improved much.
Also changed some parameters of the universe (JOIN_BY_SQL, persistence of the connection), but had no gain in performance.
Does anyone have any suggestions for what else can we try?
this is a frequent question, please check Ingo's suggestions here:
Surely will help