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

Excel Copy paste not working after multiple drilldowns

Hi

We are seeing that when we do multiple drilldowns in DP planning books and you paste a bunch of numbers from excel, the totals are not getting updated. The system is strangely not even recognizing some of the numbers pasted, even though they are still displayed. When we save and refresh, these numbers not recognized disappear and the numbers counted into totals before stays.

Example:

We have a region named NA100 that has 2 plants and each plant has 2 materials.

We load region NA100 into DP planning books, then drill down to both plants, copy from excel and paste 1000 and 2000 as forecast for each plant. The system counts these into totals and show the Total for both plants as 3000 at regiona NA100 level.

But if I drill down another level to materials: now I have region NA100 - Plants 1 and 2 and each plant has 2 materials ( total 4 materials). Then I am copy pasting forecast for the 4 materials, let's say 100, 250, 300& 400 at the lowest level and press enter or save, the system is inconsistent and is not always considering all 4 numbers into totals. Some time I am seeing only 350 taking 100 and 250 into consideration, even though the system displays 300 and 40, it is not counting them into totals.

Has any one seen this behavior? This looks like a bug but could not find any SAP notes directly addressing this...

Thanks,

KP

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 28, 2014 at 01:32 PM

    Any suggestions please?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi KP,

      You can try using the upload functionality which is there in Interactive planning book to upload the keyfigure values from Excel to Planning Book.

      This way values will get uploaded and aggregation/disaggregation will take place at correct level as per the configuration in planning area.

      Regards,

      Alok

  • Posted on Oct 29, 2014 at 12:00 PM

    Hi KP,

    Can you provide your system version, Enhancement pack number and SP level? It may be helpful.

    Did you first download an Excel file from the DP planning book to make sure the syntax and format is correct for the upload?

    The following SAP Notes may be helpful:

    1404581 Unexpected values after Excel upload to planning grid
    1600340 - SDP94 - uploading from file fails
    1777321 - SDP94: Excel upload is not working

    Best regards,

    Mike

    Add a comment
    10|10000 characters needed characters exceeded

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.