Add a Group Level Model
In the Adding Group Level Model window's Definition tab, you can define the table used to store the group level data in a Data Mart schema.
To define a Group Level model:
In Reporting Center, from the left navigation, select Reporting Tools > Datamart > Manage Marts > Data Mart.
You see the Data Mart workspace.Click the Add Group Level Model link.
You see the Adding Group Level Model window appear with the Definition tab enabled.Complete the fields on the Definition tab.
Click Next to display the Grouping tab.
The following table describes each option on the Definition tab.
Option | Description |
|---|---|
Name | Displays the name of the Group model. The system automatically creates a name for the model. Eagle recommends keeping this name. |
Description | Provides a brief description of the Group model. |
Table Name | Assigns a name to the database table that stores group level data. The system prevents you from entering invalid values. Valid table names:
|
Validate | Ensures the table name is valid. |
Archive Table Name | Displays the archive table name, which is based on the value you enter for Table Name. You can change the archive name. |
Inception Date | Defaults to the current date. You can change this date to any value for your own tracking purposes. |
Active | Indicates whether the table is considered active. This is informational only. Options include:
|
No. of Funds per Report | Allows you to configure the number of funds to run per report at the model level. The current default for this option is at the Data Mart Level If you set this at Model level, then it applies the same override for all its extensions. But you can override the value at the extension level. |
Enable Look Thru Processing | Sets a group model to build position and performance fields on a look-through basis. |
Entity Hierarchy Model | Indicates that the group model is grouped by entity hierarchy fields, and that group structure is all that needs to be built in the table. If you check this box, you do not have to select any fields for the model. This allows you to include entities like indexes in the entity hierarchy structure that do not have any positions or transactions. Note: However, you do not have to check this box in order to group by entity hierarchy fields. This option only allows you to avoid choosing regular fields for the model when some of the entities to be reported have no values for them. |
Entity Hierarchy Model Details | Enables you to populate detail-level records for the Entity Hierarchy Group Model. |
Schedule to Run | Determines which schedules are run to populate the table's fields. |
Comments | Provides descriptive model information. |
Configure Groups to the Model
In the Adding Group Level Model window's Grouping tab, you can configure groups to the Model.
To configure a group to the model:
Complete each field on the Grouping tab.
Click Next to display the Fields tab.
The following table describes each option on the Grouping tab.
Option | Description |
|---|---|
Add | Creates a group based on simple fields, range rules, or dictionaries. For details on adding a group, refer |
Remove | Removes a group. |
Validate | Indicates whether the group is valid. |
Levels | Displays the group by level. |
Database Column Name | Displays the group's database column name. |
Field Size Override | Controls the maximum column size of a text-type grouping field. Set the width to any value up to the maximum supported for the data type of the Mart table field you are working with. You can enter a value in this column for any text field that is at least as great as the default value, subject to table column sizes supported by your database. Note that once you have built data for the group-level model, you cannot change the field size settings. |
Field Description Override | Controls the display of Grouping fields in View Mart Data and Portal. Enter a name unique to the model in this column. Once the model is built, the View Mart Data displays the groups with the override name you entered. You can change the override grouping description after the model is built. If you change the name, the new name appears the next time you view data from View Data Mart. |
Define Fields for the Model
In the Adding Group Level Model window's Fields tab, you can define fields for the Model. The Fields tab allows you to add, remove, and modify fields in the Group model. Certain group types restrict the list of fields you can add to a Group model using the Fields tab.
To define the fields for the model:
Complete each field on the Fields tab.
Click Next to display the Fields Schedule tab.
The following table describes each option on the Fields tab.
Option | Description |
|---|---|
Map Performance Model | Maps a performance dictionary to the model to enable the model to contain performance fields. This option is only available if you did not select a performance dictionary when you defined your group levels on the Grouping tab. Only performance dictionaries with the same number of levels as the group model are available for selection. Note: If you are using dynamic performance, you do not have to select a performance dictionary and map performance fields in your model to that performance dictionary. |
Clear | Removes a performance dictionary and uses dynamic performance to report returns and related performance information. Dynamic performance involves setting up special field attributes that allow pre-existing security level returns to be aggregated and linked on demand. Refer to the Eagle Performance Reporting User Guide for additional details. |
Add | Adds fields to the Group model. For details, refer to Add Fields to Group Models. |
Remove | Removes fields from the Group model. |
Modify | Changes the field attribute linked to a field in the Group model. You cannot change the field's database name. You can only select from field attributes with the same data type. |
Validate | Validates whether a field is valid. Data Mart displays a red X in the check box next to an invalid field. |
Description | Displays the selected field attribute. |
Database Column Name | Specifies the name of the database column you have assigned to the field. |
Field Size Override | Controls the maximum column size of a text field. Set the width to any value up to the maximum supported by your database for the data type of the Mart table field. |
Field Description Override | Specifies a user friendly name for the field attribute when viewing Mart content using View Mart Data. This field is optional. If you do not enter a value, Data Mart displays the field attribute name in View Mart Data. |
ID | Displays a unique identifier of the Data Mart field. The system automatically assigns a value to this field based upon the field attribute ID of the underlying field attribute. However, it is a best practice to override this value with an ID that is unique and meaningful to you. The reason is that when you migrate the model from one environment to another, fields with the default ID value may conflict with others in the target environment. |
Type | Displays the subject type of the field, such as performance. |
Map Performance Model | Maps a performance dictionary to the model to enable the model to contain performance fields. This option is only available if you did not select a performance dictionary when you defined your group levels on the Grouping tab. Only performance dictionaries with the same number of levels as the group model are available for selection. Note: If you are using dynamic performance, you do not have to select a performance dictionary and map performance fields in your model to that performance dictionary. |
Define Schedule Fields for the Model
In the Adding Group Level Model window's Field Schedules tab, you can specify which fields are populated when you submit the model on a scheduled basis. The fields are populated for all schedules that are assigned to that model. This functionality is optional. Note: The Data Mart Schedules dialog box also allows you to specify which fields are populated when you submit the model on a scheduled basis. However, the fields are only populated for one schedule, which you select.
Use the options on the Field Schedules tab to reduce run time. You can populate certain fields in the model on a daily basis and others on a monthly basis. By calculating the monthly values on a monthly schedule, and the daily values on a daily schedule, you can meet your reporting needs while economizing on run time.
This feature also ensures that Data Mart has no limitations when building cash or trade adjustment fields that span periods of multiple lengths, such as month-to-date or quarter-to-date periods. In any submission, either scheduled or ad hoc, only one date rule can define such a period. On the Field Schedules tab, you can build adjustment fields for as many date intervals as you need. For example, you can populate month-to-date fields using a Data Mart schedule with a month-to-date date rule for cash, and populate the quarter-to-date fields using a schedule with a quarter-to-date date rule for cash. Note that if you do this, you must include at least one position field in each schedule that you use to build a cash or trade adjustment field. This is a requirement of the OLAP process that builds adjustment fields.
To define schedule fields:
Right-click in the dialog box to display the Find, Filter, and Clear options. Select Clear to clear any previous filters.
Select Find.
You see the Find dialog box.In the Find By dropdown, you can find items based on any of the available options.
Enter the item to locate in the Find What field.
Click Up or Down to find the next matching value. Click Cancel when you are done.
You see the Model Submission Fields Selection dialog box.You see the Right-click and select Filter.
You see the Filter dialog box.In the Filter by dropdown, you set filter criteria based on partial or complete field name.
Enter the value to search for in the Value field.
Select the Match whole word only check box to match only the whole word. Select the Match starting value only check box to filter the rows which start with the value you selected.
Complete each field on the Fields Schedule tab.
Use the options on the Field Schedules tab to reduce run time. You can populate certain fields in the model on a daily basis and others on a monthly basis. By calculating the monthly values on a monthly schedule, and the daily values on a daily schedule, you can meet your reporting needs while economizing on run time.
This feature also ensures that Data Mart has no limitations when building cash or trade adjustment fields that span periods of multiple lengths, such as month-to-date or quarter-to-date periods. In any submission, either scheduled or ad hoc, only one date rule can define such a period. On the Field Schedules tab, you can build adjustment fields for as many date intervals as you need. For example, you can populate month-to-date fields using a Data Mart schedule with a month-to-date date rule for cash, and populate the quarter-to-date fields using a schedule with a quarter-to-date date rule for cash. Note that if you do this, you must include at least one position field in each schedule that you use to build a cash or trade adjustment field. This is a requirement of the OLAP process that builds adjustment fields.Click Next to display the Filters/Mappings tab.
The following table describes each option on the Field Schedules tab. Data only appears on this tab if you have assigned selective build schedules to this model.
Option | Description |
|---|---|
Select All | Checks every box, assigning every field to every model. This is the result you get by ignoring the Field Schedules tab altogether. |
Deselect All | Unchecks every box on the Field Schedules tab. |
All | Selects the corresponding field for all schedules. |
Field Name | Displays the name of the field. |
Model | Displays the name of the models that populate this field, including the one you are defining. |
Selective Build Schedule | Displays the Selective Build Schedules that you specified in the Schedule to Run field on the Definition tab. Selective Build Schedules allow you to specify which fields are populated when you submit the model. If you choose a Selective Build Schedule for a model, you must populate at least one model field for that schedule. If the Selective Build Schedule populates a particular field in one model, it must do so for every model where that field appears. The Model's column lets you know what other models populate the field you are assigning to a schedule. |
Find | Locates a specific schedule. Right-click on the window and select Find from the pop-up menu. You see the Find dialog box. Select Find Criteria and click Find Next. |
Filter | Allows you to filter schedules. Right-click on the window and select Filter from the pop-up menu. You see the Filter dialog box. Select filter criteria and click OK. |
Define Filter/Map Table for the Model
In the Adding Group Level Model window's Filters/Mapping tab, you can create a map table that links each group to the underlying detail data of the group's members. Additionally, the tab allows you to restrict the data being populated to the Data Mart tables.
To define filter/map table for the model:
Complete the necessary fields in the Filters/Mappings tab.
Click Next to display the Funds (Entities) tab.
The following table describes each option on the Filters/Mappings tab.
Option | Description |
|---|---|
Category | Displays the type of field in your model, such as performance, security detail, or position detail. |
Create Mapping for Details | Creates map tables that link each group to the underlying detail data of the group's members for each checked box. For example, suppose your model is grouped by Country and you create a map table to Positions. The map table links each country, such as France, to each French POSITION_DETAIL_ID. |
Filter | Displays the Add Filter link, which allows you to define a filter using the Define Filter dialog box. |
Other | Displays the Performance Report Options link if you selected performance fields using the Fields tab. When you click this link, a pop-up window appears. This window allows you to define the level at which the underlying Performance Analysis OLAP report calculates performance and attribution data. For details, refer to Define Performance Report Options. |
Map Table Name | Displays the map table name. |
Map Archive Table Name | Displays the map archive table name. |
Filter Description | Displays the filter rule, if any has been defined, for the data type of the row currently selected. |
Define Funds (Entities) for the Model
In the Adding Group Level Model window's Funds (Entities) tab, you can select entities for the model. If you populate the tables in your model using schedules, all entities are included. If you populate the tables in your model on an ad hoc basis, you can specify which entities are included using the Funds (Entities) tab. You can also use dynamic entity lists for this purpose.
To define funds (Entities) for the model:
Complete each field on the Funds (Entities) tab.
Click Next to display the Access tab.
The following table describes each option on the Funds (Entities) tab.
Option | Description |
|---|---|
Select | Displays the Entity Selector dialog box, which allows you to select funds. Click Load on the Entity Selector dialog box. A list of available entities based on the current filter settings appears in the top section of the dialog box. If there is no filter defined, all entities appear. Select one or more entities, and click Add. Or, double-click a fund to select it. The selected entities appear in the lower part of the dialog box. |
Remove | Removes a selected fund from the Funds (Entities) tab. |
Fund ID | Displays the fund or entity ID. |
Fund Name | Displays the fund or entity name. |
Fund Type | Displays the type of fund or entity. |
Assign Access to the Model
In the Adding Group Level Model window's Access tab, you can define which users and business groups can view the model. Users and business groups with "Maintain" privilege have access to all Data Mart tables, even if the model is restricted.
Complete the required fields in the Access tab.
Click Next to display the Currencies tab.
The following table describes each option on the Access tab.
Option | Description |
|---|---|
Give access to everyone | Allows all Data Mart users to view the model and its data. |
Give access to specified Users and Business Groups | Allows specified Data Mart users to view the model and its data. Check the Show me only users in current group check box to view users in your current business group. Select the check box of each user, and click OK. |
Selected Users | Adds and removes selected users. |
Selected Business Groups | Adds and removes selected business groups. |
| Info |
|---|
If none of the fields in your model have underlying field attributes with a specified currency process, Next is inactive. |
Define Currency for the Model
In the Adding Group Level Model window's Currencies tab, you can specify a list of alternative base currencies for which model data is converted and stored within Data Mart tables.
Conversion is performed only for field attributes with a defined currency process. You should only attach a currency process to warehouse table fields that are accounting amounts stated in the account's base (not local) currency. Ad hoc currency conversion requires that the appropriate exchange rates are stored in PACE database. If you choose to build data in your Mart table for alternate base currencies, a complete set of rows of data appear in your table. Rows built using the default option of the fund's base currency show the value BASE in the field dmart_currency. If you build data for an alternate base currency such as EUR, then dmart_currency will contain EUR for those rows.
To define currencies for the model:
Complete the required fields in the Currencies tab.
Click Finish.
The system verifies the model definition and saves your model to the Data Mart. If any part of your model definition is not valid, the system prompts you with a warning message that identifies the invalid part. Respond to the warning by making any required modifications to the model, and click Finish to save your model.
The following table describes each option on the Currencies tab.
Option | Description |
|---|---|
Available Currencies | Allows you to select one or more currencies. Click the right arrow. The currency appears in the Selected Currencies section. When you submit a model with one or more alternate base currencies, all data is populated with the same DMART_FUND_ID. There is a complete version of data for each currency that includes the DMART_CURRENCY field populated with the alternate currency's ID. |
Selected Currencies | Displays the currently selected currencies. Select a currency and click the left arrow to remove the currency. |