• Private Passenger - Monthly
  • Exposure and Premium by Territory
  • Private Passenger Exposure and Premium by SDIP
  • 2006 - 2010
  • Private Passenger Exposure by Territory & SDIP
  • 2006 and Subsequent
  • Private Passenger - Quarterly
  • Claim Count Triangle
  • Loss Triangle
  • Exposure and Premium Triangle
  • Commercial - Monthly
  • Exposure and Premium by Territory
  • Commercial - Quarterly
  • Claim Count Triangle
  • Loss Triangle
  • Premium Triangle

  • Help for Volume Analysis Data Cubes
  • Additional Applications in
    Market
  • Producer Code Notification
  • Rate Information
  • Residual Market Volume
 

Market Report & Applications - Book of Business Information

General Cube Help

Data cubes are used to efficiently store a significant volume of data and allow access to that data through the use of automated querying tools. The database is defined by the following components:

Title: Description:
Measures: Data values, or facts that the users will analyze. For example, measures may include exposures, premium or losses.
Dimensions: Business categories that provide context to the measured elements. These include year, class, territory, car id code, and more. (A complete explanation of each dimension included in this table is provided in the "About the Data" section of this help screen.)
Filters: Allow the user to more specifically define the dimensions of their analysis.

The user will define a report to be generated using the following steps:

1. Select one dimension to include in rows and one dimension to include in columns.
2. Select the measure to be analyzed.
3. Select filters in order to further specify the data to be include, such as a policy year (e.g. 2003), agent type (e.g. voluntary agent), coverage (e.g. no-fault), etc.
4. Click "Submit" to execute the query.
5. Review results on the screen.
6. Click "Export to Excel" (optional) to export results to a spreadsheet for further analysis and/or report preparation.


Exposure by Territory & SDIP -- Private Passenger

This cube measures private passenger property damage liability exposure data in the dimensions listed below. Cession rate is also measured as a percentage of written exposures.

Title: Description:
CoNo: Users may select data for their company, their group of affiliated companies, or for the industry total.
PolYr/EffQtr: The cubes contain up to five policy effective years of data. Prior years are evaluated at 12 months, while the current year reflects the most recent data available. Policy Effective Quarter is designated by Qtr 1 or Qtr 2-4. Qtr 1 relates to policies effective January - March, and Qtr 2-4 relates to policies effective April - December for each policy year.
Volerp: This element identifies business from a voluntary agent or an ERP.
Cedret: This element identifies whether business is ceded or retained.
SDIP Step/Point: This element identifies the volume of business written for each SDIP Step/Point.
Territory: Territory is defined using the configuration in place during the respective policy effective year / policy effective quarter.
Classtype: Data can be viewed for all class types combined or separately for "pure" private passenger or private passenger motorcycles and miscellaneous classes.
Statrateclass: This grouping of statistical and rating classifications parallels the definitions used for Rule 12 credit indications.
Rate: Data can be viewed by rating classification.
Stat: Data can be viewed by statistical classification.
CarIdCode: CAR ID Code separately identifies ceded or retained business for voluntary agents or ERPs.
Measures: Data values include CAR years of exposure and cession rate information.
Rate/Stat: Data can be viewed by statistical classification within rating classification, including subtotals.

Exposure and Premium by SDIP -- Private Passenger

This cube measures premium and exposure data in the dimensions listed below. Cession rate is also measured as a percentage of written exposures. Note that written premium includes SDIP surcharge and credit premium only. In order to determine total written premium, the user must save this data to a spreadsheet file, and combine these results with manual premium contained in the Exposure and Premium by Territory cube.

Title: Description:
Cono: Users may select data for their company, their group of affiliated companies, or for the industry total.
PolYr: The cubes contain up to five policy effective years of data. Prior years are evaluated at 12 months, while the current year reflects the most recent data available.
Coverage: Coverage detail includes bodily injury, property damage liability, no-fault, collision, and comprehensive.
Volerp: This element identifies business from a voluntary agent or an ERP.
Cedret: This element identifies whether business is ceded or retained.
SDIP Step/Point: This element identifies the volume of business written for each SDIP Step/Point.
Statrateclass: This grouping of statistical and rating classifications parallels the definitions used for Rule 12 credit indications.
Classtype: Data can be viewed for all class types combined or separately for "pure" private passenger or private passenger motorcycle and miscellaneous classes.
Rate: Data can be viewed by rating classification.
Stat: Data can be viewed by statistical classification.
CarIdCode: CAR ID Code separately identifies ceded or retained business for voluntary agents or ERPs.
Measures: Values include written premium, CAR years of exposure, and cession rate information.
Rate/Stat: Data can be viewed by statistical classification within rating classification, including subtotals.

Exposure and Premium by Territory - Private Passenger

This cube measures premium and exposure data in the dimensions listed below. Cession rate is also measured as a percentage of written exposures. Note that written premium includes manual premium only, and excludes SDIP surcharges and credits. In order to determine total written premium, the user must save this data to a spreadsheet file, and combine these results with surcharge and credit premium contained in the Exposure and Premium by SDIP cube.

