Table SALES_FORECAST_ANALYSIS

DescriptionThe analysis and comparison of market and company forecasted measures, in terms of policy volumes, premium income, market share and growth rate.
Dimensions:
- Time (grain: month)
- Geographic area(grain: state)
- Line of business

Columns
FORECASTED_AVERAGE_PREMIUM_AMOUNT_PER_POLICYFORECASTED_AVERAGE_PREMIUM_AMOUNT_PER_POLICY
FORECASTED_GROWTH_RATEFORECASTED_GROWTH_RATE
FORECASTED_MARKET_SHAREFORECASTED_MARKET_SHARE
FORECASTED_NUMBER_OF_POLICIESFORECASTED_NUMBER_OF_POLICIES
FORECASTED_PREMIUM_INCOME_FROM_ENDORSEMENTSFORECASTED_PREMIUM_INCOME_FROM_ENDORSEMENTS
FORECASTED_PREMIUM_INCOME_FROM_NEW_BUSINESSFORECASTED_PREMIUM_INCOME_FROM_NEW_BUSINESS
FORECASTED_PREMIUM_INCOME_FROM_RENEWALSFORECASTED_PREMIUM_INCOME_FROM_RENEWALS
FORECASTED_TOTAL_PREMIUM_INCOMEFORECASTED_TOTAL_PREMIUM_INCOME
MARKET_FORECASTED_AVERAGE_PREMIUM_AMOUNT_PER_POLICYMARKET_FORECASTED_AVERAGE_PREMIUM_AMOUNT_PER_POLICY
MARKET_FORECASTED_NUMBER_OF_POLICIESMARKET_FORECASTED_NUMBER_OF_POLICIES
MARKET_FORECASTED_TOTAL_PREMIUM_INCOMEMARKET_FORECASTED_TOTAL_PREMIUM_INCOME
DISTRIBUTION_CHANNEL_IDDISTRIBUTION_CHANNEL_ID
GEOGRAPHIC_AREA_IDGEOGRAPHIC_AREA_ID
TIME_DIMENSION_IDTIME_DIMENSION_ID
DISTRIBUTION_CHANNEL_MINI_DIMENSION_IDDISTRIBUTION_CHANNEL_MINI_DIMENSION_ID
GEOGRAPHIC_AREA_MINI_DIMENSION_IDGEOGRAPHIC_AREA_MINI_DIMENSION_ID
FORECASTED_CONVERSION_RATEFORECASTED_CONVERSION_RATE
FORECASTED_CROSS_SELL_RATEFORECASTED_CROSS_SELL_RATE
LINE_OF_BUSINESS_IDLINE_OF_BUSINESS_ID
FORECASTED_NUMBER_OF_NEW_POLICIESFORECASTED_NUMBER_OF_NEW_POLICIES
FORECASTED_NUMBER_OF_NEW_CUSTOMERSFORECASTED_NUMBER_OF_NEW_CUSTOMERS
FORECASTED_NUMBER_OF_RENEWALSFORECASTED_NUMBER_OF_RENEWALS
FORECASTED_RETENTION_RATEFORECASTED_RETENTION_RATE

Foreign Key
SALES_FORE_CHAN_FKSALES_FORE_CHAN_FK
SALES_FORE_GEOG_FKSALES_FORE_GEOG_FK
SALES_FORE_CALE_FKSALES_FORE_CALE_FK
SALES_CHANNEL_R_FKSALES_CHANNEL_R_FK
SALE_GEOGRAPHIC_FKSALE_GEOGRAPHIC_FK
SALES_FORE_PROD_FKSALES_FORE_PROD_FK

Primary Key
SALES_FORECAST_ANALYSIS_PKSALES_FORECAST_ANALYSIS_PK

Column Details

 FORECASTED_AVERAGE_PREMIUM_AMOUNT_PER_POLICY
DescriptionThe insurance company's forecasted total premium income divided by the forecasted number of policies.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FORECASTED_GROWTH_RATE
DescriptionThe insurance company's forecasted total premium income for the considered period of time, divided by its actual total premium income for the previous period.
Data TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FORECASTED_MARKET_SHARE
DescriptionThe insurance company's forecasted total premium income divided by the market forecasted total premium income.
Data TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FORECASTED_NUMBER_OF_POLICIES
DescriptionThe forecasted number of policies that will be sold, endorsed or renewed by the insurance company.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FORECASTED_PREMIUM_INCOME_FROM_ENDORSEMENTS
DescriptionThe forecasted total premium income resulting from the policies that will be endorsed by the insurance company.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FORECASTED_PREMIUM_INCOME_FROM_NEW_BUSINESS
DescriptionThe forecasted total premium income resulting from the new policies that will be sold by the insurance company.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FORECASTED_PREMIUM_INCOME_FROM_RENEWALS
DescriptionThe forecasted total premium income resulting from the policies that will be renewed by the insurance company.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FORECASTED_TOTAL_PREMIUM_INCOME
DescriptionThe forecasted total premium income resulting from the policies that will be sold, endorsed or renewed by the insurance company.

