If you are using an Essbase data source, you may be interested in learning more about the relationship between Essbase cubes and your Oracle BI EE platform.
It is quite common to find a dimension with multiple hierarchies in a BI project. This is managed in Oracle BI by creating a Dimension object with multiple child levels at a point that converges into the same leaf level.
This looks quite easy when the physical data source is a relational database. However, when the physical data source is an Essbase cube, the process is a bit more complex.
