Universe on ECC SAP Query

[Former Member]

Hi ,

i created first the data base relational connection to ECC then a data foundation based on my SAP QUERY.

I created a query and after some seconds i have this error: Error on fetch data.

During this execution , in ECC one background job running that execute the SAP QUERY.

Then i try also to publish the business layer on repository and create a webi but , after the execution i have this error:

Could you help me?

Thanks and kind regards.

Andrea

[former_member4998 · Accepted solution]

Hi....

A SAP Query is created in a user group and belongs to it. Check objects of the global work area can be accessed by all clients

SAP Business Objects Business Intelligence connectivity to SAP ERP via SAP JCo. It provides access to the ABAP Functions.

There are some limitations to access the data from ERP, The JCo API does not support array fetch. This means the result data is returned all at once. To restrict the number of resulting rows and to avoid an out-of-memory issue, the application user has to filter data appropriately. Regardless of this limitation, Connection Server still applies array fetch.

The application user can also set a value to Max Rows in the Query Panel of the information design tool. However, the SAP ERP system does not take Max Rows into account if the universe defined is multisource or if the query requires computations after data is fetched (SELECT DISTINCT, ORDER BY, and GROUP BY).

The ERP Max Rows parameter of the jco.sbo configuration file allows the application user to query without filter an InfoSet or a SAP Query table that only contains numerical data type columns.

The user can also query a table containing numerical and DATS data type columns. This parameter is also used when Max Rows is not passed to the SAP ERP system. ERP Max Rows can be used with single-source and multisource universes.

[Former Member · Accepted solution]

Thank you.

the webi report created at the top of relational universe has low performance : if i execute the sap query with the same parameters, the response time is much more low.

andrea

[Former Member]

Hi Andrea

is this issue only for this ABAP Query or others too....if so this might due to Installation/integration

Thx

bose

[Former Member]

Hi,

if i create a sap query with layout in basic list form the issue is solved.

I would know if there are some limitations in the SAP ECC/ BO integration.

My BI is a 4.1 release.

I find that the performance are very low respect the execution of SAP Query source with same input parameters.

Thanks.

Andrea

[Former Member]

Hi

Did you validate ECC Query results in ECC system? If so is it running fine and showing results.

Thx

bose

[Former Member]

What means "validate ecc query result"?

in ecc the abap query works fine and return the data on different layout.

thanks

andrea

[Former Member]

Hi

Ok.are you running query from BI-Launch pad or Web-Rich client..if so could you please try with

Web-Rich client tool once

Thx

bose

[Former Member]

Hi,

with Web Rich client i have the same error: Error on fetch.

Thanks.

Andrea

[Former Member]

My issue could be related to the result of ABAP Query?

The ABAP Query that i would extract, return the data in 5 Statistics layout and not in a basic list form.

Andrea