You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
Home > Introduction to Data Broker > DB: Introducing Data Broker > Calculated Fields in Data Broker - Asset Allocation
Calculated Fields in Data Broker - Asset Allocation
print icon

Data Broker can be set up on any Salesforce or Dynamics CRM. When setting up Data Broker on a non-Salentica CRM, the calculated fields can be still be included and mapped, but will require additional set up 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).
  • Salentica is not responsible for the creation, setup, or maintenance of the fields and objects listed below.


Steps to Setup 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 prior to mapping the Data Broker & data points. During set up, the asset classes from you Portfolio Accounting System will be mapped to one of the five the 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 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.

0 out of 0 found this helpful

scroll to top icon