Manage Aggregates

In the Portfolio Desk's All workspace, you can create Aggregate entities. You can also create Aggregate entities from the Composite workspace.

About Aggregates

An aggregate is the grouping of two or more entities that allocates a percentage of each individual entity to form the aggregate entity. You can add any type of individual entity to an aggregate except for a list entity.

There are four types of aggregates:

  • Regular Aggregate: The grouping of two or more entities that allocates a percentage of each individual entity. The allocation percentage is a static weight, which is set during aggregate creation. It can comprise of more than 100% weightage from other entities. For example, 30% of value from Ent1, 50% of value from Ent2 and 40% of value from Ent3. Total Percentage is 120%.

  • Floating Weight Aggregate: The grouping of two or more entities that allocates a percentage of each individual portfolio. This is identical to regular aggregate except the weight used to determine the allocation ratio is calculated dynamically.

  • Target Weight Aggregate: A Target Weight Aggregate is one portfolio made up of specific percentages of other portfolios. The percentage does not change on a day‐to‐day basis. Used primarily for Blended Benchmarks. It comprises of cumulative 100% weightage from other entities. For example, 40% of value from Ent1, 40% of value from Ent2 and 20% of value from Ent3. Total Percentage is 100%.

  • Dynamic Aggregates: Allows the user to look at the true exposure of an industry or country when there is a fund of funds situation or when one fund invests in another. 

Select a Policy

In the Create New dialog box, you select an Aggregate entity type policy to create an aggregate entity.

To select a policy:

  1. In Portfolio Data Center, from the left navigation, select Portfolio Desk > All. Or select Portfolio Desk and click Composites.
    By default, you can create Aggregate entity from both the workspaces.

  2. On the Home tab, in the Manage group, click Create New.
    You see the Create New dialog box. 

  3. In the Select Policy list, select a policy for the aggregate entity you want to create. 
    By default, you see the available lists of predefined policies.

  4. Click OK.
    You see the Details page displaying the selected policy's field groups.

Provide Entity Details

In the Create New Aggregate wizard's Details page, you can provide the details about the entity. Based on the policy you select, you need to provide the appropriate information.

To add basic entity details:

  1. In the Effective Date, specify the effective date for the entity. Or use the Date selector to provide the appropriate date for the entity.
    This field identifies the date by which the entity is eligible for processing. You can specify an effective date in the past or future.  
    By default, you see the system date as the effective date.

  2. In the Entity ID box, type a unique id for the entity.

  3. In the Entity Name box, type a name for the entity.
    You see the Details page with the list of the selected policy's field groups and their corresponding fields.

  4. Provide appropriate information for each field, as needed.

  5. Click Next
    You see the Aggregate page. 

Provide Aggregate Details

In the Create New Aggregate wizard's Aggregate page, you can select the aggregate type and provide appropriate information, as needed. 

To provide aggregate details:

  1. In the Entity Build Settings section, click the Source list to select the source interface the system can use for the added entity positions.
    By default, you see the list of all the available sources.

  2. Click the FX Source Rule list to select a FX rule for the FX rate. The FX source rule identifies the original source data to use for the FX rate, in the order of top-down preference. The FX source rule lists only those sources that are assigned to the foreign exchange (FXG) feed type and are available to the user’s business group. The sequence of the sources tells the Entity Build engine the priority.

  3. In the FX Date box, specify the number of days the Entity Build engine can go back in time to search for FX rates from the effective date submitted.

    Note: Using the effective date and FX source rule, the Entity Build engine attempts to find FX rates by date and then source. In other words, the engine tries to find the FX rates against the first source in the rule in which the effective date equals the build date. If not found, the engine tries to find the rate against the second source in which the effective date equals the build date. If it is still not found, the engine repeats the process using the prior date (effective date – 1). This continues until the engine exhausts all combinations of date and sources as dictated by the FX Date or as configured in the system parameters.

  4. In the Constituents section, click the Aggregate Type list to select the type of aggregate. Options include:
    - Regular
    - Floating
    - Target
    - Dynamic
    By default, the system populates the Regular type.

  5. In the As of Date, the system displays the given effective date in the Details page.
    This is the date as on which the relationship between the aggregate and the entity takes effect. 

  6. Click the Entity Name label to search the entities based on the selected option. Options include:
    - Entity ID
    - Entity Name
    - Entity Long Name
    - Entity Legal Name
    Based on the selected option, you see the values in the adjacent drop-down list. By default, you see the list of Entity Names.

  7. Click the drop-down list and select one or more entities you want to add to the Aggregate, as needed.
    When you select an entity, the system displays the entity's id, name, long name and entity type in the Entity section. 

  8. Click the Weight field of each entity and specify the target percentage the entity has in the Aggregate.
    The system uses this field to store the weight for an entity associated with an Aggregate type. 

  9. Click Next.

Provide Assignment Details

To add assignment details:

  1. In the Benchmark page, you assign benchmarks, as needed for the entity.

  2. In the Peer Group Association page, you assign peer groups, as needed for the entity.

  3. In the Disclosures page, select one or more disclosures as needed for the entity.

  4. In the Asset Mix Policy page, select one or more asset mix policies as needed for the entity.

  5. In the Fee Schedule page, select a fee schedule for the entity.

  6. Click Save to save the aggregate entity.
    You see a message stating successful entity creation. The system generates the aggregate entity and lists it in the Composite workspace.