Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Ability to hide/suppress columns if null based on the prompt selection
Dhamu
Rank 3 - Community Apprentice
Description
We are trying to create a pivot view in BI Analysis, which is having a set of columns that will either return null or values based on prompt selections. The ability to suppress the columns when it is null instead of showing entire column as empty would be better understandable especially working with many number of columns.
Use Case and Business Need
My pivot view has columns A,B and C (attribute) and X (measure).
Consider having pivot with A and B in rows section and C in columns section with X in measures section, based on the prompt selections B might return null in some cases and we need to dynamically suppress B in pivot view.
Original Idea Number: 679bee9a1e
5