Incidents file
Download sample file: incidents.csv
The incidents.csv file is generated by AlertTasks, listing the breaches and warnings detected. This file populates the Incidents store through a listening topic. The file is located in the src/test/resources/data-samples/data/incidents
directory. Atoti Limits creates a folder per AsOfDate. A new file is created based on per run and per KPI for breach and warning respectively, with the file name format “{asOfDate}/alert_{kpiName}_{lastUpdateTimeStamp}.csv”.
Column Name | Description | Required | Value Example |
---|---|---|---|
limitKey | Unique key for evaluated limit | Y | 417288935 |
Incident Type | The type of Incident: BREACH or WARNING | Y | BREACH or WARNING |
Measure Value | Value of Measure at evaluated location | Y | 6056856.442934998 |
Location | Location in the cube where the Incident occurred | Y | Desk@Desks@Booking |
MDX | MDX used to evaluate status | Y | “SELECT NON EMPTY Hierarchize( Descendants( { [Booking].[Books].[AllMember] }, 1 ) ) ON ROWS, NON EMPTY { [Measures].[FX Risk Charge], [Measures].[SA Book Limit2 Status] } ON COLUMNS FROM [StandardisedApproachCube] WHERE ([displayCurrency].[displayCurrency].[USD], [Dates].[Date].[2018-09-28]) CELL PROPERTIES VALUE, FORMATTED_VALUE, BACK_COLOR, FORE_COLOR, FONT_FLAGS” |
As Of Date | The AsOfDate of the limits cube | Y | 2018-09-28 |
BreachCount | Breach count | Y | 1 |
EvaluationTimestamp | When the evaluation was run | Y | 13:43:23.478 |
SessionID | Limit Session ID | N | bcb4dfca-a1b7-448b-9c1a-43f511427e51 |
Status | Status of the Incident | Y | Breach |
Workflow | The Exception workflow | N | Exception |
Workflow parameters | Exception workflow parameters | N | |
Comment | Comment about the Incident | N | This Incident is a technical issue |