Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to create a hierarchical org chart visual from BIP Report?

Question
11
Views
0
Comments

We have a DFF on Departments called Dept Level - represented in the yellow node.
There are cases where some level is missing, e.g. CCD has a L5 dept TTT underneath, and there is no L4 dept.

We are using BI Publisher data model which combines DFF and Dept Tree to get the 'custom' hierarchy

How can we build a visual like the one shown above?