- 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. |
|
