IBM Data & AI

 Welcome to the IBM Data & AI Ideas Portal for Clients! 

We welcome and appreciate your feedback on IBM Data & AI Products to help make them even better than they are today!
Before you submit an idea, please perform a search first as a similar idea may have already been reported in the portal.  If a related idea is not yet listed, please create a new idea and include with it a description which includes expected behavior as well as why having this feature would improve the service and how it would address your use case.
IBM Employees:
  • Our team welcomes any feedback  and suggestions you have for improving our offerings / products!  This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.
  • If you have not registered on this portal please click on the following link and register.  To complete registration you will need to open the email you will receive from Aha to confirm your identity.
Additional Information:
  • The shorter URL for this site is:
  • To view our roadmaps:
  • Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases
  • Please do not use the Ideas Portal for reporting bugs - we ask that you report bugs or issues with the product by contacting IBM support.

PAW Synchronise Action Button parameters with Sheet Selections

This has already been requested by four different people:

Aug-2019 PAOP-I-490 59 Votes

Oct 2019 PAOP-I-530 10 Votes

Nov 2019 PAOC-I-77 4 Votes

May 2020 PAOC-I-77 4 Votes

TOTAL 77 Votes

From browsing the list of requests, this means that this request has more votes than any other request, yet it has not even reached the planned stage.

This is absolutely critical. We are not going to even start evaluating PAW until this functionality is provided.

At present a user typically will select a cost centre, account, time period etc, review a report, and then decide to take further action, typically by clicking an Action Button, that will run a process to update workflow cubes, perhaps transfer the data to another cube, or perform a calculation on the data, build a dimension, etc.

It is clearly a very poor user experience to have to then reselect the same cost centre, account and time period that they already selected when they click the Action Button. It is also potentially error prone, and users will inevitably review the figures for one cost centre and then end up running the process from the Action Button for a different cost centre.

  • Paul Simon
  • May 21 2020
  • Needs review
Why is it useful?
Who would benefit from this IDEA? Anyone who actually uses Planning Analytics for Planning rather than just reporting.
How should it work?

1) How should it work. It should be possible to link a selection on the sheet to a parameter in the TI process behind the Action Button.

2) Some of the benefit was outlined above. It is not possible to build any sort of workflow/action based system without this. Planning Analytics is for building planning systems and not just pretty reports. They must allow users to enter data and be able to run processes to manage that data, update workflow etc. I know that IBM have some sort of workflow planned but I have not seen any details of this, and cannot believe that it will be as flexible as being able to link parameters from the sheet to TI process parameters via an Action Button. The workflow may also not allow data to be processed and moved, or dimensions to be built which can be achieved via a TI process.

We already have systems built in TM1 Web that use Action Buttons to manage workflow, copy data from cube to cube, perform calculations, build dims, etc. Even if a viable workflow facility was introduced by IBM, we would still not want to move to this immediately and would prefer to migrate the TM1 Web Sheets to PAW using the existing processes. This would reduce the need for re-training of users, re-testing, etc.

The only work arounds for this I have seen are:

a) Users have to re-select again when they run the TI process - very poor

b) Push parameters into a cube and retrieve them in the TI process - also very poor - we already have processes built with parameters - why would we want to change existing processes. I last used this approach in TM1 version 7. It would be a retrograde step.

c) Put a TM1 Web sheet on every PAW sheet, get SUBNMs on that to synchronise with the selections on the PAW sheet, and put the TI Button on this TM1 Web Sheet. If you are going to do that, it would seem that you might as well do the report in TM1 Web and not use PAW.

Idea Priority Urgent
Priority Justification Cannot build a planning system in PAW without it.
Customer Name Dept for BEIS, and at least three others
Submitting Organization
Submitter Tags
  • Attach files

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions