Kinetic Dashboard - Best Practices

I remember telling my clients about a year ago that until Epicor really made some strides on Dashboards, that was probably the last major hurdle in getting away from Classic. I believe the 2025.1 and 2025.2 tools available with Dashboards have been some major improvements. I’ve gotten a lot of good information off this forum as well.

Yesterday, I watched Epicor’s Webinar on Dashboard Creation, and I probably came out of that with more questions. Which leads me to this post, with multiple ways of doing the same thing, I’m wondering how the power users here are doing it. The major questions I have:

  1. Are you going into Dashboard Maintenance, deploying the Dashboard to the Kinetic Application, then creating a layer on top of the DLL that Epicor creates? Or, are you going into Application Studio, creating a new App and using the wizards to create the grid views, do the publish/subscribe, etc.
  2. Most dashboards that I’ve implemented in Classic have had a Tracker panel which really was used for criteria entry. Date ranges, part numbers, part classes, etc were optional criteria. Are you using silent parameters and passing those to the BAQ’s? Or are you creating controls, binding them to TransView, and modifying the BAQ Options to use the TransView fields?
  3. I’ve had some discussions with my team (we are cloud), and we’re a bit concerned about our users not realizing they’re often seeing only the first 300 rows. We’ve discussed turning off the options that control that, so by default our dashboard ALWAYS return all the data. The main concern here is someone makes decisions based on the 300 rows they see because they didn’t know (or remember) to click the “more rows” option. If we do that, we’re likely going to implement some “hard” coded criteria in the BAQ (such as only showing last 2 years of shipments), and making some criteria required (have to enter a date range, for example). If users ever needed to go back further, we’d consider that an ad-hoc request and have to do it as a one-off. Wondering how you guys are handling this.
  4. When I used to deploy classic dashboards, I usually put the columns in what was the most logical order, and often sized the columns to make the dashboard more readable. With the Kinetic dashboards, the way I was doing this so every user wasn’t having to personalize their screen, was I was adding a width to the columns (dates at 90, for example). How are you guys handling this?

Thanks for the feedback!

3 Likes

1: Personally, I use the template method here Insights 2024 and some free downloads! - Kinetic ERP - Epicor User Help Forum

2: Per the above those are fields on dataview SearchFilters

3: I don’t use Server Paging

4: I use Personalize columns to show/hide and arrange columns. Then size in the grid and use Save Layout

4 Likes

I agree with what @Randy says

Server paging is good if you expect a large number of results (>5000 in my experience). The results will paginate in the background as the user scrolls. The only time they will see the “more-rows” option is if they preload the data. Preloading is limited to 5000 rows.

Check out the PowerPoint from our 2024 Insights presentation. I have a few slides that describe server paging and row virtualization.

There’s also the Copy Application App I shared during this year’s Insights. Helpful when you have a template set up how you like or need to copy a dashboard that is very similar.

4 Likes
  1. I also use Personalize Columns to show/hide and order columns. I don’t usually take the time to set column widths though. The Auto Resize Columns option in the overflow menu is nice. It doesn’t seem to work for setting a default in App Studio; however, your users can quickly resize all columns at once in the dashboard. Just beware if you have a large text field–you’ll have to shrink it after or remove it first.
2 Likes

Agreed, I’ve showed the auto-resize to our users as the widths I set aren’t always what the user wants.

1 Like

You can also drag-drop columns in the grid from within App Studio to set the order.

2 Likes
  1. I always start from a “fresh” brand new app, without using the wizard. I had some trouble in the past with the wizard, causing the “Window_OnLoad” event not working, so always manual. I do not use templates (copy app), mainly because I have absolutely no confidence that my template dashboard will no be silently corrupted after an upgrade, so I always start fresh
  2. For a simple dashboard, TransView with where clause on the provider model of the grid works just fine. For more complex dashboard/workbench, BAQ Silent parameters is the way to go.
  3. Disable paging and force user to input serach criteria if there are preformance issues (BAQ Silent parameters)
  4. As other mentioned, Personalize Columns works fine
5 Likes

Interested Idris Elba GIF

3 Likes