In the Eagle Portal, you can customize how query report results are displayed in the current view by showing results in a chart, adding or removing columns, performing rollup calculations, grouping the results by different levels, or setting up filters with complex conditions. You can manage columns by re-arranging the column order or sorting the column data. For query reports that are not grouped, you can lock a column in place for easier horizontal scrolling. For query reports that are grouped, you can drill down and expand the results for viewing at different levels. You can also create a new current view, print the current view, or copy and customize a shared view.

Access Options for the Query Current View

To access options for the query current view:

From the Eagle Portal main window, run a query report.
Click the Current View drop down menu and select the appropriate options:
–  Enable/Disable Charts. Allows you to configure query results to display in a chart format.
–  Add/Remove Columns. Allows you to manage how query result columns are displayed and manage grouped query results.
–  Save. Allows you to save the view you created.
–  Save As. Allows you to create a new view for the query report or copy and customize a shared view.
–  Advanced Filter. Allows you to create a filter for complex results filtering.
–  Print. Allows you to print the information displayed in the current view.
NOTE: For MicroStrategy reports, only the Save and Save As options are available in the Current View drop down menu.
To save your changes to the current view, click the Current View drop down menu and select Save.

Content on this page:

Enable and Configure Charts

To enable and configure query report result charts:

From the Eagle Portal main window, run a query report.
Click the Current View drop down menu and select Enable Charts.
You see the Data/Chart drop down menu displayed to the left of the Current View drop down menu.
To configure chart settings, click the Data/Chart drop down menu, select Chart, and click Manage Chart Settings.
You see the Chart window.
Select a chart type: Pie, Line, Bar, Bubble, Column, or Stacked.
Select the appropriate options for each chart type.
Click Apply Chart Settings to save your changes.
To toggle between the data and chart presentation of the results, click Data or Chart on the Data/Chart drop down menu.
NOTE: If you enabled charting for a query, you can drill down to see the details if the query has at least two grouping levels. You can also export the results of the drill down.
To disable charts, click the Current View drop down menu and select Disable Charts.
To save your changes to the current view, click the Current View drop down menu and select Save.

Manage Result Columns

To manage query report result columns:

From the Eagle Portal main window, run a query report.
Click the Current View drop down menu and select Add/Remove Columns:
–  In the Add/Remove Columns dialog box, click the column name and click the left or right arrow to add or remove columns. To add or remove all columns at once, click Add All or Remove All.
–  Click the up and down arrows to change the order of how the columns are displayed.
–  To add or manage percent fields, click Manage Percent Fields in the top right corner of the Add/Remove Columns dialog box and complete the fields in the Manage Percent Fields dialog box. Click the Update icon and click Close.
–  Click Save in the Add/Remove Columns dialog box.
Click the drop down arrow of any column heading to sort, group, or perform calculations on that column:
–  To sort a column, click the drop down arrow on the right side of the column name and select the appropriate sort option.
–  To sort multiple columns, first sort one column, then press Shift and click the next column you want to sort. To sort additional columns, click Shift again and click another column to sort.
–  To group by column, drag the column heading to the Grouped by area.
–  To perform a roll up calculation on a column, click the drop down arrow on the right side of the column name and select Rollup from the Calculation drop down menu.
To filter column data, click the drop down arrow on the right side of the column name, select the appropriate filter option, and click OK.
For queries that are not grouped, you can lock columns for easier horizontal display:
–  Click the column name and click to lock this column in place. You see a next to the column name and the column has moved to the left-most position in the window.
–  Use the horizontal scroll bar to view all the columns to the right.
–  To unlock the column, click . You see a next to the column name and the column has moved back to its original position in the window.
To save your changes to the current view, click the Current View drop down menu and select Save.
NOTE: Query report results are displayed with the default column width that may be customized by the Eagle Portal Administrator based on the requirements of your organization. For more information about customizing query report columns, refer to the Eagle Portal System Administration Guide.

Manage Grouped Result Columns

To manage grouped query report result columns:

From the Eagle Portal main window, run a query report.
To view grouped query results, click the Explode drop down menu.
You see the column names that were used for grouping and the Security Level option.
To view results grouped by a column, click the column name on the Explode drop down menu.
You see that the plus sign (+) in the group name changed to a minus sign (-) to indicate that the group is expanded.
To view security level details, click the Security Level option on the Explode drop down menu.
Clickto view security related information and click the Security Details and Security Cross Reference tabs, respectively.
Clickto access the Bloomberg Web site for details about a security.
If the results are for a grouped Eagle Data Mart query, click Details next to the Query Name header to see details for the available Eagle Data Mart group models.
This option allows you to view Eagle Data Mart's position details. For more information about Eagle Data Mart queries, refer to the Eagle Portal System Administration Guide.
If the query report is configured to use a header (Header Report Internal or Eagle Data Mart header fields), click View Summary in the right corner of the window.
This option allows you to view summary level information. For more information about configuring headers, refer to the Eagle Portal System Administration Guide.
To create a grouping, click the drop down menu on the right side of any column name and select Group By. Or, drag the column name to the Grouped by area. To remove a grouping, click Remove from Grouping.
To save your changes to the current view, click the Current View drop down menu and select Save.

Create a New Query View

To create a new query view:

From the Eagle Portal main window, run a query report.
To create a new view from the current view, click the Current View drop down and select Save As.
NOTE: If you wish to create a new view from the shared views, click the Manage drop down, select Views, and select a shared view that you wish to copy.
You see the Save View As dialog box.
Enter the name and description for the new view and click Create.
To access the new view, click the Manage drop down menu, click Views, and select the new view under My Views. Or, if you copied a shared view, click the Manage drop down menu, click Views, and select the new view under Shared Views.

Create an Advanced Filter

To create an advanced filter:

From the Eagle Portal main window, run a query report.
Click the Current View drop down menu and select Advanced Filter.
You see the Filter Builder dialog box with the And condition as the default.
To add a filter condition, click And, select Add Condition, and select the appropriate filter condition.
Click the plus sign (+) to add a new condition.
Click OK to save your changes to the filter.
You see the filter check box and the filter name in the left corner of the window. This filter is applied to the query report results.
To remove the filter, click to uncheck the filter check box, or click And in the Filter Builder dialog box, select Remove, and click OK.
To clear all filters from the current view, click Clear in the right corner of the window.
To save your changes to the current view, click the Current View drop down menu and select Save.

Print a Query View

To print the query current view:

From the Eagle Portal main window, run a query report.
Click the Current View drop down menu and select Print.
Select the appropriate printer to print the query report results in the current view.

Browser not supported