Risk Modeler December 2022

The December release introduces updates to the Metrics and Uploads APIs.

Data Source API

The Upload RDM operation (GET /[v1][v2]/databasources/db-instances) now enable clients to import results into Risk Modeler from an existing RDM on Data Bridge.

The client must specify the name of the Data Bridge server instance in servername query parameter and
specify a value of true in the new importFromServer body parameter.

{
    "uploadId": "rdb_db_name",
    "rdmName": "string",
    "edmDataSourceName": "string",
    "analysisIdFilter": [
        0
    ],
    "tableFilter": [
        "string"
    ],
    "perspectiveFilter": [
        "string"
    ],
    "exposureSetId": "string",
    "share": true,
    "groups": [
        "string"
    ],
    "importFromServer": true
}

Metrics

The Get results operation (GET /[v1][v2]/metrics) now returns detailed information about grouping in analysis results.

This group type data enables users to audit the settings and underlying results selected to generate the grouped results. The operation now returns responses that differ depending on the group type (PLT, ELT, and imported ELT).

For PLT Type Groups, the operation now returns: Propagate Detailed Output, GroupSimulationPeriod (Selected/customized while grouping) including regionCode, perilCode, framework, eventRateSchemeId, eventRateSchemeName (an empty string for analysis groups created before this release), simulationSetId, simulationSetName, and groupedAnalysisIds:

{
    "id": 77905,
    "name": "PLT_Group_Test_Manish1",
    "runDate": "2022-12-06T22:56:38",
    "description": "",
    "rdmName": "",
    "regroup": 0,
    "exposureType": 8017,
    "engineVersion": "PLTGroup1.0",
    "exposureId": 0,
    "dataSource": "",
    "riGuid": "4e0d9400-a292-400b-84f4-15ec4d615bdc",
    "jobId": 9024086,
    "jobUUID": "2fd00009-27eb-4df3-bad5-06e3b9013cf7",
    "isGroup": true,
    "modelProfile": {
        "id": 0,
        "code": "",
        "name": ""
    },
    "outputProfile": {
        "id": 0,
        "code": "",
        "name": ""
    },
    "engine": {
        "id": 102,
        "code": "",
        "name": "Group"
    },
    "status": {
        "id": 102,
        "code": "",
        "name": "Analyzed"
    },
    "type": {
        "id": 102,
        "code": "",
        "name": "Exceedance Probability"
    },
    "peril": {
        "id": 0,
        "code": "YY",
        "name": "Multi-Peril"
    },
    "subPeril": {
        "id": -1,
        "code": "",
        "name": "Multi-SubPeril"
    },
    "region": {
        "id": 0,
        "code": "YY",
        "name": "Multiple regions"
    },
    "lossAmplification": {
        "id": 0,
        "code": "",
        "name": "None"
    },
    "mode": {
        "id": 2,
        "code": "",
        "name": "Distributed"
    },
    "insuranceType": {
        "id": 1,
        "code": "",
        "name": "Property"
    },
    "vulnerabilityCurve": {
        "id": 0,
        "code": "",
        "name": "Vulnerability - Default"
    },
    "user": {
        "id": 0,
        "code": "[email protected]",
        "name": "[email protected]"
    },
    "currency": {
        "name": "US Dollar",
        "code": "USD"
    },
    "engineSubType": {
        "id": 0,
        "code": "NA",
        "name": "Not Applicable"
    },
    "framework": "PLT",
    "simulationSetId": 0,
    "simulationPeriods": 0,
    "exposureSetId": "4e0d9400-a292-400b-84f4-15ec4d615bdc",
    "additionalProperties": [
        {
            "key": "groupedAnalysisIds",
            "properties": [
                {
                    "id": 77233,
                    "name": "integration_test_wfDc: PORTFOLIO: EUFL_HD_Number",
                    "value": ""
                },
                {
                    "id": 77234,
                    "name": "integration_test_wfDc: PORTFOLIO: EUFL_HD_IE_Number",
                    "value": ""
                },
                {
                    "id": 77235,
                    "name": "integration_test_wfDc: PORTFOLIO: NAHU_DLM_Number",
                    "value": ""
                },
                {
                    "id": 77238,
                    "name": "Test_1670343119257",
                    "value": ""
                },
                {
                    "id": 77240,
                    "name": "RMS_RL18_Ref_TestData_EDM: PORTFOLIO: Port_All_Acc",
                    "value": ""
                }
            ]
        },
        {
            "key": "propagateDetailedOutput",
            "properties": [
                {
                    "id": 0,
                    "name": "",
                    "value": "N/A"
                }
            ]
        },
        {
            "key": "simulationSets",
            "properties": [
                {
                    "id": 0,
                    "name": "",
                    "value": {
                        "regionCode": "EU",
                        "perilCode": "FL"
                        "framework": "PLT",
                        "eventRateSchemeId": 0,
                        "eventRateSchemeName": "",
                        "simulationSetId": 9,
                        "simulationSetName": "RMS V2.0 Default Rates",
                        "simulationPeriods": 50000
                    }
                },
                {
                    "id": 0,
                    "name": "",
                    "value": {
                        "regionCode": "NA",
                        "perilCode": "WS",
                        "framework": "ELT",
                        "eventRateSchemeId": 141,
                        "eventRateSchemeName": "RMS 2017 Historical Event Rates",
                        "simulationSetId": 92,
                        "simulationSetName": "North Atlantic Hurricane, 2017 Historical Event Rates",
                        "simulationPeriods": 50000
                    }
                }
            ]
        },
        {
            "key": "groupSimulationPeriod",
            "properties": [
                {
                    "id": 0,
                    "name": "",
                    "value": 50000
                }
            ]
        }
    ]
}

