Alert file
Download sample file: alert.csv
The alert.csv file is generated by AlertTasks, listing the breaches and warnings detected. This file populates the AlertsDefinition store through a listening topic. The file is located in the src/test/resources/data-damples/data/alert directory. The Limits Module 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 |
|---|---|---|---|
| ID | The Reference ID to the Limits Golden Source Upstream | N | id_desk_00023 |
| Name | The KPI name created in the business cube | Y | Delta |
| From | Effective Start Date | Y | 2020-01-01 |
| To | Effective End Date | Y | 2020-01-31 |
| PollingFrequency | Data time relevancy of the limit (End of day, Start of day, or Intraday) | Y | EOD |
| Scope | Determines which members the new limit applies to. You can choose any level of the currently selected cube and a corresponding value from said level. An example scope filter is “Desk=Rates”. Multiple scope filters can be added to a single limit definition. Every scope filter is separated by a pipe. | N | Desk=Bonds |
| BreachOrWarning | Breach or Warning Indicator | N | Breach |
| MeasureValue | Value of Measure at evaluated location | N | 6056856.442934998 |
| KpiType | The type of KPI (supported types are Greater Than, Less Than, Between, Not Between) | N | Greater Than |
| LimitValues | Array of KPI values in the specified currency | N | [100000,5000] |
| LevelMember | Level Member of evaluated location | N | BS_MGT_FX |
| CubeName | Name of the cube for the KPI | Y | Sensitivity Cube |
| ServerName | Name of the server the cube is running | Y | MRA |
| MDX | MDX used to evaluate status | N | “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” |
| BreachCount | Breach count | N | 1 |
| LastUpdateTimestamp | Time AlertTask was run | N | 13:43:23.478 |
| LimitSessionID | Limit Session ID | N | bcb4dfca-a1b7-448b-9c1a-43f511427e51 |