Count of Open Risk

A set of high-level indicators to summarize current risk status on project-level with history overview:

  • Open risks: count of open risks.
  • Late risks: count of open risks after their estimated end date.
  • Red risks: count of open risks with red probability-impact and before their estimated end date.
  • Orange risks: count of open risks with orange probability-impact and before their estimated end date.
  • Yellow risks: count of open risks with yellow probability-impact and before their estimated end date.

Business Objects Risk (data model class "risk")
Values (or X-Axis and Y-Axis)
  • X-Axis: timeline (week unit), based on history_weekofyear facet
  • Value and Y-Axis of timeline: aggregation value corresponding respectively to SUM of
    • Open risks: snapshot documents (document_history_type field) without complete category on facet current
    • Late risks: snapshot documents (document_history_type field) without complete category on facet current and with project_estimated_finish_date before now
    • Red risks: snapshot documents (document_history_type field) without complete category on facet current and with red probability-impact on combination of facets probability and impact
    • Orange risks: snapshot documents (document_history_type field) without complete category on facet current and with orange probability-impact on combination of facets probability and impact
    • Yellow risks: snapshot documents (document_history_type field) without complete category on facet current and with yellow probability-impact on combination of facets probability and impact
Sorting The results are sorted by time, the most recent on the right of the chart.
Limits Only the last 12 weeks are displayed.
Colors The color of this chart is customizable and predefined to green, blue, orange, and red for count of respectively [0; 0.5[, [0.5; 1[, [1; 1.5[, [1.5; 100000[.
Available Views Indicator values with history.
Interactions On this chart, you can click the filter icon to refine dashboard on (respectively):
  • Open risks
  • Late risks
  • Red risks
  • Orange risks
  • Yellow risks
Technical Details

  • Consolidation

    • These indicators rely on snapshots computed by project_getProjectHistoryFromEnovia aggregation processor

  • Data model
  • Class: risk (or inherited)
  • Property: document_history_datetime
  • Property: document_history_type
  • Property: project_estimated_finish_date
  • Mashup feed: project_history

    • history_weekofyear facet is added aggregations on feed

      • open: SUM(#regex_match(document_history_type, 'snapshot') && !#has_category("Top/classproperties/current/complete", categories))
      • late: SUM(#regex_match(document_history_type, 'snapshot') && !#has_category("Top/classproperties/current/complete", categories) && #ndays(#extract(document_ram_datetime,"project_estimated_finish_date"),#now()) > 0)
      • red: SUM(#regex_match(document_history_type, 'snapshot') && (#has_category("Top/classproperties/risk/probability/1", categories) * 0 + #has_category("Top/classproperties/risk/probability/2", categories) * 2 + #has_category("Top/classproperties/risk/probability/3", categories) * 3 + #has_category("Top/classproperties/risk/probability/4", categories) * 4 + #has_category("Top/classproperties/risk/probability/5", categories) * 5 + #has_category("Top/classproperties/risk/impact/1", categories) * 0 + #has_category("Top/classproperties/risk/impact/2", categories) * 2 + #has_category("Top/classproperties/risk/impact/3", categories) * 3 + #has_category("Top/classproperties/risk/impact/4", categories) * 4 + #has_category("Top/classproperties/risk/impact/5", categories) * 5) > 5)
      • orange: SUM(#regex_match(document_history_type, 'snapshot') &&(#has_category("Top/classproperties/risk/probability/1", categories) * 0 + #has_category("Top/classproperties/risk/probability/2", categories) * 2 + #has_category("Top/classproperties/risk/probability/3", categories) * 3 + #has_category("Top/classproperties/risk/probability/4", categories) * 4 + #has_category("Top/classproperties/risk/probability/5", categories) * 5 + #has_category("Top/classproperties/risk/impact/1", categories) * 0 + #has_category("Top/classproperties/risk/impact/2", categories) * 2 + #has_category("Top/classproperties/risk/impact/3", categories) * 3 + #has_category("Top/classproperties/risk/impact/4", categories) * 4 + #has_category("Top/classproperties/risk/impact/5", categories) * 5) < 6 && (#has_category("Top/classproperties/risk/probability/1", categories) * 0 + #has_category("Top/classproperties/risk/probability/2", categories) * 2 + #has_category("Top/classproperties/risk/probability/3", categories) * 3 + #has_category("Top/classproperties/risk/probability/4", categories) * 4 + #has_category("Top/classproperties/risk/probability/5", categories) * 5 + #has_category("Top/classproperties/risk/impact/1", categories) * 0 + #has_category("Top/classproperties/risk/impact/2", categories) * 2 + #has_category("Top/classproperties/risk/impact/3", categories) * 3 + #has_category("Top/classproperties/risk/impact/4", categories) * 4 + #has_category("Top/classproperties/risk/impact/5", categories) * 5) > 3)
      • yellow: SUM(#regex_match(document_history_type, 'snapshot') && (#has_category("Top/classproperties/risk/probability/1", categories) * 0 + #has_category("Top/classproperties/risk/probability/2", categories) * 2 + #has_category("Top/classproperties/risk/probability/3", categories) * 3 + #has_category("Top/classproperties/risk/probability/4", categories) * 4 + #has_category("Top/classproperties/risk/probability/5", categories) * 5 + #has_category("Top/classproperties/risk/impact/1", categories) * 0 + #has_category("Top/classproperties/risk/impact/2", categories) * 2 + #has_category("Top/classproperties/risk/impact/3", categories) * 3 + #has_category("Top/classproperties/risk/impact/4", categories) * 4 + #has_category("Top/classproperties/risk/impact/5", categories) * 5) < 4)