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.

So how does the API work? That is a JavaScript library so the basic knowledge of JavaScript will be helpful. Basically we include the API on our narrative view and then make calls to the various methods provided. The developer page has a simple example that we can use as our starting point. Please take a quick look over there before continuing reading. https://developers.google.com/chart/interactive/docs/gallery/orgchart