From time to time I am asked by my customers and prospects who are wondered if there is any way with in Oracle HCM Cloud to represent hierarchical organizational structures in graphical views. I knew that Oracle BIEE can use Google Charts APIs to render Organization Charts and I tried to sort out the details to get the most of that technique. I also was going to figure out how to place some formatting and interactive features. let’s see what I managed to get.
Google Charts library can be utilized within Fusion HCM OTBI for visual representation of Management Hierarchies as well as Department – Position – Employee relationships.
Let me briefly introduce the steps to build Organization Charts in OTBI Analyses.
So I am going to build a Management Organizational Chart with a prompt for a top manager. Also I would like to link a report to nodes to be able to drill into linked report for every employee in the hierarchy. A linked report will show current performance goals for a given employee.
- I created a BI Analysis based on the Workforce Management – Worker Assignment Real Time subject area. I took only the five first levels of management hierarchy.
Here are the Prefix and Postfix sections:
- Finally I created a dashboard and a dashboard prompt.
You can see how it looks like on the animated video below:
That report was built in the TEST demo environment and there might be some inconsistencies I apologize for.
I hope it will be helpful.
Good luck and remember:
“You miss 100% of the shots you don’t take.” ~ Wayne Gretzky