Scenario Overview
North52's business rules engine for Dynamics 365 is ideal for implementing complex rules in the Insurance industry. In this scenario, we will demonstrate how to set up a Decision Table that calculates an Insurance Premium for Used Automobiles based on a variety of Risk Factors.
For this article it is assumed that you have at least basic familiarity with Decision Tables and/or have read the following articles:
Note: We will not detail step-by-step instructions here on how to set up Conditions or Actions, please read the above articles if you need detailed configuration steps.
https://www.youtube.com/watch?v=xJaH-f1G1MI
Insurance Premium Rules
The rules for calculating the insurance premium are as follows:
| Rule # | Description |
|---|---|
| 1 |
Vehicle Type The following are the base premiums depending on the vehicle type:
|
| 2 |
Vehicle Age The company does not insure new cars. Depending on the age of the vehicle apply the following charges: Less than 3 years old: €450 |
| 3 |
Uninsured Motorists Additional protection available for €100 to cover damage caused to the car by other uninsured motorists. |
| 4 |
Medical Cover There is an extra charge of €700 if the customer wants coverage for any medical bills resulting from a crash. |
| 5 |
Potential Occupant Injury Certain vehicles are more dangerous in a collision than others. If the vehicle being insured has one of the following ratings then additional charges apply:
|
| 6 |
Potential Theft Rating Certain vehicles are more likely to be stolen than others. If the vehicle's potential theft rating is High then a charge of €1500 applies. |
North52 Decision Suite Solution
The North52 Decision Suite solution works like this:
- A Formula of type Save - To Current Record is created on the Automobile entity
- The Source Properties are set to the following fields:
- Automobile Type, Is New, Date First Registered, Uninsured Motorist Coverage Included, Medical Coverage is Included, Potential Occupant Injury Rate, Potential Theft Rating
- The Target Property is set to Premium
- The Event is set to Create & Update
Formula Setup
Decision Table
As the Decision Table executes and evaluates each of the conditions it sums up the values accordingly. Column H has been set up as an Inline-Calculation and is used by the Decision Table to keep a running sum of the Automobile Premium based on rows that match conditions within the Decision Table. You can think of this as a variable result which is then used to update the Premium field.
This Decision Table is configured as a Save - To Current Record; the final value of the inline calculation is automatically inserted into the Premium field as specified in the Target Property. An alternative method could have used a Save - Perform Action Formula type and set the Premium field as an Action column.
Global Calculations Sheet
The Global Calculations Sheet has 1 calculation in this Formula: Age - used to calculate the current age of the Automobile:
Calculations:
Age: DateDiff([north52_automobile.north52_datefirstregistered], UtcDate(), 'y')
Testing
In the form below you can see the the Decision Table has calculated and applied the Premium to the record:
