Configure the Detail Model

Data Mart provides the following Detail models:

• Position Details
• Position Look Through Details
• Lot Level Position Details
• Transaction Details
• Cash Flow Details
• Ledger Activity Details
• Security Details
• Issuer Details
• Performance Details

You must configure the fields and other parameters in the Detail models to populate data at the detail level.
To configure a Detail model:

1. In Reporting Center, from the left navigation, select select Reporting Tools > Datamart > Manage Marts > Data Mart. You see the Data Mart window.
2. From the Manage Mart window, select the Detail model.
3. Click Edit Model link.

You see the Edit Model dialog box.

1. Click the Fields tab.

You see the Fields tab.

1. Add fields and click OK.
2. Click the Funds (Entities) tab.

You see the Funds (Entities) tab.

1. Select one or more entities and click OK.

You do not have to complete this step for the Security Details and Issuer Details models. The Security Details and Issuer Details tables, unlike the other tables, are not populated on the basis of a group of entities. When PACE populates these tables, it finds the list of unique security identifiers in all of the existing detail level tables for the effective date. Then, it populates the Security Details and Issuer Details tables for those security identifiers only.
If your Data Mart must contain data for unheld securities, you can use the Security Build Information option on the Data Mart Configuration dialog box to build security data for unheld securities.

1. Click the Access tab.

You see the Access tab.

1. Grant access to the model.
2. Click Finish.