Override Link Periods in Underlying Fields

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

• Link Period Override (Date Rule)

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.

Open

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.

Open

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.

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.

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.

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:

1. Create a Performance Analysis report profile with the Link Period Override option selected, with a related date range.

2. 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.

3. 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.

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:

1. Create a Performance Analysis report profile with the Link Period Override (Date Rule) option selected, and a related Date Rule specified.

2. 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).

3. 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.