Title Description
Cono: Users may select data for their company, their group of affiliated companies, or for the industry total.
PolYr/EffQtr: The cubes contain up to five policy effective years of data. Prior years are evaluated at 12 months, while the current year reflects the most recent data available. Policy Effective Quarter is designated by Qtr 1 or Qtr 2-4. Qtr 1 relates to policies effective January - March, and Qtr 2-4 relates to policies effective April - December for each policy year.
Coverage: Coverage detail includes bodily injury, property damage liability, no-fault, collision, and comprehensive.
Volerp: This element identifies business from a voluntary agent or an ERP.
Cedret: This element identifies whether business is ceded or retained.
Territory: Territory is defined using the configuration in place during the respective policy effective year / policy effective quarter.
Statrateclass: This grouping of statistical and rating classifications parallels the definitions used for Rule 12 credit indications.
Classtype: Data can be viewed for all class types combined or separately for "pure" private passenger or private passenger motorcycles and miscellaneous classes.
Rate: Data can be viewed by rating classification.
Stat: Data can be viewed by statistical classification.
CarIdCode: CAR ID Code separately identifies ceded or retained business for voluntary agents or ERPs.
Measures: Values include written premium, CAR years of exposure, and cession rate information.
Rate/Stat: Data can be viewed by statistical classification within rating classification, including subtotals.

Exposure and Premium by Territory - Commercial

This cube measures commercial premium and exposure data in the dimensions listed below. Cession rate is also measured as a percentage of written premium.

Title Description
Cono: Users may select data for their company, their group of affiliated companies, or for the industry total.
PolYr: The cubes contain up to five policy effective years of data. Prior years are evaluated at 12 months, while the current year reflects the most recent data available.
Coverage: Coverage detail includes bodily injury, property damage liability, no-fault, collision, and comprehensive.
Volerp: This element identifies business from a voluntary agent or an ERP.
Cedret: This element identifies whether business is ceded or retained.
Territory: Territory is defined using the configuration in place during the respective policy effective year.
Classtypedesc: Data can be viewed separately for commercial class type as defined in CAR's Statistical Edit Package.
Classtypegroups: Data for various class types is grouped according to the descriptions identified in this selection.
CarIdCode: CAR ID Code separately identifies ceded or retained business for voluntary agents or ERPs.
Measures: Values include written premium, CAR years of exposure, and cession rate information.

Loss Triangle - Private Passenger

This cube measures historical loss data displayed in a triangle format highlighting development by accounting quarter (age). This data is provided on an inception-to-date basis (ITD), using the dimensions listed below.

Title: Description:
Measures: The measured data includes paid or incurred losses including ALAE by accident year or effective year, by effective quarter.
Company: Options include specific company data, affiliated group totals, or industry totals.
Coverage: Coverage detail includes bodily injury, property damage liability, no-fault, collision, and comprehensive.
Ced/Vol: Data can be viewed by ceded and/or voluntary status.

Loss Triangle - Commercial

This cube measures historical loss data displayed in a triangle format highlighting development by accounting quarter (age). THis data is provided on an inception-to-date basis (ITD), using the dimensions listed below.

Title: Description:
Measures: The measured data include paid or incurred losses including ALAE by accident year or effective year, by effective quarter.
Company: Users my select data for their specific company data, their affiliated group totals, or industry totals.
Coverage: Coverage detail includes bodily injury, property damage liability, no-fault, collision, and comprehensive.
Ced/Vol: Data can be viewed by ceded and/or voluntary status.

Premium and Exposure Triangle - Private Passenger

This cube measures historical private passenger premium and exposure data by policy effective year and policy effective quarter, displayed in a triangle format highlighting development by accounting quarter (age). This data can be viewed as reported on a quarterly basis or on an inception-to-date basis (ITD), using the dimensions listed below.

Title: Description:
Measures: The measured data includes premium or exposure by reported quarter or inception to date.
Company: Users may select their own company data, their affiliated group totals, or industry totals.
Coverage: Coverage detail includes bodily injury, property damage liability, no-fault, collision, and comprehensive.
Ced/Vol: Data can be viewed by ceded and/or voluntary status.

Premium Triangle - Commercial

This cube measures historical commercial premium data by policy effective year and policy effective quarter, displayed in a triangle format highlighting development by accounting quarter (age). This data can be viewed as reported on a quarterly basis or on an inception-to-date basis (ITD), using the dimensions listed below.
Title: Description:
Measures: The measured data includes premium by reported quarter or inception to date.
Company: Users may select their own company data, their affiliated group totals, or industry totals.
Coverage: Coverage detail includes bodily injury, property damage liability, no-fault, collision, and comprehensive.
Ced/Vol: Data can be viewed by ceded and/or voluntary status.

Claim Count Triangle - Private Passenger

This cube measures historical private passenger paid and incurred derived claim counts by policy year or accident year, by effective quarter. The data is provided in a triangle format highlighting development by accounting quarter (age) on an inception-to-date (ITD) basis using the dimensions listed below.

Title: Description:
Measures: The measured data includes paid or incurred claims counts by accident year or effective year.
Company: Users may select their own company data, their affiliated group totals, or industry totals.
Coverage: Coverage detail includes bodily injury, property damage liability, no-fault, collision, and comprehensive.
Ced/Vol: Data can be viewed by ceded and/or voluntary status.
Agent Type: Data can be viewed by ERP and/or voluntary agent status.

Claim Count Triangle - Commercial

This cube measures historical commercial paid and incurred derived claim counts by policy year or accident year, by effective quarter. The data is provided in a triangle format highlighting development by accounting quarter (age) on an inception-to-date (ITD) basis using the dimensions listed below.

Title: Description:
Measures: The measured data includes paid or incurred claims counts by accident year or effective year.
Company: Users may select their own company data, their affiliated group totals, or industry totals.
Coverage: Coverage detail includes bodily injury, property damage liability, no-fault, collision, and comprehensive.
Ced/Vol: Data can be viewed by ceded and/or voluntary status.
Agent Type: Data can be viewed by ERP and/or voluntary agent status.
Copyright © 1999-2022 Commonwealth Automobile Reinsurers, All Rights Reserved.