Remove Parent Level Nodes from Child Hierarchy Levels

Question

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

JohnW-Oracle · Accepted Answer

Hi @Cameron_Ross

You cannot modify an OOTB Hierarchy in the way but you could create a Custom Hierarchy.

See: https://blogs.oracle.com/analytics/post/create-a-custom-alternate-presentation-hierarchy-in-oracle-fusion-data-intelligence

Regards,

John