Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 13 at 09:38 AM

    Login in the Data Federation Administration tool and watch the behaviour of how query is running.Front end may be it's single query but DF tool give idea actually how the query running .how many query DF is executing before concluding final results.

    You can compare the behaviour of both queries.

    Add comment
    10|10000 characters needed characters exceeded