For ELT Type Groups and Imported ELT Type Groups, the operation now returns: Propagate Detailed Output, Event Rate Schemes (Selected/customized while grouping) including regionCode, perilCode, framework, eventRateSchemeId, eventRateSchemeName(Empty string for analysis groups created before this release), andgroupedAnalysisIds:

{
    "id": 51607,
    "name": "ELT_Grou",
    "runDate": "2022-11-10T00:52:06",
    "description": "",
    "rdmName": "",
    "regroup": 0,
    "exposureType": 8017,
    "engineVersion": "RL22",
    "groupType": "CDGP",
    "cedant": "",
    "lob": "",
    "exposureId": 0,
    "dataSource": "",
    "riGuid": "a70f5ff4-db8c-4ef8-a04f-01f77c53c992",
    "jobId": 8877317,
    "jobUUID": "9b904a49-1d0f-4129-ba2e-31355f0cefd3",
    "isGroup": true,
    "modelProfile": {
        "id": 0,
        "code": "",
        "name": ""
    },
    "outputProfile": {
        "id": 0,
        "code": "",
        "name": ""
    },
    "engine": {
        "id": 102,
        "code": "",
        "name": "Group"
    },
    "status": {
        "id": 102,
        "code": "",
        "name": "Analyzed"
    },
    "type": {
        "id": 102,
        "code": "",
        "name": "Exceedance Probability"
    },
    "peril": {
        "id": 0,
        "code": "YY",
        "name": "Multi-Peril"
    },
    "subPeril": {
        "id": -1,
        "code": "",
        "name": "Multi-SubPeril"
    },
    "region": {
        "id": 0,
        "code": "YY",
        "name": "Multiple regions"
    },
    "lossAmplification": {
        "id": 268435456,
        "code": "",
        "name": "Mixed"
    },
    "mode": {
        "id": 2,
        "code": "",
        "name": "Distributed"
    },
    "insuranceType": {
        "id": 1,
        "code": "",
        "name": "Property"
    },
    "vulnerabilityCurve": {
        "id": 0,
        "code": "",
        "name": "Vulnerability - Default"
    },
    "user": {
        "id": 0,
        "code": "[email protected]",
        "name": "[email protected]"
    },
    "currency": {
        "name": "US Dollar",
        "code": "USD",
        "scheme": "RMS",
        "asOfDate": "2022-06-01T00:00:00Z",
        "vintage": "RL22"
    },
    "engineSubType": {
        "id": 0,
        "code": "NA",
        "name": "Not Applicable"
    },
    "framework": "ELT",
    "simulationSetId": 0,
    "simulationPeriods": 0,
    "exposureSetId": "a70f5ff4-db8c-4ef8-a04f-01f77c53c992",
    "additionalProperties": [
        {
            "key": "groupedAnalysisIds",
            "properties": [
                {
                    "id": 48307,
                    "name": "Port_All_Acct_Detail",
                    "value": ""
                },
                {
                    "id": 48309,
                    "name": "RM_ModelProfile_Exposure_Validation_V3: PORTFOLIO: All_Acc",
                    "value": ""
                },
                {
                    "id": 48312,
                    "name": "Port_All_Acct_Detail_RECALC",
                    "value": ""
                },
                {
                    "id": 48313,
                    "name": "RM_ModelProfile_Exposure_Validation_V3: PORTFOLIO: All_Acc",
                    "value": ""
                },
                {
                    "id": 48319,
                    "name": "RM_ModelProfile_Exposure_Validation_V3: PORTFOLIO: All_Acc_PERSP",
                    "value": ""
                },
                {
                    "id": 48320,
                    "name": "RMS_RL18_Ref_TestData_EDM: PORTFOLIO: Smoke_1Loc_NAHU",
                    "value": ""
                },
                {
                    "id": 48322,
                    "name": "RM_ModelProfile_Exposure_Validation_V3: PORTFOLIO: All_Acc_EVENT",
                    "value": ""
                }
            ]
        },
        {
            "key": "propagateDetailedOutput",
            "properties": [
                {
                    "id": 0,
                    "name": "",
                    "value": "No"
                }
            ]
        },
        {
            "key": "eventRateSchemes",
            "properties": [
                {
                    "id": 0,
                    "name": "",
                    "value": {
                        "regionCode": "AU",
                        "perilCode": "EQ",
                        "framework": "ELT",
                        "eventRateSchemeId": 184,
                        "eventRateSchemeName": "Risklink 18.0",
                        "simulationSetId": 0,
                        "simulationSetName": "",
                        "simulationPeriods": 0
                    }
                },
                {
                    "id": 0,
                    "name": "",
                    "value": {
                        "regionCode": "NA",
                        "perilCode": "WS",
                        "framework": "ELT",
                        "eventRateSchemeId": 191,
                        "eventRateSchemeName": "RMS 2019 Stochastic Event Rates",
                        "simulationSetId": 0,
                        "simulationSetName": "",
                        "simulationPeriods": 0
                    }
                },
                {
                    "id": 0,
                    "name": "",
                    "value": {
                        "regionCode": "NA",
                        "perilCode": "WT",
                        "framework": "ELT",
                        "eventRateSchemeId": 27,
                        "eventRateSchemeName": "Risklink 9.0",
                        "simulationSetId": 0,
                        "simulationSetName": "",
                        "simulationPeriods": 0
                    }
                },
                {
                    "id": 0,
                    "name": "",
                    "value": {
                        "regionCode": "NA",
                        "perilCode": "WS",
                        "framework": "ELT",
                        "eventRateSchemeId": 50,
                        "eventRateSchemeName": "RMS 2011 Stochastic Event Rates",
                        "simulationSetId": 0,
                        "simulationSetName": "",
                        "simulationPeriods": 0
                    }
                }
            ]
        }
    ]
}

