Skip to Content
0
Apr 13, 2018 at 09:30 AM

WebI - Slow Initial Refresh - Relational JCO Connection ERP Infoset/SAP Query

120 Views

Hello WebI Experts,

I defined a relational Connection into ERP System using the JCO.

Using then some SAP Queries in a multisource universe to do an derived table (nothing complicated) and some more join operations (also not complicated).

Situation I observe is that and intial connect of a report takes very Long about 1:30 Min.
Very small data return set (30 records). Time on database in ERP spent is minimal.

Subsequent refresh with different selections and also larger return set (and even different WebI user) are much much faster -> 0:10 Min

Any ideas how to "tune" the initial connect or how to find what the issue is or any ideas what the issue could be?

Thanks for all replies in advance,

Axel