Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 254 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 94 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Remove Parent Level Nodes from Child Hierarchy Levels
Cameron_Ross
Rank 3 - Community Apprentice
Is it possible to have Parent values in Hierarchy Tables not to show at the children levels of the node?
For example, if Cost Center Code '1A' is at Level 31, It will render as a value all the way down to the lowest level of the hierarchy. This makes prompting on Hierarchy columns extremely difficult beyond having to hardcode specific values at each level for end users. This then turns into a further issue when node level names could potentially change over time.
Thanks,
Cameron
0
Best Answer
-
Hi @Cameron_Ross
You cannot modify an OOTB Hierarchy in the way but you could create a Custom Hierarchy.
Regards,
John
0
