Override Link Periods in Underlying Fields
- Tom Fahey (Unlicensed)
- Jacob Mathews (Deactivated)
- Pamela Totas (Deactivated)
You can override field level linking periods at report run time by specifying different link periods in the Performance Analysis report profile. In the Performance Analysis report profile, you can specify the report effective date using two options specific to Eagle Performance:
Link Period Override Option
The Link Period Override option allows you to specify any date to any date linking. The date range you select as the Link Period Override date period serves as the report effective date and overrides one or both of the dates specified in the report's underlying fields that use linking options, that is, reporting period options that define the dates used to link returns. This includes:
Performance Analysis fields
Performance IRR Analysis fields
Performance Link Analysis (PLA) fields
Performance Risk Analysis (PRA) fields
Performance Attribution fields
Global Attribution fields
Using this option is helpful when you periodically run similar reports, but run those reports for different time periods. You can include this option in the report profile itself, or can use this option on an ad hoc basis at run time when you use the Submit with Overrides option to submit the report.
You can also use this option with Advanced Reports.
Selecting the Link Period Override Option
You can select Link Period Override from the report effective date options available when you create a Performance Analysis report profile. See the following figure. For more information, refer to Create a Performance Analysis Report Profile.
When you select the Link Period Override option as the date period for a Performance Analysis report profile, you can enter a date range as the Link Period Override. You can specify a start date and end date that differ, or can set the start and end date to the same date for a single day analysis. See the following figure.
Applying Dates with the Link Period Override
When you apply a Link Period Override to a report profile, the report applies the report profile dates to any linking fields configured with the Between dates option in the report Field Rule and overrides the field level hard coded dates. It processes all other types of linking fields and Performance Analysis fields by applying the report profile "To" date as the end effective date for the fields.
For Performance Link Analysis (PLA) and Performance Risk Analysis (PRA) fields, you can use the Link Period Override option to enter a start date and end date, and to override one or both of those dates in the field rule, depending on the type of linking period you specified at the field level.
An example of these field level options appears in the following figure. For more information about these options, refer to Performance Link Analysis Field Linking Options.
The following table describes the linking options you can specify for PLA and PRA fields and describes how Eagle Performance applies the Link Period Override dates you specify for the report profile.
PLA/PRA Field Level Linking Option | When Link Period Override applied at Report Profile |
|---|---|
Use Prior Observations, Months, Quarters, Years | The field with the linking period uses the report profile's end date. The field calculates the appropriate begin date. |
Between Two Dates | The field with the linking period uses both the report profile's begin date and end date. |
Date Rule | The field with the linking period uses the report profile's end date. The field calculates the proper begin date according to the date rule parameters. |
To-date returns | The field with the linking period uses the report profile's end date. The field calculates the appropriate begin date. |
For attribution fields, you can use the Link Period Override option only to override linking periods entered through a fixed date date range to achieve "any date to any date" attribution. For more information, refer to the Attribution Guide.
Link Period Override Option Example
The following example illustrates how the system processes Performance Analysis (PA) and Performance Link Analysis (PLA) fields in a Performance Analysis report when you apply a Link Period Override at the report profile level.
The Performance Analysis report contains the following fields in its field rule.
Field | Name | Description |
|---|---|---|
1 | Beginning Market Value | Performance Link Analysis field configured using Daily frequency Begin Market Value Performance Analysis field and Link Option #2 – a custom defined link period (From 01/10/2003 To 01/17/2003). |
2 | Ending Market Value | Performance Analysis field configured using Daily frequency for Market Value. |
3 | Daily Return | Performance Analysis field configured using Daily frequency for Return. |
4 | Ad Hoc Return | Performance Link Analysis field configured using a Daily frequency Return Performance Analysis field and Link Option #2 – a custom defined link period (From 01/10/2003 To 01/17/2003). |
5 | Inception to Date Return | Performance Link Analysis field for Return using Link Option #4 – I want to Calculate Inception to Date. |
6 | Inception to Date as of Prior Day | Performance Link Analysis field for Return configured using a Date Rule. |
The following table compares the linking periods you obtain during processing for these fields under two scenarios. In the first scenario, you submit the report with a report profile End Effective Date of 01/31/2003. In the second scenario, you submit the report with a report profile that includes a Link Period Override of 11/04/2002 to 12/13/2002.
Field | Name | Type | Field Description | Profile Report End Effective Date of 01/31/2003 Results in Linking Period | Link Period Override of 11/04/2002 – 12/13/2002 Results in Linking Period |
|---|---|---|---|---|---|
1 | Beginning Market Value | PLA | Uses Daily frequency Begin Market Value Performance Analysis field and custom defined link period (From 01/10/2003 To 01/17/2003). | Beginning Market Value as of 01/10/2003 (that is, Ending Market Value from 01/9/2003) | Beginning Market Value as of 11/4/2002 (that is, Ending Market Value from 11/01/2002) |
2 | Ending Market Value | PA | Uses Daily frequency for Market Value. | Ending Market Value as of 01/31/2003 | Ending Market Value as of 12/13/2002 |
3 | Daily Return | PA | Uses Daily frequency for Return. | One Day Return as of 01/31/2003 | One Day Return as of 12/13/2002 |
4 | Ad Hoc Return | PLA | Uses Daily frequency Return Performance Analysis field and custom defined link period (From 01/10/2003 – 01/17/2003). | Daily Linked Return for the Period From 01/10/2003 – 01/17/2003 | Daily Linked Return for the Period From 11/4/2002 – 12/13/2002 |
5 | Inception to Date Return | PLA | Uses I want to Calculate Inception to Date. | Inception to Date return as of 01/31/2003 | Inception to Date return as of 12/13/2002 |
6 | Inception to Date as of Prior Day | PLA | Uses Date Rule. | Inception to Date return as of 01/30/2003 | Inception to Date return as of 12/12/2002 |
Using the Link Period Override Option in Advanced Reports
You can use the Link Period Override option with Advanced Reports for Performance Analysis. You do not select the Link Period Override option itself at the Advanced Report level, but can enter the dates used for the Link Period Override.
To use a Link Period Override with an Advanced Report for Performance Analysis:
Create a Performance Analysis report profile with the Link Period Override option selected, with a related date range.
When you create the Advanced Report Rule you plan to associate with the Advanced Report and are assigning Performance Analysis report profiles to that Rule, select the Force dates check box for the Performance Analysis Profiles associated with the Link Period Override.
When you create the Advanced Report, in the Advanced Report Profile tab, where you can set advanced report profile settings, including advanced report rules, entities, and effective date, ensure you select the Between option as the effective date period and enter the date range you are using for the Link Period Override.
When you choose the Between dates option in the Advanced Report profile and input the From and To dates, the system passes those dates to the Performance Analysis report profiles that are part of the Advanced Report and processes the Link Period Override as it does for a Performance Analysis OLAP report.
For more information about setting up Advanced Reports, refer to the Advanced Reporting User Guide.
If you fail to perform these steps, the system processes the report as if you did not select the Link Period Override. It uses the Performance Analysis profile dates rather than the dates you input in the Advanced Report profile.
Link Period Override (Date Rule) Option
When you select the Link Period Override (Date Rule) option as the date period for a Performance Analysis report profile, you can select a Date Rule to use as the Link Period Override.
The Link Period Override (Date Rule) option allows you to override linking periods entered using a fixed date date range or a date rule for:
Performance Analysis fields
Performance IRR Analysis fields
Performance Link Analysis (PLA) fields
Performance Risk Analysis (PRA) fields
Performance Attribution fields
Global Attribution fields
If you use fields with fixed date linking periods, the report profile uses the begin date and end date associated with the date rule in place of the fixed dates specified at the field level. It uses the date rule's end date as the "as of" date for the date rule.
If you use fields with date rules as linking periods, the report profile overrides the begin and end dates associated with field level date rule with the begin and end dates associated with the profile level date rule.
Using this option is helpful when you periodically run similar reports, but run those reports for different rolling time periods. You can use the same fixed date fields in each report, while using the Link Period Override with Date Rule option to change the time period for each report profile. You can include this option in the report profile itself, or can use this option on an ad hoc basis at run time by specifying them when you use the Submit with Overrides option to submit the report.
For example, assume you run three reports, a one-year rolling report, a three-year rolling report, and a five-year rolling report. These reports, which you run every month, contain different calculations and statistics. If you do not use this option, you build each field three times, one for each time period, and then build the reports by assigning those the field that corresponds with the time period of that report. However, if you use this option, you can build the field once as a fixed date field and use that field in all three reports. Then, by using Linked Period Override (Date Rule) at the profile level, you can apply the rolling time period date rules to override these fixed date fields.
If you choose the Link Period Override (Date Rule) option and use it to select an Inception to Date or a Fiscal Year to day type date rule, be sure to only use the report profile with a single entity. Otherwise, if you use the option with multiple entities, the report applies the first entity's inception date (or fiscal date) to all entities in the report profile.
Selecting the Link Period Override (Date Rule) Option
You can select Link Period Override (Date Rule) from the report effective date options available when you create a Performance Analysis report profile. See the following figure.
When you select the Link Period Override (Date Rule) option, you can enter a date rule as the Link Period Override. See the following figure.
Using the Link Period Override Option in Advanced Reports
You can use the Link Period Override (Date Rule) option with Advanced Reports for Performance Analysis. You do not select the Link Period Override (Date Rule) option itself at the Advanced Report level, but can enter an as-of date used for the Link Period Override (Date Rule).
To use a Link Period Override (Date Rule) with an Advanced Report for Performance Analysis:
Create a Performance Analysis report profile with the Link Period Override (Date Rule) option selected, and a related Date Rule specified.
When you create the Advanced Report Rule you plan to associate with the Advanced Report and are assigning Performance Analysis report profile to that Rule, select the Force dates check box for the Performance Analysis Profile associated with the Link Period Override (Date Rule).
When you create the Advanced Report, in the Advanced Report Profile tab, where you can set advanced report profile settings, including advanced report rules, entities, and effective date, select the As of option as the effective date period and enter the corresponding as-of date you are using for the Link Period Override (Date Rule).
When you choose the As of option in the Advanced Report profile and input the as-of date, the system passes that date to the Performance Analysis report profiles that are part of the Advanced Report and processes the Link Period Override (Date Rule) as it does for a Performance Analysis OLAP report.
For example, you specify February 15, 2011 as the Advanced Report's as-of date, and your Performance Analysis report includes a Link Period Override (Date Rule) where the Date Rule is Month to Date. In this case, the report calculates a month to date as of February 15, 2011, and uses that period to override the field-level dates associated with the report.
For more information about setting up Advanced Reports, refer to the Advanced Reporting User Guide.
If you fail to perform these steps, the system processes the report as if you did not select the Link Period Override (Date Rule). It uses the Performance Analysis profile dates rather than the date you input in the Advanced Report profile.