Skip to Main Content
IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


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:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


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


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


Status Not under consideration
Workspace Planning Analytics
Created by Guest
Created on Jul 13, 2021

PAW - Subset behavior

PAW can only refer to an element name of a subset and not to index .


If in a paw book we use a named subset that presents the current month , for example MAR from a subset that contains MAR FEB JAN

if the next month we update the subset with APR,MAR,FEB,JAN, PAW books stills open on MAR when it should open on the first element of the subset: APR.


If we use MDX subset based on cube values, it can works but with some dowsides. A major one is it display error pop-up in PAW view if MDX is empty. It would be great to be able to desactivate these pop-up (user parameter for example will be esmpty first time they connect).


Needed By Yesterday (Let's go already!)
  • Guest
    Reply
    |
    Mar 16, 2023

    Guest: a selector with an MDX that looks at the Global Settings cube, is not the solution. The MDX is correct but even after a refresh of the PAW dashboard the previouly selected element remains visible. Not the element at index 1 of the subset. Someone has to go to each sheet in each dashboard to have it correct, a ridiculous waste of time and effort. Please IBM, have this corrected, it is blocking customers in a lot of instances ! Maybe an optiobal toggle to take an element index like SUBNM ?

  • Guest
    Reply
    |
    May 3, 2022

    Responding with a late comment, but perhaps this is useful.
    on the first point about managing the member that is shown from a subset - the most common approach I see for this use case is to utilize a lookup. By lookup I mean specifying in an MDX expression to show a lookup from a "Global Settings" cube where many Finance cycle members (ex: Current Year, Current Month, Forecast Start Month) are maintained for the model. This would avoid an empty subset result. This would also avoid a dependence on Index which in my opinion is not best practice since indexing is not always tightly controlled.

  • Guest
    Reply
    |
    Nov 5, 2021

    Hello Stuart,


    Thanks for your reply. I don't hink it is the right place for feed back answer because the lack of visibility.

    Anyway I understand your point, it can be very confortable to not change a default value all the time. However there is many cases where it is. Typically changing month or budget phase in financial application is the same requirement in pretty much all application as explained in PA community here.

    We manage to have a workaround by saving books with an out of scope element but it means to create or keep dummy members for each book modifications...

    A second linked subject is error popup. We really like to be able to desactivate them. We have some cases where we want a blank selection, for example when it is a salary selection (pretty impossible to put any default value here). That is not only anoying but really confusing for users. They think something wrong happend or the tool is broken... I have the feeling it would not be hard to add an option to desactivate them.


    Best Regards,

  • Admin
    Stuart King
    Reply
    |
    Sep 9, 2021

    I can reproduce the behaviour described in the description. However, I'm not sure if this is something we want to change. The view in Workspace remembers which subset is used for each hierarchy on the title axis of the view. It also tracks the currently selected member in the WHERE clause of the MDX statement for each hierarchy on the title axis. I expect the natural expectation for many uses cases to be the member remains the same, when possible, even if the members in the set has changed. We might consider how member context could be passed to views through synchronization functionality.


    I've set this idea to under review while we do additional investigation. Additional comments about the use cases that require the member to change based on index might help.