on 10-23-2014 8:53 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Any suggestions please?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
8 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.