How to build a simple Kinetic dashboard step by step

After reading the Application Studio User Guide, and working through all the training material available on the Epicor Learning Center, I found myself still struggling with how to just build a super simple Kinetic Dashboard (one BAQ, no parameters, no tabs, no filters, 1 pane only, not updatable). After reading the forums here, I finally pieced it together and figured out how to build the simplest of dashboards.

Note I didn’t want to use the conversion tool because of the way things get renamed and in an un-editable state - heard about this in the forums here.

Here are my findings using 2024.1.10. Overall, I give the process eight sad faces and one happy face.

When looking at Dashboards in Application Studio, it is helpful to filter on Type = Dashboard to show only dashboards. Then sort by the Application ID.

Do your development in a Test/Pilot environment, then transfer it to production later.

• Open application studio
• Create a new entry using the (+) button at the top right, select Dashboard type, set the ID of the dashboard
• Select Application Map link at the top.
• Set the new Name and Caption for the dashboard
• Click Edit Page (or select the rectangle thing in the middle and select Pencil icon)
• Under components, find Grid and drag it onto the main page
• Click on Properties (top right)
• Click on “No records available” section to give it focus
• Click Data on right
• Click Grid Model
• Scroll down and Click Provider Model
• Set the BAQ ID that will provide data to the Grid
• Check box for “Auto Load Grid”
• Navigate back up to metafx-panel-card-grid link on the right.
• Scroll down to the bottom and click Advanced
• Check option for “Auto Fill Container”
• Navigate to metafx-panel-card-grid > Grid model
• Select option for Resizable
• Select option for Sortable
• Select option for Filterable
• Select option for “Advanced Filter”
• Click Play Button / Preview Button. This should pull in data, but probably in the wrong order.
• Force Column Display Order:
o Warning – any spelling mistakes here could break the entire dashboard. Click Preview occasionally to verify things are still working.
o Get the exact Alias names from the BAQ
o Get column order, and display names that should be shown in the BAQ
o from metafx-panel-card-grid > Data > Grid Model > Columns, click the (+) button
 (NOT the location at metafx-panel-card-grid > Grid Model > Provider Model > Columns)
o Under Field, type in the Alias from the BAQ
o Set the Title to define the column header text. The Title is what will display on the dashboard – usually the Label value from the BAQ.
o Continue adding columns with the (+) button until all columns for display have been added.
o Why is there no option here to select BAQ fields? This is a lot of typing :slightly_frowning_face: Also, why doesn’t this pre-populate with the same display order as defined in the BAQ?
• Click the Save button top right
• Click the 3 dots button, then select Publish. Tha Base layer is now defined.
• Create a blank Layer
o Otherwise, the app will error out when you put it in Menu Maintenance. :slightly_frowning_face:
o Close the editor window.
o Close and re-open Application Studio, so that the newly created application will be visible. Why is there no Refresh button here? :slightly_frowning_face:
o Click on the Base link for the Dashboard you just created, select “Use Layer”
o Click on the blue text in the top right
o Set a layer name, such as “L1”, then click the “Save Layer” blue link.
o Preview the layer
o Save the Layer
o Publish the Layer
o Close and Re-open Application Studio so you can see the Layer you just created.
o There should now be a Base entry and a Layer entry for your dashboard.
• Create a security ID in Menu Security Maintenance (if needed)
• Now create the entry for this app in Menu Maintenance.
o Set all the fields you would normally set in Menu Maintenance.
o Click the “Kinetic Customization” search button, and select the Layer you created for this dashboard.
o The field is Light Gray, making it look like it’s disabled, but it’s not disabled :frowning:
o Save, close and re-open Epicor so that the menu change populates in the Menu. Shouldn’t there be a Refresh button for the menu, similar to what you see in SQL Server Management Studio? :slightly_frowning_face:
• Build the solution for transfer to production
o Open Solution Workbench – use the Kinetic version. Classic won’t work for this.
o Create a new solution, give it an ID and a Description, then click Save.
o In solution workbench, you need to add a KineticApp element type, not a Dashboard. (Dashboard = Classic dashboard, KineticApp = Kinetic Dashboards and other stuff)
o There’s a bug where sometimes you can’t select the row you need. Select a different row, un-select it, then you’ll be able to select the row you wanted in the first place :slightly_frowning_face:
o Add the Menu element for the dashboard
o Sometimes, things are automatically checked that you didn’t explicitly check. Watch out for this and remove them if needed They can also be deleted after-the-fact if they get accidentally added.
o Add the Security element if needed. Sometimes, no results populate. :slightly_frowning_face: If you see this, save your solution, close and re-open it, then you should see Security elements populate when you search for them.
o Build your solution, and copy it to your production environment
• Use solution workbench to install your solution in Production
o Close and re-open Epicor to see the dashboard in the menu.

There’s a lot of sadness in this process, but I am pleased to find that now in Kinetic you don’t have to scroll to the very end of a result set to see summary data. :slight_smile:

Hope this is helpful. Comments on the process or better ways to do things is appreciated. Thanks.

6 Likes

There’s also this. :slight_smile:
How To: Kinetic Dashboard Uplifts - Experts’ Corner - Epicor User Help Forum

For what it’s worth I have seen an uplifted dash work as expected without any tinkering for extremely simple ones. Maybe I just got lucky though.

@Potato, that is an EXCELLENT description of your journey. I wish more people would write out their process so people coming here for the first time can actually see that, at the end of the long and winding tunnel, there is a light.

Success lurks more than it beckons.

Great Job!

2 Likes