IBM Data and AI Ideas Portal for Customers

Shape the future of IBM!

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,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. 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.

Additional Information

To view our roadmaps:

Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

IBM Employees:

The correct URL for entering your ideas is:

Status Needs more information
Workspace Planning Analytics
Created by Guest
Created on Feb 17, 2021

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


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.

Needed by Date Oct 1, 2021
  • Guest
    Mar 22, 2021


    What further information do you need?