We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Post your ideas
Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Help IBM prioritize your ideas and requests
The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The product management team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.
Receive notification on the decision
Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.
When ProportionSpreadToZeroCells=F allow paste of multiple cells to put zero on a zero consolidation with no error
We have had issues with users entering data on zero rollups and the data being evenly spread to every child, even in intersections that do not make sense. So we were excited when we found out about "ProportionSpreadToZeroCells". It fixed the issue, however after a week we had to turn it back off. One of the issues was a defect with relative proportional spread not working, that has been fixed. The other issues was that multiple users were no longer able to copy and paste large chucks of data. If even a single consolidated intersection was zero and the copied data included a zero in the same intersection it would fail with an error.
We wanted it to throw an error if we tried to put a non zero value into a zero intersection, but not if it was a zero.
Copy From Copy To
US - CAN - MEX US - CAN - MEX
Prod 1 10 30 10 Prod 1 10 10 10
Prod 2 50 20 0 Prod 2 20 10 0
Prod 3 5 5 40 Prod 3 10 20 20
This happened when users had seeded a forecast with last year actuals, and then copied the new geo targets on top. Another user had gather forecast data from their team in excel and then was not able to past the values into PAW.
Our Workaround is to turn off "ProportionSpreadToZeroCells" and have people manually checking intersections that should not have values.
The benefit to this change is we are still stopping even spreads from happening, but users can paste in large chucks of data without worrying about zero intersections.
This was effecting 10 or so users in the week we tried to use it.
Do not place IBM confidential, company confidential, or personal information into any field.