The Product Master in Assette is the central location where investment products are defined, categorized, and maintained. Each product entry typically includes a combination of strategy, asset class, vehicle information, and performance characteristics, all of which are critical for client reporting, marketing materials, and data consistency across the platform. Adding a new product to the Product Master involves a few structured steps using Assette’s source and sync Data Blocks.
This article outlines how to add a new product and make it available in Assette.
Prepare Product Data #
The first step in adding a new product is preparing its details in the Source_ProductMasterExtract Data Block. This Data Block acts as the source for new product entries and updates. It should include all key attributes that define the product and its structure. The required fields are:
- PRODUCTCODE – A unique identifier for the product
- PRODUCTNAME – The human-readable product name
- STRATEGY – The investment strategy associated with the product
- ASSETCLASS – The primary asset class (e.g., Equity, Fixed Income)
- VEHICLECATEGORY – Defines the type of investment wrapper (e.g., Segregated, Pooled)
- VEHICLETYPE – Further categorization of the vehicle (if applicable)
- SHARECLASS – The share class name or code
- PERFORMANCEACCOUNT – The account associated with product performance
- REPRESENTATIVEACCOUNT – The account used for reporting or display
- ISMARKETED – Indicates whether the product is actively marketed (
true/false) - PARENTPRODUCTCODE – If the product is part of a larger offering, this links it hierarchically
This data usually comes from your organization’s internal product source system (such as Snowflake, SQL Server, or even Excel). You will typically build a query or extract logic to populate this data into the Source_ProductMasterExtract Data Block.
🟡 Note: Ensure that all reference values (like strategy and asset class) used here have already been defined in the Attribute Master, or they must be added in parallel. Failure to do so will result in errors.
Ensure Reference Attributes Are Available #
Before syncing the new product, double-check that all related attribute values—such as Strategy, Asset Class, and Vehicle Category—exist in the Attribute Master. For more information on how to add new attributes, see How to Add New Attributes to the Attribute Master.
If any value (like a new vehicle category or strategy) is not available, it must be defined and synced first. Otherwise, the product sync will fail validation.
Optional: Map Product Offerings to Countries #
If your product is offered in specific countries or regions, you can define this relationship in the Source_ProductOfferCountries Data Block. This mapping requires:
- PRODUCTCODE
- COUNTRYCODE
Sync the Product Data into Assette #
Once the source data is defined and validated, run the ProductMasterSync Data Block. This sync block is responsible for reading from Source_ProductMasterExtract and updating the Assette Product Master accordingly.
During the sync, Assette checks for:
- Required fields and data types
- Mapping correctness for vehicle categories and attributes
- Unique identifiers (e.g.,
PRODUCTCODE)
If successful, the new product will be added to the Product Master and will be available throughout the platform, including in Data Objects, presentations, and performance reporting.
Validation #
After syncing, you can navigate to the Product Master section in Assette’s data management interface and confirm that the product appears as expected. Validate the following:
- The product name and code are correct
- Strategies, asset classes, and vehicle details are accurately represented
- The product is marked as marketed if it should be client-facing
If needed, you can preview data directly from the Data Block or update the source and re-sync.
Conclusion #
Adding a new product to the Product Master in Assette is a straightforward but structured process. By properly populating the Source_ProductMasterExtract Data Block and ensuring all supporting attributes are synced, you enable a rich,_