IBM Support

Calculating the "at Risk" status of a task for WebSphere Lombardi Edition

Question & Answer


Question

How is the "at Risk" status of a task calculated?

Answer

The average historical time to complete the task is used to determine when a task becomes "at Risk". The logic is represented by the following formula:

"at Risk" = (Avg Historical Time to Complete Task + Current Time) > Task Due Date

If there is no historical data for this task, 9999 days is used as the average time to complete it, so it will always show up as "at risk" until there is at least one data point.

Note: This calculation is done against the data in the Process Server Database and not the Performance Server.


The query that gets run against the Process database, and not the Performance Data Warehouse database, to determine the average time for this task is as follows (MS SQL version of the query):

SELECT isnull(avg(datediff(ss,allTasks.rcvd_datetime,allTasks.close_datetime)),86400*9999)FROM lsw_task allTasks WHERE allTasks.created_by_bpd_flow_object_id = t3.created_by_bpd_flow_object_id AND allTasks.close_datetime is not null



This query returns the average number of seconds that are required to complete this task.

[{"Product":{"code":"SSFPRP","label":"WebSphere Lombardi Edition"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Report","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1;7.0.1;6.2.2;6.2.1;6.2;6.1;6.0.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Historical Number

206

Product Synonym

TW 6.x TW 7.x

Document Information

Modified date:
15 June 2018

UID

swg21439654

Page Feedback