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 (

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 ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Data & AI Roadmaps ( - Use this site to view roadmaps for Data & AI products.

IBM Employees should enter Ideas at

Status Future consideration
Workspace Planning Analytics
Created by Guest
Created on Jul 12, 2022

Format Aggregation calculation as a Parent

(See attached file to view screenshots)

Idea Details: Use a real-life scenario to explain the problem statement/pain points,

PAW allows users to create calculations that aggregates several members (or the content of a subset). However, the created calculation appears as a “regular” member within the cubeview and not as the “parent or total” of the members that constitutes the sum.

State your current workaround

There’s none in PAW. The alternative is to do it in PASS through the UDC feature (otherwise known as “Custom rollup” or “Subset within a set”)

State any proposed solution

Within the calculation prompt, introduce a tick-box under the “Aggregate” calculation type to show the calculation as a parent (Aggregate is the only calculation where it would make sense as it behaves like a consolidated member)

With “Show Aggregate as Parent” off, the view would look like this

When it’s on, the user would see this

State the benefits/value this idea has, state # of users impacted and how often are they impacted)

This enhancement would allow user to have a visual cue to quickly identify the total as it would be shown as the parent. It will also allow easier manipulation when the user wants to see or hide the detail of the calculation

Needed By Yesterday (Let's go already!)
  • Admin
    Stuart King
    Oct 4, 2022

    Updated status to future consideration. Although this idea is not on the current IBM Planning Analytics roadmap we will keep it in the idea backlog and reevaluate at a later date.

    Note that we intend to provide additional flexibility around formatting for different row and column types in the modern PAW cube viewer. This will include formatting options for the member or calculation name as well as the calculated data. We could conceive of a conditional format being configured by the book author that would apply to all calculated values, as well as manual formats for specific calculations,