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:
In Reporting Center, from the left navigation, select Reporting Tools > Datamart > Manage Marts > Data Mart.
You see the Data Mart workspace.From the Manage Mart window, select the Detail model.
Click the Edit Model link.
You see the Edit Model dialog box.Click the Fields tab.
You see the Fields tab.Add fields and click OK.
Click the Funds (Entities) tab.
You see the Funds (Entities) tab.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 the system 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.Click the Access tab.
You see the Access tab.Assign access to the model.
Click Finish.