...
From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
Enter Portal Administration in the Start Search text box.
Click the Portal Administration (Reporting Center) link to access Portal Administration.
You see the Portal Administration window.Click Yes in the Do you see the Eagle logo here? dialog box.
You see the Portal Query Explorer window as the default.Click the Add Query link.
Complete the fields options on the Query Settings dialog box and click Next.
...
.
For this example, select Vertical View from the View Type drop down list.
You see the Query Result Configuration dialog box. Note the Display Dimensions section in the following figure.In Rows, specify the number of rows you want to display in your query results and click Apply.
The value for Columns is set to 1 and cannot be modified because the display dimensions for the Vertical View are for a single entity. However, you can run this query report for more than one entity to view display dimensions for multiple entities.
You see four rows below the Display Dimensions section on the Query Result Configuration dialog box.Click the ellipsis to the right of the first cell in the first blank row.
You see the Field Setup dialog box.
...
In Cell Type, select Title.
In Text Value, enter the text you want to use as the column header in your query results, and click OK.
Click the ellipsis button to the right of the second cell in the first row.
You see the Field Setup dialog box.
...
...
In Cell Type, select Value.
In Field Name, select a field from the drop down list.
Accept the remaining default values and click OK.
Repeat these steps to complete the remaining rows in the Query Result Configuration dialog box.
The following figure displays
...
the query results in the Eagle Portal for the ACCESS DATAMART FUND VIEWS REPORT type with this vertical view. The query was run for multiple entities and each row (Performance Overview for, Investment Base
...
For comparison purposes, the following figure shows report results after running the query in the Eagle Portal and configuring it with a multiline view.
...
The following figure shows report results after running the query in the Eagle Portal and configuring it with a time series view.
...
, Gain/Loss, and Return) displays the text value that was defined in the Field Setup dialog box in the Query Result Configuration dialog box.
Add an ACCESS DATAMART Query
The ACCESS DATAMART type can be used for viewing Data Mart’s fund summary, group level or detailed models. It can also be configured so that users can view data in a transposed time series view. Each column of data represents a different effective date of data. Since this view displays a different date for each column, it requires one date rule per column.
To add an ACCESS DATAMART query:
From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
...