At OpenWorld 2019, Paco Aubrejuan introduced Kibana Data Visualizations for PeopleSoft. Kibana Visualizations are impressive and powerful visualizations rendered from Elastic index data. Visualizations increase a user’s ability to comprehend information much more than just reading facts and figures. Kibana visualizations are great if you are at 8.58, but what if you aren’t? What if you still run 8.42 through 8.57? You need visualizations too! So, what are your options?
Interestingly, these alternatives have been around for a very long time. In fact, most of these options are available to customers still using PeopleTools releases as old as 8.42. And these options will continue to work with PeopleTools into the foreseeable future.
The point of visualization is to help us understand data, find relationships, spot anomalies, and correct or capitalize on change. Perhaps the most difficult data to visualize is effective dated data. When you open an effective dated component, you see current and future dated rows, but not historical rows. So how can we visualize the number of historical rows? What is the relationship between each of those historical rows? What happened at each effective dated change? What is the gap between those changes?
Our solution uses Related Content to add a chart to a delivered HCM Classic component, in this case, Job Data. We implemented the Related Content as an iScript, allowing us to combine Oracle JET’s timeline visualization with PeopleSoft data. We then related the iScript to the component through Employee ID and Employee record.
Guest blogger Jim Marion--
Jim J. Marion, CPA.CITP is an Oracle ACE that serves the PeopleSoft community as a Master Trainer for JSMpros, an Oracle partner specializing in PeopleTools training. Check out JSMpros.com and learn expert solutions from the team at JSMpros.