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 updateson 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,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
I tried to built a report in PAW which has three separate grids, showing Month, YTD and Full Year. These must be separate grids as the other things that the grids show are different. There is a selector at the top allowing the user to choose the month. What is shown in the Month, YTD, and Full Year Grid then needs to change according to the month.
This is a very common requirement, but is incredibly difficult to achieve in PAW. This should be made a lot easier.
I tried to do this using a web sheet using formula to derive the YTD and Full Year according to the selected Month. However, Synchronisation in PAW is not granular enough and any attempt to turn on Sync resulted in the SUBNMs on the Web sheet being corrupted eg the Month SUBNM got set to a Year. I tried arranging things so that the Month, YTD and Year all came from different Named Hierarchies but the Month SUBNM was still getting corrupted with a year.
The only option that appears to work is to use a SUBNM on a web sheet to let the user select the month and to then DBS this into a cube dimensioned by }Clients and Measures, and to derive the YTD and Full Year in Rules and then reference that in MDX subsets, which are then used in the YTD and Full Year Grids. This is far too complex a solution to a common problem
It should be possible to achieve this without using Web Sheets.
Do not place IBM confidential, company confidential, or personal information into any field.