Multigrid (more than 2) Dashboard possible in Kinetic?

Kinetic ERP
,
1

I’ve mentioned this dashboard before, and what a pain it was for refreshing :smiley:
It’s working quite well now, but when I tried to deploy a Kinetic application, it wasn’t remotely close. None of the publish/subscribe stuff worked and even the hierarchy was different.

I was fairly sure that was going to be the case before I tried it, but I want to know if something like this can be done in Kinetic, or if I have to use PowerBI to get similar functionality.

image
image1459×1042 181 KB

This works nicely, you can drill down and see what made up the line above. But only because everything publishes and subscribes properly. The Kinetic app put the Months first, then Line of Business, Employee, Snapshot Date, Quarters and Time Types in that order, prompting for all of them. I don’t think that’s even a usable start of a functional dashboard.

I’m fairly certain that the nice click and drill down idea won’t work in Kinetic and that PowerBI (which we do have) is the way to get to a non-Classic version. But if someone has done something similar in a Kinetic dashboard, I’d like to know :slight_smile:

2

Yes, but not via the dashboard uplift wizard from classic.

3

It’s pretty easy with the provider model.

Set up a top grid with a baq.

Set up another grid, and in the baq options on provider model, you can set where clauses for publish and subscribe.

Can chain them, etc.

4

How responsive is such a setup? For this dashboard, the Snapshot Date runs first and we just use the top row to then power the Fiscal Year/Quarter external BAQ using that date. ALL of the visible grids are running functions with the subscribe variables passed as arguments. My thought is that a browser just isn’t made for such a thing, but I have been shown wrong more than once before :slight_smile:

Plus I could be a complete idiot for setting this up in the first place. They wanted to adjust an SSRS report that was doing something similar. I didn’t want to have to create a new SSRS report so I attempted to replicate most of what it did in an Epicor dashboard.
(I made the original SSRS report many years ago and it really wasn’t as similar as they thought it was. That SSRS report was the infamous greenbar report I mentioned before :smiley: )

The main table behind this dashboard is a snapshot of the LaborDtl file and all the related records (Cust into, Proj etc) so it has a LOT of records. Hence the need for the functions which limit the rows returned.

If the Kinetic grids allow a click event to trigger the lower grid in cascading refreshes, then it should be possible to do a similar setup, but I’m not looking forward to setting it up. It was hard enough in Classic