1. User Guide
  2. Application Workflow
  3. Level of Aggregation
  4. Create a New Level of Aggregation Definition

4.2.3 Create a New Level of Aggregation Definition

Perform the following steps to create a new level of aggregation definition:
  1. In the Level of Aggregation table, click Add to open the Aggregation Level Window.
  2. Populate the Aggregation Level pane.

    Table 4-2 The Aggregation Level form

    Field Description
    Fields marked with asterisks (*) in the window are mandatory.
    Aggregation Level pane
    Name* Enter a name for the Level of Aggregation Definition.
    Description Enter a short description of the Level of Aggregation Definition.
    Folder* Select a folder from the drop-down list.
    Legal Entity*

    Click HierarchySelection adjacent to this field. Select the required Legal Entity from the Hierarchy Selection Window.

    For more information, see Hierarchy Selection.

    Line of Business*

    Click HierarchySelection adjacent to this field. Select the required Line of Business from the Hierarchy Selection Window.

    For more information, see Hierarchy Selection.

    Code* Enter the code for Calculation Preferences.
    Portfolio Dimensions pane
    All the fields in this pane require you to enable or disable the fields using the enable or disable options.
    Geography

    Click the icon to enable this field. Click HierarchySelection adjacent to the text field. Select the required Geography from the HierarchySelection Window.

    For more information, see Hierarchy Selection
    Product*

    Click HierarchySelection adjacent to this field. Select the required LegalEntity from the HierarchySelection Window.

    For more information, see Hierarchy Selection.

    Currency* Select the required currency from the drop-down list.
    Coverage Type

    Select the required coverage types from the drop-down list.

    The values in this field are seeded and come from the Staging Tables. The data is then moved to the Dimension Tables. Once these actions are completed, the values are populated in this field.
    Policy Term

    Select the policy term from the drop-down list.

    The values in this field are seeded and come from the Staging Tables. The data is then moved to the Dimension Tables. Once these actions are completed, the values are populated in this field.
    Cohort Period*

    Select the Cohort Period from the drop-down list. The available options are:

    • Annually
    • Half Yearly
    • Quarterly
    • Monthly

    You can select the Cohort Duration based on the financial year. If the Cohort Duration is selected as Annual, then all the contracts which are issued within one year are grouped. For example, if the financial year starts in April, then all the contracts commencing from April to March are grouped as a single cohort.
    Run Type

    Depending on the value selected in the Application Configuration section for the

    This flag indicates Consolidation Criteria. List of Values are E -> Computation based on Solo data, N -> Consolidated data as an Input field, and the default Run Type is displayed:

    • If the Computation based on Solo data value was selected, then the default Run Type is Solo and this field is disabled.
    • In case the Run Type was selected as Consolidated for an LOA, then this field is disabled when you try to modify an LOA. If the Consolidated data as Input value was selected in the Application Configuration screen, then the default Run Type is Consolidated.
    Reinsurance Held Click the icon to enable reinsurance for the Aggregation Level.
    Fund Type

    Select the required fund type from the drop-down list.

    The values in this field are seeded and come from the Staging Tables. The data is then moved to the Dimension Tables. Once these actions are completed, the values are populated in this field.
    Premium Frequency

    Select the required premium frequency from the drop-down list.

    The values in this field are seeded and come from the Staging Tables. The data is then moved to the Dimension Tables. Once these actions are completed, the values are populated in this field.
    Distribution Channel

    Select the required distribution channel by clicking the Hierarchy Icon adjacent to this field.

    The values in this field are seeded and come from the Staging Tables. The data is then moved to the Dimension Tables. Once these actions are completed, the values are populated in this field.
    Business Unit

    Click the icon to enable the Business Unit Dimension.

    Click HierarchySelection adjacent to this field. Select the required Business Unit from the HierarchySelection Window.

    For more information, see Hierarchy Selection.

    Industry Sector

    Select the required industry sector from the drop-down list.

    The values in this field are seeded and come from the Staging Tables. The data is then moved to the Dimension Tables. Once these actions are completed, the values are populated in this field.
  3. Click Save.

    The saved definition is displayed in the Aggregation Summary table in the Level of Aggregation Window.

    The Audit Trail pane at the bottom of the Definition window displays the Created By, Creation Date, Last Modified By, and Last Modification Date details. The User Comments field enables you to add additional information as a comment.