...
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 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, 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
...
You see the Query Settings dialog box.
...
Anchor
Complete the fields on the Query Settings dialog box and click Next.
The following table describes the options on the Query Settings dialog box that are specific to the ACCESS DATAMART query type.
Option | Description |
Name | Specify the name of your query report. |
Type | Select the ACCESS DATAMART Type |
Data Mart Instance | Select the Data Mart instance to use in this query. |
Rule | Select the appropriate Data Mart model defined in Eagle Data Mart. |
Menu Category | Specifies the menu on which the query report is displayed. |
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. |
Access | Determines whether a report is displayed in the Eagle Portal's Queries menu. For example, if you discover a report contains incorrect data such as pricing, you may want to remove access so your users do not unknowingly run a report while you investigate. Once you correct the pricing error, you can grant access again and the report is displayed on the Queries menu. |
Entity Filter | Allows you to define a filter that filters query data for specific entities. |
Report Fields | Displays the Report Field Selection dialog box, which allows you to specify multiple date rules for a field via the As Of column. |
Header Fields | Displays the Header Field Selection dialog box, which allows you to specify multiple date rules for a field via the As Of column. |
Detail Fields | Allows you to display field detail based on detail type, such as Cash Flow Details, Ledger Details, Lot Level Details, Performance Details, Position Details, or Transaction Details. |
Detail Fields Snapshot | When you configure a query using a Data Mart grouped model, you can now specify using different Data Mart Instances for the grouped model and its detail fields. |
Date Rules | Allows you to select date rules so that they are available to run as part of the query. |
Rule for default date | Allows you to specify a rule for the default date. |
Snapshot | Displays Default. Data Mart users can select different source rules for viewing a set of Data Mart data. This allows them to view the same set of data from different perspectives. This functionality is known as a snapshot. If you want the query to use a snapshot other than the Default, click the Snapshot drop down list and select a specific snapshot. The values in this drop down list are derived from the snapshots defined in Eagle Data Mart. |
Visualization | Allows you to configure non-server based query types for cross tab functionality in the Eagle Portal. Grid is selected by default but you can select Cross Tab from the drop down menu if you want to configure the query for cross tab functionality. |
Fund Approval Status | Select the status of the Data Mart data to display in the Eagle Portal. You can select Preliminary, Final, or All. |
...
You see the Report Field Selection dialog box.
...
anchor
Specify a date rule for the fields by clicking the ellipsis in the As Of column.
...
After clicking the ellipsis, you see the Portal Date Rule Selector dialog box.
...
Anchor
Select the date rules and click OK.
You see report results after running the query in the Eagle Portal.
...
Anchor
...
About the EAGLEMART Packaged Portal Content
EAGLEMART is a Data Mart instance used by Eagle Packaged Reports. This Data Mart acts as a staging area for Eagle provided metadata and Eagle Portal contents.
...
To see how a read only query is configured, click View Query in the Portal Query Explorer. You can configure the copied queries to use another Data Mart instance, such as DATAMARTDBO.
...
Manage the ACCESS SQL QUERY Type
The ACCESS SQL QUERY type allows you to distribute any data stored in the Eagle data model or any other database through the Eagle Portal. The option to specify any SQL query as the data source makes this query unique. Like other queries, you can specify an entity and effective date. The information is passed to the query in the form of parameters that are substituted during run time. You can also use this query type as a part in the dashboard. When entity type List is used in ACCESS SQL QUERY, the Eagle Portal enumerates for the list.
...
Set Up Column Values
In the Maintain Options/Parameters window, you can select a database table and column so that its value is displayed in the Eagle Portal and also passed to the ACCESS SQL QUERY type queries. You can do this if you do not want to set up or use the codes the Codes window.
Complete this procedure before setting up an ACCESS SQL QUERY type:
From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
...
Specify the Database, Table, and Column for the value that is to display in the Eagle Portal and be passed in the query.
...
Anchor
If you have already created the stored procedure in the database, go to the Portal Query Explorer to create the query for the ACCESS SQL QUERY type. When creating the query, make sure you select the option you have created.
...
Set Up Codes
If you want to use a code value’s long description, set up the code in the Maintain Options/Parameters window.
Complete this procedure before setting up an ACCESS SQL query:
From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
...
When you use a long description, the Eagle Portal users see that description as an input for the query.
...
Anchor
The following figure shows Indexes as the code selected to use long description.
...
Anchor
When your users are logged in to the Eagle Portal, they see the long description displayed as an input for the query.
...
Figure 64: Long Description Display Example
...
You can create the stored procedures in the Oracle or SQL database. Refer to Appendix: Stored Procedure Parameters and Examples, for templates you can follow.
...
Add an ACCESS SQL QUERY Type
To add an ACCESS SQL QUERY type:
From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
...
The following table describes options on the Query Settings dialog box that are specific to the ACCESS SQL QUERY type.
Option | Description |
Name | Specify the name of your query report. |
Type | Select the ACCESS SQL QUERY type. To use a parameter for input to the query that presents the user with a list of distinct values of a particular database table column, where a code value might otherwise have been used. This is useful when the database column includes a limited set of different values that may increase in number over time, which would require the manual addition of new entries to a code value. For example, the list of different investment types may be short, but can grow over time. You enable this feature in setup of the Option or Parameter to be used for the query. In a new dropdown for Option Type you choose Column Value, then select the database schema (most likely a Data Mart schema but not limited to the mart), table and column whose unique values should be the input choices for the option or parameter. |
Module | Specifies in which module, Eagle Portal or Reference Data Center, the stored procedures are available. Procedures with the designation of Portal are available and visible to the Eagle Portal Administrator. |
Menu Category | Specifies the menu on which the query report is displayed |
Procedure | Enter the name of the stored procedure already created for this query. Make sure the name you enter here matches the name of the stored procedure exactly. You must create the stored procedure in the database before configuring the query in the Portal Query Explorer. |
Access | Determines whether a report is displayed in the Eagle Portal's Queries menu. For example, if you discover a report contains incorrect data such as pricing, you may want to remove access so your users do not unknowingly run a report while you investigate. Once you correct the pricing error, you can grant access again and the report is displayed on the Queries menu. |
Maximum Rows | Allows you to specify the maximum number of rows returned in a query report. This field is optional. The value in this field overrides any default value that you configure for the Eagle Portal. |
Data Mart Instance | Select the Data Mart from which the fields are pulled from the Security Details model. By default, Default Mart is the selected Data Mart instance. |
Header Type | This is an optional feature you can use to display security detail information from Data Mart Security Details model. Select Security from the drop-down to display security field information. |
Header Field | This is an optional feature. Header fields are not defined by default. However, if you want to display security detail information from Data Mart Security Details model on top of a report, then you must define a Header Field. By default, Investment Type is set to default. If you define fields for Investment Type with default, this means that the same security detail fields will be displayed on top of report for all your securities regardless of security type. If you want to display different security details for different security types, such as fixed income, equity, or derivatives, since they have different characteristics, then you must define security detail fields for each Investment Type. |
Visualization | Grid is selected by default. Select Cross Tab if you want to use the cross tab functionality in Portal. |
NOTE: Make sure the stored procedure’s name is the name of the stored procedure you have created in the database. If the stored procedure name does not match, when you click Execute, an error message be displayed and you will not be able to complete the procedure.
...
Anchor
...
You see Stored Procedure Parameters dialog box.
...
Anchor
In the above figure, the values available in the Option column are determined by what you have defined in the Options/Parameters window These values should already be defined before you begin setting up the ACCESS SQL QUERY report.
Click Next.
You see the Stored Procedure Columns dialog box.
...
Anchor
The Analysis and Charting check boxes are enabled by default so you can use this query for analysis and charting.
The number of columns configured here is the same as the number of columns that display in Portal after the user runs the query. In this example, there are four columns: effective date, primary index YTM, secondary index YTM, and security YTM. After the user runs this query in Portal, the record will always return these four columns. anchor
When you double click a row, you see the Column Configuration dialog box for that column.
...
_Toc352155400 Anchor
Complete the fields in the Column Configuration dialog box.
Option | Description |
Description | The description you enter is the description that the user sees in Portal. |
XML Tag | Enter a unique XML tag. The value you enter must be unique. |
Type | The type Character is displayed by default. Select the appropriate type from the drop down list. |
...
Repeat steps 7 and 8 for each row.
Click Finish.
...
Manage the ACCESS MICROSTRATEGY REPORT Query
You can use the ACCESS MICROSTRATEGY REPORT query type to run a report or document created in MicroStrategy Web. The ACCESS MICROSTRATEGY REPORT type is unique because MicroStrategy documents support interactivity. However, you cannot change and save a MicroStrategy query in the Eagle Portal.
...
MicroStrategy reports typically require one or more inputs that you can set up in the Maintain Options/Parameters window. After these values are set up, you can add these values to the query via the Portal Query Explorer.
...
Add an ACCESS MICROSTRATEGY REPORT Query
To add an ACCESS MICROSTRATEGY REPORT query:
From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
...
You see the Query Settings dialog box.
...
Figure 70: Query Settings Dialog Box – MicroStrategy
Complete the fields on the Query Settings dialog box.
Option | Description |
Name | Specify the name of your query report. |
Type | Select the ACCESS MICROSTRATEGY REPORT Type |
Module | Specifies in which module, Eagle Portal or Reference Data Center, the stored procedures are available. Procedures with the designation of Portal are available and visible to the Eagle Portal Administrator. |
Reports | Specifies the report to use that was created in MicroStrategy. |
Menu Category | Specifies the menu on which the query report is displayed. These query types are never used when creating dashboard parts. |
Access | Determines whether a report is displayed in the Eagle Portal's Queries menu. For example, if you discover a report contains incorrect data, you may want to remove access so your users do not unknowingly run a report while you investigate. Once you correct the error, you can grant access again and the report is displayed on the Queries menu. |
Entity Filter | Allows the user to define an entity filter prior to running the query. |
Date Rule | Specifies a date rule used to define the end date and begin date for a report in the Eagle Portal MicroStrategy queries. |
Composite Enumeration | Determines how the report handles composite level positions. Options include: Do Not Enumerate. Builds positions for the composite entity via an Entity Build, and the report takes these composite level positions. Enumerate to Constituent. Runs the report for all the constituent funds of the composite after composite enumeration. |
...
The values in the Option column of the Report Parameters dialog box are determined by what you have defined in the Maintain Options/Parameters dialog box. These values should be defined before you begin setting up the ACCESS MICROSTRATEGY REPORT query.
...
Anchor
Click Next. Anchor
You see the Assign Queries dialog box.
Assign the query to selected users, a group, or everyone.
Click Finish.
...
...
Set Up Issuer Selector
You can use the Issuer Selector for searching issuers in the Eagle Portal. Before setting up a query, select the Issuer in the Maintain Options/Parameter window.
To set up the Issuer Selector:
From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
...
Select Issuer from the dropdown list for Type.
Click OK.
...
Manage the ACCESS ISSUER SELECTOR Query
The ACCESS ISSUER SELECTOR query type is an internal query and does not display as a menu item.
To set up an ACCESS ISSUER SELECTOR query:
From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
...
If the Eagle Portal users cannot use the same ACCESS ISSUER SELECTOR type query, create multiple ACCESS ISSUER SELECTOR type queries and assign them to various groups. Once completed, in the User Settings Explorer, assign the different ACCESS ISSUER SELECTOR type queries to business groups. Configure Internal Queries for groups in the User Settings Explorer, as shown in the following figure.
...
anchor
Click the Current User: Default link in the upper right.
You see the Select User/Group dialog box.
...
Anchor
To configure for a group, click Group and then select the group.
...
You see the Stored Procedure dialog box.
...
Anchor
Click the ellipsis (….).
You see the Parameter Option Configuration dialog box.
...
You see the Stored Procedure Columns dialog box. The fields in this dialog box are the fields that are returned by the stored procedure after the query runs.
...
Anchor
Double click any cell in the grid.
...
Once the query is assigned, your users can use the Issuer Selector in the Eagle Portal.
...
Manage Filters
The Query Settings dialog box allows you to filter data returned from a query. For example, you can define a filter that restricts users to seeing only securities with a specific market value in their accounts. Additionally, you can define a filter that queries data for specific entities only.
...
Define a Query Filter
To define a query filter:
From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
...
In Filter, click the ellipsis.
You see the Define Filter dialog box.
...
Anchor
Define the filter criteria and click OK.
...
The filter is applied to the specified query report.
...
...
Define an Entity Filter
To define an entity filter:
From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
...
The filter is applied to the specified report.
...
...
Define Data Sources
You can define a data source when you add or edit a query report. The Sources option in the Query Settings dialog box allows you to define the source of query data, such as performance, positions, transactions, entities, and so on, and the order in which the system searches the data sources.
To define one or more data sources:
From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
Enter Portal Administration in the Start Search text box.
...
You see the Define Report Sources dialog box.
...
Anchor
Complete the fields in the Define Report Sources dialog box.
The following table defines each option on the Define Report Sources dialog box.
Option | Description |
Current Source Definition | Displays the current source definition. Sources are displayed in Available Sources. Use the right and left arrows to add and remove sources. |
Source Priority | Allows you to add and delete a source priority. You can add a source priority by clicking Add and selecting the priority. You can delete a priority by selecting the priority and clicking Delete. If you delete a priority, all sources associated with that priority are deleted. If you delete a higher priority, the next lower priority assumes the deleted priority’s level. |
Entity Source | Allows you to query an entity or a combination of data sources and entities by clicking Add. If you query an entity, all entities are queried after the data sources. Also, if you choose to query more than one entity, each entity you add is appended to the end of the source definition. To delete entities from Current Source Definition, select the entity and click Delete in Entity Source. |
Available Sources | Allows you to select one or more data sources using the right arrow. |
...
You have defined the data sources for a query.
...
Select a Business Calendar
You can configure your report query to use a business calendar. The Business Calendar option in the Query Settings dialog box allows you to specify the dates on which a user can perform a query. Before you can use a business calendar in the Eagle Portal, you have to set up a
Anchor | ||||
---|---|---|---|---|
|
To select a business calendar for a query:
From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
...
The business calendar is applied to the query. Eagle Portal users are restricted to running queries for business calendar dates only.
...
Block Access to a Query
The Access option in the Query Settings dialog box determines whether the report is accessible to your user. You can block access temporarily, due to data integrity issues, maintenance schedules, or for other reasons.
To block access to a query report:
From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
...
The user will no longer see this query report in the Eagle Portal.
...
Set Maximum Number of Rows Returned for Query Result
You can limit the number of rows returned for a query report when you add or edit a query report. The Maximum Rows field on the Query Settings dialog box allows you to limit the number of rows returned. If you do not enter a value for the Maximum Rows field, the number of rows returned defaults to the value set for the Default Query Row Limit in the Global Settings Explorer.
...
NOTE: This feature does not apply to the following query types: ACCESS PERF QUERY REPORT, ACCESS CONCENTRATION REPORT, and ACCESS PERFORMANCE ANALYSIS.
To specify the number of rows returned for a query in the Query Settings dialog box:
From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
...