Imported ELT group

{
    "id": 19515,
    "name": "ELT_Group_NAHU_EUWS",
    "runDate": "2022-10-25T22:11:45",
    "description": "ELT group to test export ELT",
    "rdmName": "ELT_Group_With_UnderlyingAnalysis_Export",
    "regroup": 0,
    "exposureType": 8017,
    "engineVersion": "RL22",
    "groupType": "CDGP",
    "cedant": "",
    "lob": "",
    "exposureId": 0,
    "dataSource": "",
    "riGuid": "86e41afe-728e-4702-ba9a-27b1c34e1fc8",
    "jobId": 8730145,
    "jobUUID": "6d44155c-1231-4465-a8dd-ce9a3fc0c4ac",
    "isGroup": true,
    "modelProfile": {
        "id": 0,
        "code": "",
        "name": ""
    },
    "outputProfile": {
        "id": 0,
        "code": "",
        "name": ""
    },
    "engine": {
        "id": 102,
        "code": "",
        "name": "Group"
    },
    "status": {
        "id": 102,
        "code": "",
        "name": "Analyzed"
    },
    "type": {
        "id": 102,
        "code": "",
        "name": "Exceedance Probability"
    },
    "peril": {
        "id": 0,
        "code": "WS",
        "name": "Windstorm"
    },
    "subPeril": {
        "id": 512,
        "code": "",
        "name": "Wind Only"
    },
    "region": {
        "id": 0,
        "code": "YY",
        "name": "Multiple regions"
    },
    "lossAmplification": {
        "id": 7,
        "code": "",
        "name": "Building, Contents, BI"
    },
    "mode": {
        "id": 2,
        "code": "",
        "name": "Distributed"
    },
    "insuranceType": {
        "id": 1,
        "code": "",
        "name": "Property"
    },
    "vulnerabilityCurve": {
        "id": 0,
        "code": "",
        "name": "Vulnerability - Default"
    },
    "user": {
        "id": 0,
        "code": "[email protected]",
        "name": "[email protected]"
    },
    "currency": {
        "name": "US Dollar",
        "code": "USD"
    },
    "engineSubType": {
        "id": 0,
        "code": "NA",
        "name": "Not Applicable"
    },
    "framework": "ELT",
    "simulationSetId": 0,
    "simulationPeriods": 0,
    "exposureSetId": "86e41afe-728e-4702-ba9a-27b1c34e1fc8",
    "additionalProperties": [
        {
            "key": "groupedAnalysisIds",
            "properties": [
                {
                    "id": 19512,
                    "name": "integration_test_LmcL: PORTFOLIO: EUWS_DLM_Number",
                    "value": ""
                },
                {
                    "id": 19513,
                    "name": "integration_test_LmcL: PORTFOLIO: NAHU_DLM_Number",
                    "value": ""
                },
                {
                    "id": 19514,
                    "name": "integration_test_LmcL: PORTFOLIO: NAHU_DLM_Number",
                    "value": ""
                }
            ]
        },
        {
            "key": "propagateDetailedOutput",
            "properties": [
                {
                    "id": 0,
                    "name": "",
                    "value": "No"
                }
            ]
        },
        {
            "key": "eventRateSchemes",
            "properties": [
                {
                    "id": 0,
                    "name": "",
                    "value": {
                        "regionCode": "EU",
                        "perilCode": "WS",
                        "framework": "ELT",
                        "eventRateSchemeId": 84,
                        "eventRateSchemeName": "Risklink 15.0",
                        "simulationSetId": 0,
                        "simulationSetName": "",
                        "simulationPeriods": 0
                    }
                },
                {
                    "id": 0,
                    "name": "",
                    "value": {
                        "regionCode": "NA",
                        "perilCode": "WS",
                        "framework": "ELT",
                        "eventRateSchemeId": 142,
                        "eventRateSchemeName": "RMS 2017 Stochastic Event Rates",
                        "simulationSetId": 0,
                        "simulationSetName": "",
                        "simulationPeriods": 0
                    }
                }
            ]
        }
    ]
}

 

