Data Broker can be set up on any Salesforce or Dynamics CRM. When setting up Data Broker on a non-SS&C CRM, the calculated fields can still be included and mapped, but will require additional setup on your CRM.

Notes about this article:

• If you do not setup the information below as suggested, it is possible that the calculations and calculated fields will not act as expected.
• In this article, we will use Objects to describe either Objects (Salesforce) or Entities (Dynamics).
• SS&C is not responsible for the creation, setup, or maintenance of the fields and objects listed below.

Steps to Set Up Asset Allocation Calculated Fields

1. Create the required and optional Objects
2. Create the numerical & percentage fields and update them to be visible on the page layout for Financial Accounts and Portfolios
3. Map Data Broker data points to the new Objects and fields

4. Create models in CRM and assign to portfolios via a lookup (optional)

5. Run the integration to pull in holdings, asset class, and segment information

6. Map your custom asset classes to the five (5) asset class Object using the Asset Allocation picklist

7. Rerun the integration to generate the calculated values

Asset Allocation Picklist

To use the asset allocation calculated fields on the Financial Account and Portfolio Objects, you will need certain Objects are set up within your CRM before mapping the Data Broker & data points. During setup, the asset classes from your Portfolio Accounting System will be mapped to one of the five classes in the Data Broker:

1. Alternatives - Limited Partnerships, REITs, Real Estate, physical precious metals, cryptocurrency

2. Cash - Cash, Money Markets, Treasuries, Foreign Currency, CD’s

3. Equities - Stocks, ETFs, Mutual Funds, etc

4. Fixed Income - Bonds, Annuities

5. Other - Assets that do not fall into one of the above categories.

Once mapped from your existing schema, the holdings are aggregated to the five standard asset classes. Holding allocations are then aggregated to the Financial Accounts and then Portfolios. From there, you can use the mappable asset allocation market values and percentages in your CRM. In addition, at the portfolio level, you can map allocation target/drift percentages and compliance adherence based on models that are set up in the CRM.

Note: Models do not directly import from portfolio accounting systems to Data Broker. Allocation drift and compliance calculations are compared to existing lookup records in a CRM object from the allocation targets and drift percentages that are set up in the CRM.

Creating the Objects

The following objects are required for asset allocation calculated fields:

• Holdings/Security/Security Master
• Asset Class

The following objects are optional for asset allocation calculated fields:

• Segments
• Model

Additionally, specific fields must be created at the Portfolio and Financial Account level to map values from the calculated data points.

At the Asset Class level, a pick list is required with the following choices: Alternatives, Cash, Equities, Fixed Income, and Other. This picklist must be mapped to “Standard Model Class” in the Data Broker Mapping utility:

Required Fields

Required fields for each object can be found on the attached documents. Please contact the service team with any questions on these documents.