Measure Calculation Formula:
[ A + B + C ]
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MARKET_FORECASTED_AVERAGE_PREMIUM_AMOUNT_PER_POLICY
DescriptionThe market forecasted total premium income divided by the market forecasted number of policies.
Data TypeDECIMAL(7 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MARKET_FORECASTED_NUMBER_OF_POLICIES
DescriptionThe forecasted number of policies that will be sold, endorsed or renewed by the whole market. Typically, this measure is expressed at country level.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MARKET_FORECASTED_TOTAL_PREMIUM_INCOME
DescriptionThe forecasted total premium income resulting from the policies that will be sold, endorsed or renewed by the whole market. Typically, this measure is expressed at country level and represents the market size.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DISTRIBUTION_CHANNEL_ID
DescriptionIdentifies the Distribution channel dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GEOGRAPHIC_AREA_ID
DescriptionIdentifies the Geographic area dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TIME_DIMENSION_ID
DescriptionIdentifies the Time dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DISTRIBUTION_CHANNEL_MINI_DIMENSION_ID
DescriptionIdentifies the Channel role mini dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GEOGRAPHIC_AREA_MINI_DIMENSION_ID
DescriptionIdentifies the Geographic Area Mini Dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FORECASTED_CONVERSION_RATE
DescriptionThe insurance company's forecasted total premium income for the considered period of time, divided by its actual total premium income for the previous period.
Data TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FORECASTED_CROSS_SELL_RATE
DescriptionThe insurance company's forecasted total premium income for the considered period of time, divided by its actual total premium income for the previous period.
Data TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LINE_OF_BUSINESS_ID
DescriptionThe unique identifier of the Category
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FORECASTED_NUMBER_OF_NEW_POLICIES
DescriptionThe forecasted number of policies that will be sold, endorsed or renewed by the insurance company.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FORECASTED_NUMBER_OF_NEW_CUSTOMERS
DescriptionThe forecasted number of policies that will be sold, endorsed or renewed by the insurance company.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FORECASTED_NUMBER_OF_RENEWALS
DescriptionThe forecasted number of policies that will be sold, endorsed or renewed by the insurance company.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FORECASTED_RETENTION_RATE
DescriptionThe insurance company's forecasted total premium income for the considered period of time, divided by its actual total premium income for the previous period.
Data TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 SALES_FORE_CHAN_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableSALES_FORECAST_ANALYSIS
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnDISTRIBUTION_CHANNEL_ID [BIGINT]
Parent TableCHANNEL_ROLE
Parent Role Nameis dimension of
Parent Multiplicity1
Unique ConstraintCHANNEL_ROLE_PK



 SALES_FORE_GEOG_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableSALES_FORECAST_ANALYSIS
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnGEOGRAPHIC_AREA_ID [BIGINT]
Parent TableGEOGRAPHIC_AREA
Parent Role Nameis dimension of
Parent Multiplicity1
Unique ConstraintGEOGRAPHIC_AREA_PK



 SALES_FORE_CALE_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableSALES_FORECAST_ANALYSIS
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnTIME_DIMENSION_ID [BIGINT]
Parent TableCALENDAR_DATE
Parent Role Nameis dimension of
Parent Multiplicity1
Unique ConstraintCALENDAR_DATE_PK



 SALES_CHANNEL_R_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableSALES_FORECAST_ANALYSIS
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnDISTRIBUTION_CHANNEL_MINI_DIMENSION_ID [BIGINT]
Parent TableCHANNEL_ROLE_MINI_DIMENSION
Parent Role Nameis dimension of
Parent Multiplicity0..1
Unique ConstraintCHANNEL_ROLE_MINI_DIMENSION_PK



 SALE_GEOGRAPHIC_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableSALES_FORECAST_ANALYSIS
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnGEOGRAPHIC_AREA_MINI_DIMENSION_ID [BIGINT]
Parent TableGEOGRAPHIC_AREA_MINI_DIMENSION
Parent Role Nameis dimension of
Parent Multiplicity0..1
Unique ConstraintGEOGRAPHIC_AREA_MINI_DIMENSION_PK



 SALES_FORE_PROD_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableSALES_FORECAST_ANALYSIS
Child Role NameVerb1
Child Multiplicity*
Key ColumnLINE_OF_BUSINESS_ID [BIGINT]
Parent TablePRODUCT_GROUP
Parent Multiplicity1
Unique ConstraintPRODUCT_GROUP_PK

Primary Key Details

 SALES_FORECAST_ANALYSIS_PK
DescriptionThe unique identifier of the Sales forecast analysis
MemberDISTRIBUTION_CHANNEL_ID [BIGINT]
MemberGEOGRAPHIC_AREA_ID [BIGINT]
MemberTIME_DIMENSION_ID [BIGINT]
MemberLINE_OF_BUSINESS_ID [BIGINT]