Skip to Content
avatar image
Former Member

Data extraction & source system performance

Dear Experts,

I have a ECC as source system in APO BW

And there is this hypothesis .

"Frequent scheduling of data loads from infosources to infocubes MAY put load on ECC system".

e.g. I have a datasource for extracting sales data. I decide to extract sales data everyday. Lets say I use a datasource readily delivered by SAP.

- Does this cause performance issues in ECC ?

- Is this really the case that scheduling of data load to data targets in BW makes queries on SD tables and hence can cause unwanted locking of data?

- What is the right way of explaining this phenomenon to someone who has never heard of APO and BW ?

Thanks

Guru

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 17, 2012 at 04:03 PM

    Hi Guru,

    Your hypothesis is correct.

    Any data request originated from BW system involves with execution of few tasks in the data source system (for instance ECC). Typically execution calls involve data pull from different source tables and populate the extraction structure (i.e. data extraction and accumulation) and qRFC or tRFC calls (i.e. prepare data for transfer).

    Probably, your Basis and BW administrator teams can collect the execution times and data volumes by activating execution trace. It will give you the required evidence to prove your hypothesis.

    Sales data extraction structure will be updated in real time and BW system pulls the data during off peak hours once a day.

    Thanks,
    Rajesh

    Add comment
    10|10000 characters needed characters exceeded