Alert

Download sample file: alert.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
CCY Currency in which the value of the KPI is expressed N USD
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
search.js