topic Re: Table BPMIUtilisationDaily with impossible daily utilization in Digital Exchange

Table BPMIUtilisationDaily with impossible daily utilization

JoaoSilva — Mon, 04 Mar 2024 10:56:20 GMT

I've been using Power BI to present to business users the machine utilization.

The table I'm using for this report is the BPMIUtilisationDaily, and this table since February is presenting hourly utilizations of up to 7200 seconds used per hour, which equals to 200% utilization.

How can this be possible? And how to solve it?

Re: Table BPMIUtilisationDaily with impossible daily utilization

Walter.Koller — Mon, 04 Mar 2024 13:40:13 GMT

I just checked our table (BP 6.9) and max utilization is 3600, for each runtime resource.

Maybe your report aggregates two runtime resource to a total of 7200?

Otherwise it would be interesting to know what BP version you are using

Re: Table BPMIUtilisationDaily with impossible daily utilization

JoaoSilva — Mon, 04 Mar 2024 15:06:35 GMT

@Walter Koller I'm using version 6.8.1

The table itself has 7200 straight from the Database for some machines.

Added screenshot of the query.

Re: Table BPMIUtilisationDaily with impossible daily utilization

Walter.Koller — Tue, 05 Mar 2024 11:48:33 GMT

This looks indeed strange.

I can see correct calculation in line 17 of the result in your screenshot. So it is not a general issues but is occurs in certain situation.

It might be related to the process running more than 24h. Unfortunately I could not find such a case in our current data and I am not able to verify my assumption.

I would suggest to open support ticket with Blue Prism for further investigation.