P&C 202: Traffic Director for Version Decision

03:43 mins
B

Bryan O'Neal

Updated on Mar 04, 2025

Traffic Director Pattern Implementation

Hello, I'm Brian O'Neill from Coherent. In this video, I would like to bring to life a simple but important traffic director pattern. The idea of a traffic director is to have an Excel model that makes routing decisions about downstream models that need to be called.

Scenario Overview

In our scenario, we have a Cyber Raider with multiple versions: version one, two, three, four, and five. Based on factors like the policy effective date or the transaction type, one of these versions needs to be called. The logic for this decision can be placed in your core system or within an Excel model, known as the traffic director model.

Traffic Director Model

The traffic director model makes decisions based on the policy effective date, transaction type, and other factors to determine which version of the Cyber Raider to call. Let's explore how to implement this:

Implementation Steps

  1. In the designated folder, locate two models: the cyber traffic director and the Cyber Raider.

  2. Examine the Cyber Raider model to see the five versions available for decision-making.

  3. Integrate the traffic director model with your admin system or workbench.

  4. Download the traffic director model, which is a simple stylized template available for implementation assistance.

Traffic Director Calculation

The traffic director's goal is to arrive at a calculation in cell M71, indicating the version to call, such as 0.5. The calculation is driven by:

  • Policy effective date

  • Transaction type

  • Decision table with several rules

Different inputs may lead to different version selections, such as version 3 or version 2.

X Calls to Cyber Raider

Once the version to call is determined, X calls are made to the downstream Cyber Raider:

  • Call Cyber Raider 0.5.0, passing in all necessary inputs.

  • Request the total premium to be returned.

  • Make a similar call for a different set of outputs, such as the entire premium table.

Outputs are tagged as X output premium table and X output total premium, allowing the calling system to receive these outputs.

Conclusion

This straightforward model saves time in implementation and shifts business logic back to the business, aligning with our goals. We are happy to assist with your implementation and provide the template if needed. Feel free to reach out to us. Thank you very much.