Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
_Toc235264554
_Toc235264554
This section describes how to configure internal reports in the Eagle Portal. Internal reports manage how the information is displayed in the Eagle Portal.

Anchor
_Toc407619069
_Toc407619069
About Internal Reports

A set of internal reports manage how the information is displayed in the Eagle Portal. You can configure and assign them to everyone, groups, or users. If all your users can use the same internal report, then assign it to everyone. If not, best practice is to configure multiples of these internal reports and assign them to various groups.

...

Security Lookup. This is ACCESS SECURITY SELECTOR type and determines the information returned in the lookup function that is available in the Security Cross Reference query. This report is optional.

Anchor
RTF380034003000360039003a00
RTF380034003000360039003a00
Anchor
_Toc407619070
_Toc407619070
Configure OLAP and Advanced Reports Field Rules

The OLAP Reports and Advanced Reports

Anchor
RTF6600690065006c0064002000
RTF6600690065006c0064002000
field rules determine the data that is displayed on reports. You need to configure these field rules before you can define the internal reports in the Eagle Portal. Refer to the Reporting Reference Guide for step-by-step instructions on creating field rules.

The following table provides specific information for configuring the OLAP and Advanced Reports field rules for some key internal reports in the Eagle Portal.

Portal Internal Report Type

Field Rules

Entity Selector

Fields with the following XML tags must be contained in the field rule:

ENTITY_ID

ENTITY_NAME

These fields are used to build the link for the Entity Selector report.

Security Lookup

Fields with the following XML tags must be contained in the field rule:

SECURITY_ALIAS

ISSUE_NAME

The Security Alias field is used as a unique identifier for the securities. The Issue Name field is used as the default sort value in the security lookup results.

Once you have configured these field rules, you can define internal reports in the Portal Query Explorer.

Anchor
RTF310033003600300036003a00
RTF310033003600300036003a00
Anchor
_Toc407619071
_Toc407619071
Set Up One Entity Selector Report for All Users

The Entity Selector report controls the fields you want to use for searching portfolios. This report is required. In this example, one Entity Selector is set up to be used by everyone at the company.

To set up one Entity Selector report for all users:

From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.

...

The following table describes each option on the Query Settings dialog box.

Option

Description

Name

Displays the name of the internal report.

Type

Displays the type of report, which is Internal.

Rule

Allows you to select a field rule. Click the ellipsis and select the Position field rule from the Select Report Rule dialog box.

The field rule must contain fields with the ENTITY_ID and ENTITY_NAME XML tags. It may also contain fields from the Entity and Entity Characteristic tables.

Source

Displays the Define Report Sources dialog box, which allows you to specify the source of the holdings data.

Filter

Allows you to define a filter.

Access

Determines whether to grant access to the internal report.

Click Next. In Assign Queries, this report is assigned to everyone by default.

Click Finish.

Anchor
RTF390035003200320031003a00
RTF390035003200320031003a00
Anchor
_Toc407619072
_Toc407619072
Set Up Entity Selector Report for Multiple Business Groups

You can set up the Entity Selector report for multiple entity selectors for different business groups. In this example, an entity selector is configured and assigned to the Portal Client Services business group.

To set up one Entity Selector report for multiple business groups:

From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.

...

In the Entity Selector Query dropdown, select Entity Selector for CS.

Click Save.

Anchor
RTF370035003800350036003a00
RTF370035003800350036003a00
Anchor
_Toc407619073
_Toc407619073
Set Up the Header Report

The Header report displays holdings information for an account in a query at the top of the query results. This report is optional. You can create one header report that is used by all your users. If your users require different header reports, you can create multiple header reports and assign them to the different business groups. This report can contain up to four fields from the Position table, the Effective Date is a required field.

In the Header Report, you can toggle between the Close Summary and View Summary views.

To set up one Header Report for all users:

From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.

...

The following table describes each option on the Query Settings dialog box.

Option

Description

Name

Displays the name of the internal report.

Type

Displays the type of report, which is Internal.

Rule

Allows you to select a field rule. Click the ellipsis and select the Position field rule from the Select Report Rule dialog box.

The field rule must contain the Effective Date from the Position table.

Source

Displays the Define Report Sources dialog box, which allows you to specify the source of the accounts for reporting.

Filter

Allows you to define a filter.

Access

Determines whether to grant access to the internal report.

Click Next. In Assign Queries, this report is assigned to everyone by default.

Click Finish.

Anchor
RTF340030003500330034003a00
RTF340030003500330034003a00
Anchor
_Toc407619074
_Toc407619074
Set Up One Security Lookup Report

The Security Lookup report defines the fields that are displayed in the results of the Security Cross Reference query. This report is optional. The example below shows that one Security Lookup Report is set up to be used for everyone.

To set up one Security Lookup Report for all users:

From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.

...

The following table describes each option on the Query Settings dialog box.

Option

Description

Name

Displays the name of the internal report.

Type

Displays the type of report, which is Internal.

Rule

Allows you to specify a field rule. Click the ellipsis and select the Security field rule from the Select Report Rule dialog box.

The field rule must contain fields with the SECURITY_ALIAS and ISSUE_NAME XML tags.

Business Calendar

Displays the Define Query Business Calendar dialog box, which allows you to specify the dates on which a user can perform a query.

Filter

Allows you to define a filter.

Access

Determines whether to grant access to the internal report.

Click Next. In Assign Queries this report is assigned to everyone by default.

Click Finish.

Anchor
RTF310038003400360035003a00
RTF310038003400360035003a00
Anchor
_Toc407619075
_Toc407619075
Set Up Security Lookup Report for Multiple Business Groups

You can set up the Security Lookup Report to use multiple security selectors for different business groups.

To set up one Security Lookup Report for multiple business groups:

From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.

...