...
- Create a Performance Calculation report profile to use for calculating monthly data.
To do so, you can copy the report profile you use to calculate daily returns, and then edit the copy. For example, create a Daily report profile to calculate daily returns and Monthly report profile to calculate monthly returns. See the following figure.
- In the Step 1 dialog box for the monthly report profile:
Specify a frequency of Monthly.
Select the appropriate date period for the month.
Click the Rules button. See the following figure.
- In the Report Rules area, select the same report rule that you use to calculate daily performance data.
The underlying report rule requires a grouping rule that matches the performance model used for the daily data. You typically map the committed monthly data to the same PERFORM database column where you store the corresponding daily data. The system uses the Daily/Monthly frequency to differentiate the daily from monthly results. - Select a field rule that points to a field rule that includes month to date Performance Link Analysis fields to override the field rule associated with the daily report profile.
Ensure that you use only a Performance type Source Rule by overriding the source rule you use to calculate your daily data, because you must have no position source and no cash activity source specified to process data.
The Performance source is the source that Eagle Performance uses when it commits performance data, such as Eagle PACE. It is likely that the underlying source rule for the daily Performance Calculation report has both position and cash activity sources specified. If you use that underlying source rule, the system processes data below the Total level based on securities held in positions and cash activity and cannot process data below the Total level for entities with no holdings, such as benchmarks and custom benchmarks.
- Click Next to display the Step 2 dialog box for the monthly report profile. See the following figure.
- In the Security Commit Options section, select either None or Rollup Relations with Security Level, as follows:
Select None if you do not want the report to retrieve security level performance data.
Select Rollup Relations with Security Level if you want the report to retrieve security level performance data.
Do not select Rollup Relations only. This setting determines whether the report retrieves security level performance data, regardless of whether you commit returns. - Continue to configure the report profile.
...