GIPS requires that firms provide the total assets under management (AUM) on compliant presentations. The firm's total firm assets are equal to the aggregate market value of all discretionary and nondiscretionary assets under management within the defined firm. The Composite Analysis report has specific fields for reporting Firm Assets and Percentage of Firm Assets figures in the report. These fields are found in the Composite Performance Analysis field category.

Eagle offers three approaches for reporting on Firm Assets for a composite:

• Performance Based Data Approach. Most robust method where you define the Firm as an ACOM, calculate Firm Assets for the Firm based on enumeration of composites, and store Firm Assets amount at the Total level in Performance tables. This approach:
  • Allows you to report historical changes in Firm membership
  • Allows you to report AUM for multiple firms in the same report
  • Allows you to convert AUM from the Firm's base currency to the composite's base currency
  • Offers a key benefit—the ease it offers in using Eagle to calculate Firm AUM.
• Entity Based Data Approach. Robust method where you define the Firm as an ACOM, and store Firm Assets amount historically at the Firm level. This approach:
  • Allows you to report historical changes in Firm membership
  • Allows you to report AUM for multiple firms in the same report
  • Allows you to convert AUM from the Firm's base currency to the composite's base currency
• Client Based Data Approach. Legacy method where you define the Firm as a Client type entity, and store Firm Assets amount at the Firm level. This method is provided for backwards compatibility.

...

When you report on Firm Assets in Composite Analysis reports using the Performance based data approach, you define the Firm as an ACOM and associate it with constituent ACOMs. Using this approach to set up Firm Assets allows you to report historical changes in Firm membership and report AUM for multiple firms in the same report. It also allows you to convert AUM from the Firm's base currency to the composite's base currency or convert to an alternate currency. The key benefit of this approach is the ease it offers in using Eagle to calculate Firm AUM.

Configuring the System for Firm Assets Data Storage

When you configure PACE for firm assets data storage when using the Performance based data approach, you use the Performance Composite (ACOM) entity type for the Firms. You use the Composites tab on the ACOM to create the GIPS composite relationships to the Firm for the purpose of calculating the Firm AUM amount. You must also associate each GIPS composite with its Firm by entering the Firm ID in the Entity Details tab for each GIPS composite.

To configure the system for Firm Assets:

1. Create a Performance Composite (ACOM) entity to represent each Firm, as follows:
   • In the Entity Details tab, specify the inception date and Base Currency for the Firm.
   • In the GIPS Composites tab, identify all of the GIPS composites in the Firm historically.
   • The system stores these membership records in the ENTITY_RANGE_DETAILS table in the RULES database. The system uses these records when you use Eagle to calculate the Firm AUM.
     Note:

...

1. • (Optional) You can create a custom entity type to represent the Firm entity type using the Performance Composite (ACOM) as the base entity type. For example, you can name the entity type "GIPS Firm" to distinguish it from other entity types. For more information, see the Creating GIPS Composites section of the GIPS Composite Management User Guide.
2. Rename a field in the ENTITY table or the ENTITY_EXTENSION table in Inventory of Tables and Fields to use for storing the Firm ID for each composite, as follows:
   • If you do not see this option, you can make the option available using the User Administration or Role Administration options in the User Administration.
   • From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator. Enter Inventory of Tables in the Start Search text box. Click Inventory of Tables and Fields (Metadata Center). You see the Inventory of Tables and Fields workspace.
     In the Tables & Fields tab, search ENTITY or ENTITY_EXTENSION, depending on which table you want to use for storage. It lists all the columns for the selected table in the RULES database.
     In the ENTITY table, you can select a User_Field field (1–25 are available). In the ENTITY_EXTENSION table, you can select a User_Char field (1–80 are available). Ensure that the field you select supports at least 8 characters, as that is the limit for Entity IDs.
   • Click Edit to edit the selected field. Give the user-defined field a description of Firm ID, select the Show in editing screens checkbox, so that the field appears in the Entity Details tab for the composite and you can edit the field in that tab, and click Save. The Inventory of Tables and Fields workspace displays your description for the user-defined field.
3. Create a field attribute for the field you renamed in the previous step. See the following figure.
   

...

1. Image Added
   
   
2. For each GIPS composite, update the Firm ID historically.
   You can manually enter the Firm ID in the Entity Details tab of the composite or you can upload this information.
   When you use the Composite Analysis report, the report uses this value to identify the proper Firm for each composite selected in the report profile. It also allows you to report Firm AUM that reflects historical changes of Firm membership.
3. Identify the process to use for calculating and storing the Firm Assets amount for each Firm, and ensure that you maintain Firm Assets amounts at the Firm level on a historic basis and going forward as part of your regular processing.
   You can use an existing Performance Calculation report or can create a specific report with calculations and columns dedicated to aggregating and storing the Firm AUM. For example, you can use a Performance Toolkit Calculations report and store the Firm AUM in the eglPrf-GrossEndMktVal column, based on the PSR_USER_ field in the PERF_SEC_RETURNS table in the PERFORM database, to use the gross end market value in AUM calculations. See the following figure. You can also upload the Firm AUM from another source to an existing column in the PERF_SEC_RETURNS table in the PERFORM database. You store this value at the Firm level at the required frequency (monthly, quarterly, annually). 
   Image Modified

