Business requirement to have User-Defined Hierarchy Support for Multi-Parent Parent Relationship

We are implementing Oracle Demand Management and have a business requirement to aggregate demand across custom levels: Brand, Geo, and Channel, with Brand being the highest level, followed by Geo, then Channel, and finally Item.

To meet this requirement, we attempted to build a User-Defined Hierarchy using the standard FBDI template. However, during testing, we observed that Oracle does not allow a single member value to exist under multiple parent values within the same hierarchy level.

This presents a challenge for our business scenario, where:
• A single item can belong to multiple Brands.
• An item can be sold in multiple Geographies.