Skip to Content
author's profile photo Former Member
Former Member

Live cache to APO BW timing issues

Hello,

I have a question regarding the time it takes to copy data from Live Cache (LC) to APO BW. Say we upload 1000 CVCs (10,000 records) from flatfile into LC directly (takes less than 2 minutes) and copy this data into APO BW.Currently there are 200,000 CVCs and it takes around 50 minutes to copy from LC to APO BW. Will there be any reduction in the time from LC to APO BW if we reduce the number of CVC s from 180000 to 50%, 75% (90,000 or 45,000).

No operation(drill down, macros) are done in APO currently. We need to only know if LC to APO BW has any impact on CVC reduction.

Really appreciate your inputs.

Thanks,

Sai.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2012 at 05:48 AM

    Hi

    CVC reduction will not help in reduction in time.

    Request your basis team to put a trace on the transaction. This will give you the split for various activities like direct read,sequential read etc and you may get the bottleneck activity.

    Parallel processing profile can be useful.

    In case you are already using it, please check how many parallel processes are getting invoked during this activity. The greater the number the lesser the time.

    Also if there are parallel jobs running in the system, it can lead to resource crunch.

    Thanks

    Amit

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 03, 2012 at 10:32 AM

    Hi Sai,

    I could not understand what you mean when you say that you copy data from APO livecache to APO BW.

    No of CVCs would be directly linked to the time that would be needed for any kind of data transfer. The more the data, the more time it would take and vice-versa.

    regards- Pawan

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Sai,

      So it's clear now to me that you are talking about time for extraction of planning area data from APO into BW.

      The extraction normally does take quite some time. 40 mins is not huge in my understanding considering that you would also have some routines in BW extraction. (Time also depends on free processes available in APO and in BW for your data extraction)

      If you want to reduce the time, then you could do the following:

      1) Have 2 separate data source for APO planning area - one corresponding to history related data (time horizon in past), and the other relating to forecast horizon in future (time horizon in future). In the respective datasource, only select the Key Figures (KFs) relevant for that horizon, e.g. for past. select KFs like forecast, past promotions, history adjustments, etc. Similarly for future data source, select KFs like stat forecast, forecast adjustments, consensus forecast, etc.

      In the extraction data source, you could specify to "ignore zero values". So, if your KF value is zero, that particular record would not get selected for extraction. This helps in reduction of data volume for extraction, and hence overall reduction in time in many cases.

      2) Discuss with BW ABAP persons. There are some possibilities that they can optimize your BW routines for better performance using ABAP good practices.

      Thanks - Pawan

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.