a6e5b969-be6e-4756-ae53-47d3cb899ca4.png

de61f823-39a9-4426-a0a2-2fd0b4ca32e9.png

Director Process Intelligence

This is fantastic. I have one question though: in the ROI spreadsheet, there are 2 columns with integer values: timeValueMin and itemCost.timeValueMin appears to be the amount of minutes (of manual effort) that was saved by the RPA, per job/queue item.itemCost - I can't find any reference in the documentation or the Power BI Dashboards for this field, and changing it to different values doesn't seem to impact any of the charts. Is this developer time (min) or process time, or something else?

Does this work when Orchestrator is sending Robot Logs not to SQL, but to another destination such as Elastic or CosmosDB? From the type of data in screenshots, seems it does because Orchestrator is likely to store this in SQL in any case, but thought I'd confirm this.

We are currently running Orchestrator using Azure SQL. I assume these dashboards can’t utilise DirectQuery and need to use Import which requires an on premise gateway? Thanks.

We are on v2018.4.3 and starting on testing this, is there a different SQL scripts to create the Views.

Thank you for sharing this solution, it is always good to have custom reports for better insights.In dependencies, it says Power Bi Desktop, does it mean I need to take license of&nbsp;power BI &amp; install it?I will appreciate your response.

Hello. In Step 1: Create View in SQL, the instructions state to make sure to use the script version corresponding to the Orchestrator version. Our Orchestrator version is 2018.4 but you only have view creation scripts up to version 2018.2. Can that still be used?

Hi, I am running Orchestrator ver. 2019.4.4Is there available scripts for this version of Orchestrator? I am a bit reserved to run the script which is made for other version of Orchestrator.

We are using orchestrator version 2018.4.5. Please help us with the sql scripts for this version ?

Hi Sorin,I am preparing ROI Mapping excel documents. Can you please let me know in column C (itemCost) do I need to mentioned itemCost in minutes ?Or is there another way to calculate itemCost ?Thanks.

Hello Sorin,Regarding to ROI Mapping template which is in Power BI Package zip, we have some questions.1- As there are 2 columns timeValueMin and ItemCost we would like to know why do they stand for? In what scale unit (ex. per run, per day, hr or month)2- Even we filled out the "itemCost" column, the values are not reflected to Job Dashboard (BI Chart) AnalyticsJobs2 sheet. Do we miss or misunderstand in that point? Or is there another way to reflect this value to these charts.ThanksRonak

Hi Sorin,An example case: We have an example automation process which runs twice a day. For that process robot runs approximately 20 min for each run and for humans to do the same job it takes 120 min. each time. So, how can we indicate this example on ROI Mapping excel table?Thanks in AdvanceRonak

Hi Sorin,I would like to know your recommendation on how we can effectively update the time value ans item cost on the ROI mapping. Also, does the Report needs a dbo schema.My jobs dashboard is working but I have and error on the Queues Dashboard , particularly on the SLA Status. Let me know how to fix this. Thanks,Carlito

Thanks for the awesome work! But I have doubt on whether it would be still fine on orchestrator version 2019.10.1? Please help. Much Thanks.

When I deploy the Dashboard in SQL Server.

I assume that it directly uses the SQL Server so it shows UK time.

Is there any option to use local time in Dashboard?

or Do I need to change the script like DATEADD(HOUR,9,[STARTTIME])?

this is great. but i still not get it about ROI sheet and how to use it. could you inform us how to use it. what is mean timeValueMin and item cost at that sheet and how can power bi interpret it. thank you

We are running the Orchestrator v.2019.10.15

Are there available scripts for this version of Orchestrator?

I would like to replace the ROI Mapping excel file source to DB table.  Can you please share expression on how you calculated "timeValueMin" and "itemCost" data items and also the respective table information?

Hello, to whom that can help please and thank you! 

I am working on a dashboard and i need help with getting the avergae run time (last 50 runs) for each job. I am not sure what exactly the path would look like this for this particular query... can you please help?

I am thinking some along the lines of: https://cloud.uipath.com/odata/Jobs?$top=10&$filter=Robot/Id eq 749 and StartTime gt 2017-09-22T09:59:22.837Z 

but ^ that only shows the start date. i want the the last month? Is this possible? 

I believe the path for the end date is: https://cloud.uipath.com/odata/Jobs?$top=10&$filter=Robot/Id eq 759 and EndTime lt 2018-02-22T10:00:00.837Z

Again, how can i get this data (what would the path look like for this?) to be the last month for all the jobs running? 

Hi, Thank you for the excellent Dashboard. I was wondering about th Processing Time average per RobotDate. If I filter for example for onyl certain robot, it can show processing time of over 40h/day which does not make sense. Also with a couple of almost continuously running robots it can show something like 24,1h/24h even with no filters active. I have nnot changed the default formula:

KEEPFILTERS(VALUES('JobsDB'[RobotDate])),

CALCULATE(SUM('JobsDB'[Processing Time]))

Is there something I could do to fix this as it is a very nice metric to follow...:)

What can we learn from understanding the "front office" and "back office" robots?

Is this something that can be understood as "manual execution" or "scheduled execution"?

Hello Sorin - thank you for providing this. Very helpful. A couple of questions:

1) For On-Prem clients, who do not have Insights/not opting in, can we get access to the Queue-related JSON column data which contains all the business specific metrics?

2) Is there a timeframe limit (1 month?) that the data can show? Is it possible to continually append and have a 1 year+ worth of data in a PBI solution?

Very interesting and complete  - Thanks a lot !


Super - Great tool. Easy to implement, very clear and useful.
Thanks!


Brilliant - Thanks very much Sorin. Saved us a lot of time and effort and provides a great foundation to customise our own dashboards from.


Thank you so much for this and for the amazing effort you have put in..

Great!!

Works very well with our On-Premise Orchestrator  2021.4.1 (we used the bi_views_creation_script_2018.2_v1.sql).

If someone else also need the output information of a queue item, you can add: ,qi.[Output] AS 'itemOutput' after ,qi.[SpecificData] AS 'itemData' this give you itemOutput in the PowerBi Data.

d45af20e-5b5f-4184-81ae-c9ede79c68a9.zip

The package includes 2 Power BI Dashboards, one for jobs and two for queues, each of which contains multiple views:

Queues Overview: executive view of the transactions performed during the selected time frame, by final status, for the whole period and over time

Active Queues: a summary of the queue items currently in process and pending (in queue), broken down by queue name, SLA status and priority

Queues Analytics 1&2 identifies key metrics for the transactions executed during the chosen time frame, centered around final status, SLA status, duration processing and time spent waiting in queue

Jobs Overview: executive view of the jobs performed during the selected time frame, by final status, for the whole period and over time. Also provides the robot utilization in hours worked / robot / day

Active Jobs: a summary of the jobs currently in process and pending. Currently running jobs are listed.

Analytics Jobs 1&2 identifies key metrics for the jobs executed during the chosen time frame, centered around final status, duration, duration in pending and volumes (number of times) processed

Interactive Power BI dashboards on the topic of jobs and queues processes, using data from the Orchestrator SQL Server database

Power BI Jobs and Queues Dashboards

Power BI Jobs and Queues Dashboards

Tableau Jobs and Queues Dashboard for Orchestrator…

Kibana Jobs, Errors, and Queues Dashboards…

UiPath Connector for Workato…