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.
Query portfolio results save to Cloud
There are a number of queries you can run against saved portfolio results in DBeaver.

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.

Query portfolio results save to Cloud

There are a number of queries you can run against saved portfolio results in DBeaver.

Before You Begin

This functionality gives you access to high resolution data that was previously unavailable in the Touchstone Re loss dashboard or SQL tables generated by the application for analyses run with the Analyze Re Portfolio Rollup option. There are a number of queries you can run against saved portfolio results in DBeaver. Specifically event losses by treaty/portfolio, geography, zone and line of business can now be queried. Touchstone Re has integrated with the DBeaver universal database management tool (Community Edition is free).

Note: DBeaver requires a one time configuration to be accessible to users. Refer to the Install and configure topic for details.

To query results on the Cloud:

Procedure

In the main Touchstone Re Portfolios pane, select a portfolio.
Select Query Cloud Results from the drop-down.
Locate and open the AIRResult database;select View Data.

Several tables and views will be populated with the results of your portfolio analyses. Items prefixed with "t_" are tables and those prefixed with "v_" are views.
Run queries on the results using the DBeaver application. Use the DBeaver online help for guidance.
Note that it is easier to query using views rather than tables.