An Oracle blog about PeopleSoft Technology

Timeline Visualizations for PeopleSoft

Guest Author

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?

  • Pivot Grids are the easiest to implement. First, create a multi-dimensional query. Second, publish that query as a Pivot Grid chart.
  • Another option, one that has been around since PeopleTools 8.46, is Pagelet Wizard charts. These charts also run against queries. They are not as full-featured as Pivot Grids but may have performance advantages.
  • Leverage the PeopleCode charting API. We can chart data similar to Pivot Grids using the same charting libraries but using Rowsets and other PeopleCode objects.
  • Implement Oracle JET. Oracle JET is a JavaScript library published by Oracle and embedded in PeopleTools. It is the charting library used by PeopleTools and offers visualizations beyond elementary charts.
  • Implement a different JavaScript charting library, such as D3.js. This option happens to be one of my favorites as it offers unlimited visualization opportunities.

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?

You need a visualization to understand the relationships between effective dated rows. At OpenWorld, we showed hundreds of users how we plotted effective dated job data to visualize changes between effective dates. We used features, such as HTML, JavaScript, CSS, PeopleCode, and Related Content, that are available to early 8.5x tools releases.

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. 

We documented the entire process on our YouTube channel and created a unique Playlist specifically for our Oracle JET timeline series. Watch the series now!

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.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.