After defining fields and other parameters in the Group, Fund Summary, and Detail models, you then populate the tables in the Data Mart with data using the submit process. You can submit a model ad hoc (on demand) or on a scheduled basis.

To submit one or more models as ad hoc:

In Reporting Center, from the left navigation, select Reporting Tools > Datamart > Manage Marts > Data Mart.
You see the Data Mart workspace.
Click Submit.
You see the Data Mart Model Submission dialog box as shown in the following figure.
Complete the fields on the Data Mart Model Submission dialog box.
To learn about the fields in Data Mart Model Submission, refer to Select Options in Data Mart Model Submission dialog.
Click OK to submit the models.
The system verifies the submission options are valid and prompts you to modify any invalid options. When the submission process is complete, the system displays a confirmation message.

Select Options in Data Mart Model Submission Dialog

The following table describes each option available in Data Mart Model Submission Dialog. Refer to About Date Rules for additional information on date rules.

Option	Description
Submission Mode
Regular Submission	Indicates a regular Ad Hoc submission.
Supply Defaults from this Data Mart Schedule	Defines a submission based on the contents of a schedule. When you select this option, a list of Data Mart schedules becomes available in the dropdown list. When you select a schedule, the information from that schedule is used to fill in fields on the Data Mart Model Submission dialog box. You can override any of the automatically filled in fields. Fields filled in include: Snapshot Date Rule Model(s) Fields (Build all or selective build) Entities
As of
Snapshot	Allows you to choose a snapshot to use when building your data. See Create Multiple Snapshots of Your Data for details.
As of Date	Allows you to select an effective date to store the Mart data. Choose an as of date to build data with a single effective date.
Date in this Business Calendar	You can build data for one date or a range of dates. To build data for a range of dates, select a date range and a business calendar. Options include: Business calendar. Defines a business calendar to indicate which As Of dates within the specified date range are valid for use as effective dates. You may want to create a business calendar for a special purpose and designate only the run dates you want as business days. You can then submit the models for a date range that includes your entire date span. Daily or monthly frequency. Specifies use of a daily or month end column of the selected business calendar to determine valid dates. The option you select determines if data is built monthly or daily. Process Dates Concurrently. When you select concurrent processing and submit models for a specified date range, the system launches multiple processes at the same time, one to handle each day's build. If the system encounters a problem that causes this set of events to end before all models are completed, you have a subset of the total numbers of days populated in random order, not chronological order. When you do your rerun, you may have to run several different periods to close all the gaps. Process Dates Sequentially. When you select this option and submit models for a specified date range, the system processes each day's build in chronological order. If the system encounters a problem that causes this set of events to end before all models are completed, you have a subset of the total numbers of days populated in chronological order. When you do your rerun, you can run the un-populated dates in the original date range. System performance may be slower, depending upon how many days you submit and what is the longest-running engine launched for each date. The next day's processing must wait for the longest-running individual engine of the previous date.
Date Rules
Ad hoc	Specifies a date rule which contains begin and end dates, the PACE Concentration Engines used to calculate values. These are relative dates, such as month end, that depend on the dates selected in the As Of section. See About Date Rules for additional information.
From Schedules	Allows you to use the same date rule in your ad hoc submit as you use in a particular Data Mart schedule, for consistency. For example, if you select a schedule from this dropdown list, Data Mart uses its date rule in your ad hoc submit.
Specific to Data Types	Allows you to create a date rule for a specific data type, such as holdings, performance, cash flows, transactions, and ledger data.
Holdings	If you enter a date rule here, the end date defined by the rule defines the effective date of holdings data selected by the underlying OLAP process. See About Date Rules or additional information.
Performance	If you enter a date rule here, the end date defined by the rule defines the effective date of performance data selected by the underlying OLAP process. See for additional information.
Cash Flows	If you enter a date rule here, begin and end date defined by the rule define the range of effective dates of cash activity data selected by the underlying OLAP process. See About Date Rules for additional information.
Transactions	If you enter a date rule here, begin and end date defined by the rule define the range of effective dates of transaction data selected by the underlying OLAP process. See About Date Rules for additional information.
Ledger	If you enter a date rule here, begin and end date defined by the rule define the range of effective dates of ledger data selected by the underlying OLAP process. See About Date Rules for additional information.
Business Dates	If you enter a date rule here, begin and end date defined by the rule will define the range of effective dates of business calendar data built. See About Date Rules for additional information.
Models
Submit All Models	Specifies all models for submission at one time.
Select Models to Submit	Allows you to select a subset of models and limit the data populated in the Data Mart. Click Add to display the Data Mart Model Selection dialog box. Enable the check box of each model that you want to submit and click OK. If you configured a model that maps details to a group model through the Filters tab, the details are not calculated when the group model is submitted. You must submit each detail model that you want to populate in this or another submission. When you submit a detail model, the Security Details and Issuer Details models are automatically selected for submission by default. This is because security and issuer information is usually a necessary supplement to Position, Performance, and other detail data. However, you may use the Remove link to remove Security Details and Issuer Details for submission. This may be an appropriate and time-saving step, especially if you are rebuilding detail data for just a few entities using Process Manager. However, you can use the Remove link to avoid submitting Security and Issuer Details. Avoiding those submits speeds up the rest of the build and can be appropriate in some circumstances. However, exercise caution when you do this. If you have added positions or trades in any new securities since last building Security Details, and you build Position Details or Trade Details, you will be missing the necessary companion security data for the positions or trades.
Fields
Build All Fields	Populates all fields.
Build Selected Fields	Populates fields selectively. Click Select Fields to display the Data Mart Model Submission Fields Selection dialog box. Click a column name to sort the fields. To search, right-click and select Find from the pop-up menu. You see the Find dialog box. Select find criteria and click Find Next. To filter, right-click and select Filter. You see the Filter dialog box. Select filter criteria and click OK. Select the check box of any field you want to populate with this submission. Each model submitted that contains a given field is populated according to your selections. For information on Fields Selection dialog box, refer to Working with the Fields Selection Dialog Box. See About Build Selective Fields for additional details.
Funds
Submit All Funds Selected for the Model	Allows you to submit all entities defined in the submitted models.
Languages
Submit All Languages Selected for the Model(s)	Selected by default. Allows you to submit the mart for all the languages in the Model definition.
Select Specific Languages to Submit	Allows you to submit the mart for the selected languages only. Click Select Languages. You see the Available Languages dialog box. Select the languages to use when you submit the mart, and click OK.
Currencies
Submit All Currencies Selected for the Model(s)	Selected by default. Allows you to submit the mart for all the currencies selected in the Model definition.
Select Specific Currencies to Submit	Allows you to submit the mart for the selected currencies only. Click Select Currencies. You see the Available Currencies dialog box. Select the currencies to use when you submit the mart, and click OK. If you submit more than one model, the Submission dialog box displays all the currencies and languages selected in those model definitions. If a model is not set up to use the selected languages and currencies, that model is not built.
Select Specific Funds to Submit	Allows you to select a subset of the entities defined in the submitted models and limit the data populated in the Data Mart. Click Add to display the Entity Selector dialog box. Click Load to populate the dialog box with all available funds. If you used the dialog box before performing this step and set up a filter in the selector, only those funds that meet the existing filter criteria are displayed. Select one or more funds in the top part of the dialog box and click Add. The selected entities are listed in the bottom part of the dialog box. Click OK to submit the selected entities.
Additional Options	Displays the Additional Options dialog box, which allows you to set more controls for submission. Options include: Set Fund Approval Status As. Select a status to assign to this build. See the section Manage Mart Data Status for details. Save Diagnostics. Includes diagnostic details in the execution log. Run at log level. Sets the execution log level for the submit process. Save temporary tables. If you are populating data into an Oracle database and need Eagle's help with troubleshooting a build error, check this box to save data into temporary database tables which assist Eagle with its diagnosis. If you set the status of a submission to a particular value, you affect the status of all data from every model associated with all combinations of Fund, As Of date, and snapshot in the current submission, including models not selected for submission. For example, suppose a user set the status as Preliminary and submitted Fund ABC, effective December 10, 2013, for the Country and Industry models. An hour later, another user set the status as Final and submitted the Trade Details model for ABC for December 10. The result is that the status of the Country and Industry models is now set as Final. The same is true of the Fund Summary and any detail level tables that had data rows for this fund and effective date.

Work with the Fields Selection Dialog Box

This section describes how to work with the Submission Fields Selection dialog box.

To work with the Submission Fields Dialog Box:

Select Build Selected Fields option on the Model Submission dialog box and click Select Fields.
You see the Model Submission Fields Selection dialog box.

This dialog box displays Models selected for the submission including Description, Extension, Field and Database Column Name.
To sort the columns, click the column name.
When you sort by Description or Column Name, fields within the subset of the fields in the model and extension are sorted.
Note: Check boxes for field selection are available at model, extension, and field level. When you select a check box at the model level, all fields under that model and all fields for all extensions under that model are selected. When you select a check box at the extension level, all fields under that extension are selected. You can also individually select one or more fields under any extension.
Click Select All to select all the fields. Click Deselect All to deselect all the 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.
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.
Click OK to close the Filter dialog.

Submit a Model as Ad Hoc

Select Options in Data Mart Model Submission Dialog

Work with the Fields Selection Dialog Box

0 Comments