Query Settings Dialog Box - ACCESS DATAMART Query

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.