Advanced UBE performance analysis for JD Edwards

I'm finally starting to close the loop on something that has interested me for a long time, that is batch performance from a holistic point of view.  This is having granular statistical information on a job by job basis, but also having the ability to do macro analysis.

I've done lots of posts over time (search for F986110, F986114) on using advanced database queries to view jobs and data.  Today I'm going to post on something much more intuitive and visually attractive for batch performance analysis.  

Today I want to show you how I've used data studio from google to slice and dice UBE job performance data to show at a high level how things are running and give you the ability to drill down on very specific data.

Sample UBE batch dashboard, showing rows processed, execution time and # of times run

This has been a challenge for a long time.  I've seen various plugins and attempts, but I think what Fusion5 have put together is pretty neat.  Please watch the video at the bottom of the screen as a demonstration of the types of operations you can do over your batch information.

I guess there are a couple of key points:

loading the data

There are two mechanisms for doing this,

1. public facing AIS server and our bespoke view over F986114 & F986110 for easy insights

The fusion5 connector using AIS

Easy configuration of connector to report live on JDE data

1. Fusion5 provide you with a SQL statement that produces the exact csv of information and we upload this for you into a datasource, which you can use with the existing reports
1. Once you've seen this done, you'll be able to self serve really easily!

Viewing the data

It's easy to create reports and even easier to view the data using our pre-built reports.  I showed a teaser above, but here are a couple of additional screen shots.

Advanced filtering capabilities

Look for data points that are not normal, filter by user, job, job queue or execution host - you decide.

All of the reports that you see here are interactive, so as you hover over data points, you get feedback that is relevant to the graph being displayed.  One of the really nice features is the ability to drill down into the actual UBE runtime detail directly from the dashboards.  You'll see this in the video.

Execution detail available directly from the dashboard.

Be nice, this is one of the first video's that I've embedded.  This shows some of the filtering and advanced functionality that we are catering for.

Want some, you need to get in contact - fusion5.com.au and do some searching on first and last names...  good luck!