ODP DataSource in SAP BW - data preview very slow

[former_member621212]

Hi,

I've successfully created an ODP source system in SAP BW 7.4 and replicated a number of DataSources from our SAP ECC system.

When I double click on the DataSource in SAP BW, there's a tab named *Preview*, which allows me to preview data from that DataSource. I entered 30 in the 'No. of Data Records' field and hit the 'Read Preview Data' button.

I noticed that the preview can take a very long time (several minutes) till data is shown. This seems to depend on the size of the underlying tables the DataSource is reading data from in SAP ECC.

The preview effectively calls function module RODPS_REPL_ODP_READ_DIRECT_XML in SAP ECC.

Even when calling that function module directly in SAP ECC in SE37 with the respective parameters, it takes a very long time, as well, till data is returned. So I suspect, it's less an issue with SAP BW but more with above function module?

This also happens on one of our newer HANA based ECC systems.

Anyone else seeing this behaviour? Any idea what can be done about this?

I would expect a preview to return data within seconds, rather than minutes.

Thanks.

Y

[former_member621212]

Hi,

thanks for your response. No, the bad performance is with *preview* only, regular data extraction works okay.

I assume the issue lies with RODPS_REPL_ODP_READ_DIRECT_XML. This one seems to be used for preview but not for regular data extraction.

Thanks, Y.

[former_member302041]

Hi,

Is the problem with "preview" only or you have bad performance in loading as well?