Home
Analysis
An analysis in Touchstone Re is a probabilistic analysis of your aggregated loss or exposure data.
Analyze Re Rollup
Analyze Re Rollup is a feature in Portfolio analysis which aggregates high resolution loss results and saves these results to the Cloud.
Install and configure DBeaver
You need to install and configure DBeaver before you can use it.

Introduction
Introduction to the Touchstone Re application.
Companies
A company is unique entity in Touchstone Re.
Company data (exposures)
Companies are associated with exposure data.
Programs
A program is integral to a company and it's exposure data in Touchstone Re.
Portfolios
A portfolio is a group of treaties selected from across companies.
Import
Import exposure data from external sources into Verisk databases.
Export
Export exposure data, results, reports, and companies out of Touchstone Re.
Loss results
The Loss Results pane for a company lists all loss analyses that have been executed for the company.
Analysis
An analysis in Touchstone Re is a probabilistic analysis of your aggregated loss or exposure data.
- Use cases
- Create a loss analysis
  Steps to create a loss analysis inTouchstone Re.
- Multi-year analysis
  Steps to generate a multi-year analysis in Touchstone Re.
- Run a program analysis
  Steps to run a Touchstone Re program analysis.
- Run a portfolio analysis
  Steps to run a Touchstone Re portfolio analysis on an established portfolio.
- Loss diagnostics
- CLF loss market share for enhanced ALERT analysis
- Pandemic analysis
  Verisk offerings include a pandemic model.
- Custom ILFs for China
  To offer policy term flexibility clients can now customize China crop policy deductibles by peril, crop, and province.
- Results
  The result type determines how and what results appear in the Loss Results pane.
- Select an event set
  Select the appropriate event set for the exposures you are analyzing from the Event Set list.
- Analyze Re Rollup
  Analyze Re Rollup is a feature in Portfolio analysis which aggregates high resolution loss results and saves these results to the Cloud.
  - Include in Analyze Re Rollup
    When the toggle Include in Analyze Re Rollup is enabled in the New Portfolio Analysis pane, certain parameters and fields change or are disabled.
  - Results saved to database
    All portfolio loss tables are saved to the AIRResult database, however, not all tables are populated due to the size of the data.
  - Query portfolio results save to Cloud
    There are a number of queries you can run against saved portfolio results in DBeaver.
  - Clear Cloud results
    Sometimes it is necessary to clear cache on the Cloud and re-analyze the whole portfolio (e.g. updated currency rate table).
  - Install and configure DBeaver
    You need to install and configure DBeaver before you can use it.
Tools
Tools to manage Touchstone Re and its data.
Administration console
The Administration Console enables authorized users to manage a suite of administrative tasks.
Reference
Supporting information on various topics associated with Touchstone Re.

Install and configure DBeaver

You need to install and configure DBeaver before you can use it.

Verisk Technical Support will need to give you access to the cloud where your loss data can be queried from. Contact them for assistance when you are ready to install DBeaver. They will need the following information when you contact them:

Database server name
Version and build of the AirResultRe database

You can obtain this information by running the following query.

Query

SELECT [ServerName],[Version], [CodeVersion] FROM [AIRResultRe].[dbo].[tDbHistory] H INNER JOIN [AIRResultRe].[dbo].[tDBVersion] V ON H.EndVersion = V.[Version] AND H.[EndCodeVersion] = V.[CodeVersion]

Query output


ServerName	SystemVersion	SystemCodeVersion (build)
myServer\TOUCHSTONE	10.0.0	476

Note: mylicense ` and myserver are generic terms and will actually show the license and server specific to the client installation.

Procedure

Download the latest Window Installer version of the DBeaver application from https://dbeaver.io/download/ and install (unzip and run) it on the Touchstone Re workstation in C:\Program Files\DBeaver.
Launch Touchstone Re and select
In the main Portfolios pane, select Query Cloud Results from the drop-down.
When the DBeaver main window first opens you will need to configure DBeaver for you installation
1. Click .
2. In the Select Your Database dialog, connect to the Amazon Athena database.
3. Click the Driver Properties tab.
4. Click Download to download the Athena driver.
Once the download is finished, locate TouchstoneRe/Log/airsqlaccess-data.json.
You will use the information in this file to configure for your specific installation in the following steps.
In the left pane, right mouse click on sql-output then select Edit Connection
1. Open Connection Settings and stay on the Main tab.
2. If the default region is not correct then make another selection from the drop-down.
3. Set S3 Location to the location noted in the json file above.
4. In the Authentication section remove any username and password.
5. In this same tab, set Workgroup to sqlaccess-wg-mylicense (also paste to right).
  The top parameters in this tab are preset as indicated in the following image.
6. Click Ok.
Exit DBeaver.
You may need to run a script on the AIRResult database in DBeaver; refer to Update loss results databasefor more information.