Non-grouped analysis result:


{
    "id": 79730,
    "name": "RL18_HDEUFL_3loc_Test_EDM: PORTFOLIO: EUFL_3loc_CC_2CWarming",
    "runDate": "2022-12-08T01:19:33",
    "description": "EUFL_EP_wPLA_Dist_4ME",
    "rdmName": "",
    "regroup": 0,
    "exposureType": 8017,
    "engineVersion": "HDv2.0",
    "exposureId": 4,
    "dataSource": "RMS_RL18_Ref_TestData_EDM",
    "riGuid": "f35461d1-d574-48da-b0ff-392deebd7556",
    "jobId": 9036075,
    "jobUUID": "214fad13-a309-480f-a2c7-69b1bcd4b510",
    "isGroup": false,
    "modelProfile": {
        "id": 126,
        "code": "",
        "name": "EUFL_EP_wPLA_Dist_4ME"
    },
    "outputProfile": {
        "id": 6,
        "code": "",
        "name": "RMS Risk AAL"
    },
    "engine": {
        "id": 105,
        "code": "",
        "name": "HD"
    },
    "status": {
        "id": 102,
        "code": "",
        "name": "Analyzed"
    },
    "type": {
        "id": 102,
        "code": "",
        "name": "Exceedance Probability"
    },
    "peril": {
        "id": 0,
        "code": "FL",
        "name": "Flood"
    },
    "subPeril": {
        "id": -1,
        "code": "",
        "name": "Multi-SubPeril"
    },
    "region": {
        "id": 0,
        "code": "EU",
        "name": "Europe"
    },
    "lossAmplification": {
        "id": 0,
        "code": "",
        "name": "None"
    },
    "mode": {
        "id": 2,
        "code": "",
        "name": "Distributed"
    },
    "insuranceType": {
        "id": 1,
        "code": "",
        "name": "Property"
    },
    "vulnerabilityCurve": {
        "id": 0,
        "code": "",
        "name": "Vulnerability - Default"
    },
    "user": {
        "id": 0,
        "code": "[email protected]",
        "name": "[email protected]"
    },
    "currency": {
        "name": "US Dollar",
        "code": "USD",
        "scheme": "RMS",
        "asOfDate": "2020-03-01T00:00:00Z",
        "vintage": "RL18"
    },
    "engineSubType": {
        "id": 1,
        "code": "CC",
        "name": "Climate Change"
    },
    "framework": "PLT",
    "simulationSetId": 0,
    "simulationPeriods": 0,
    "exposureSetId": "f35461d1-d574-48da-b0ff-392deebd7556",
    "additionalProperties": []
}