...

 
Configuring the Composite Analysis Report to Report Firm Assets

This section describes how to configure the Composite Performance Analysis fields used in the Composite Analysis report when using the Performance based data approach for reporting firm assets under management.

To configure the Composite Analysis report to report firm assets:

1. Create a Firm Assets type Composite Performance Analysis field, as follows:
   • In Calculation Type, select Firm Assets.
   • In Firm Entity, select the field attribute you created to identify the Firm in which each composite is a member.
   • In Firm Value Field, select the Performance field attribute you created to store the Firm AUM for the Firm.

In this example, you select the eglPrf-GrossEndMktVal field, which is based on the PSR_USER_FLOAT2 field in the PERF_SEC_RETURNS table.
When you use this field in a report, the system uses Firm Entity to identify the correct Firm for each composite selected in the report profile, based on the date range rules specified in the report profile. It retrieves the Firm AUM for the Firm based on the column selected in the Firm Value Field, and uses the Performance Model and Source specified in the report profile to retrieve the AUM based on the date range rules specified in the report profile. See the following figure.

...

In this example, you also select the eglPrf-GrossEndMktVal field, which is based on the PSR_USER_FLOAT2 field in the PERF_SEC_RETURNS table.
When you use this field in a report, the system uses Firm Entity to identify the correct Firm for each composite selected in the report profile, based on the date range rules specified in the report profile. It retrieves the Firm AUM for the Firm based on the column selected in the Firm Value Field, and uses the Performance Model and Source specified in the report profile to retrieve the AUM based on the date range rules specified in the report profile. It uses the Use Field to identify the composite's market value, so that it can calculate the ratio of the composite's assets to the Firm's assets. See the following figure.

1. Create a Composite Analysis report rule, as follows:

...

1. Create a Composite Analysis report profile that uses the report rule you created. See the following figure. When you set up the report profile:

...

A report example follows. See the following figure. You can view the Firm AUM amount and the percentage of Firm AUM for the composite. Notice that each composite included in the report appears on a separate tab in the report results.

Anchor
_Toc6968766 _Toc6968766

Report on Firm Assets using the Entity Based Data Approach

When you report on Firm Assets in Composite Analysis reports using the Entity based data approach, you define the Firm as an ACOM, store the Firm Assets amount historically at the Firm level, and identify the Firm for each composite. Using this approach to set up Firm Assets allows you to report historical changes in Firm membership, report AUM for multiple firms in the same report, and convert AUM from the Firm's base currency to the composite's base currency.
Configure the System for Firm Assets Data Storage
When you configure PACE for firm assets data storage when using the Entity based data approach, you use the Performance Composites (ACOM) entity type for the Firms, and you store the Firm AUM amount in the Entity Details tab for the Firm. You associate each GIPS composite with its Firm by entering the Firm ID in the Entity Details tab of that composite.
To configure the system for Firm Assets:

1. Create a Performance Composite (ACOM) entity to represent each Firm, and in the Entity Details tab, specify the inception date and Base Currency for the Firm.

   Note:

   (Optional) You can create a custom entity type to represent the Firm entity type using the Performance Composite (ACOM) as the base entity type. For example, you can name the entity type "GIPS Firm" to distinguish it from other entity types. For more information, see the GIPS Composite Management User Guide.

   
   

2. Rename a field in the ENTITY table or the ENTITY_EXTENSION table in Inventory of Tables and Fields to use for storing the Firm ID for each composite, as follows:

...

In this example, you select the eglPrf-GrossEndMktVal field, which is based on the PSR_USER_FLOAT2 field in the PERF_SEC_RETURNS table.
When you use this field in a report, the system uses Firm Entity to identify the correct Firm for each composite selected in the report profile, based on the date range rules specified in the report profile. It retrieves the Firm AUM for the Firm based on the column selected in the Firm Value Field to retrieve the AUM based on the date range rules specified in the report profile. It uses the Use Field to identify the composite's market value, so that it can calculate the ratio
of the composite's assets to the Firm's assets. See the following figure.

1. Create a Composite Analysis report rule, as follows:

...

See the following figure.

1. Create a Composite Analysis report profile that uses the report rule you created. See the following figure. When you set up the report profile:

...

A report example follows. See the following figure. You can view the Firm AUM amount and the percentage of Firm AUM for the composite. Notice that each composite included in the report appears on a separate tab in the report results.

Anchor
_Toc6968767 _Toc6968767

Reporting on Firm Assets using the Client Based Data Approach

When you report on Firm Assets in Composite Analysis reports using the Client based data approach, you define the Firm as a Client type entity and associate it with constituent composites.

Configuring the System for Firm Assets Data Storage
When you configure PACE for firm assets data storage when using the Client based data approach, you use the Client entity with a client type of Firm Assets to define the Firm. You use the Relationships tab for the client to maintain the GIPS composite relationships to the Firm. You use the Client Details tab to store the Firm AUM for the Firm.
To configure the system for Firm Assets based on Client data:

...

1. Grant access for the new Client Type to the appropriate PACE Role through User Administration. In User Administration, when editing a Role, you select the Client category and select the new Firm Assets Client type for access, as shown in the following figure.

...

1. Create a Client entity to represent the Firm, as follows:

...