The Data Dictionary is the space in which you build the structure for the database that will hold all your data properties, Entity related properties, Statistics, Commentaries, Disclaimers, Cultures, etc. It provides a framework for your data architecture. This makes it easier for data to be correctly stored when it is uploaded and to be accurately retrieved when it is called. The Data Dictionary is fully customizable meaning that it can be configured for any type of data as per a business’s needs. Data Dictionary items cannot be deleted, or removed from the system, data therefore must always match the correct structure, and adding new data types is easily achieved.
Allocations properties are usually used for a spread of data that would be used in a table, chart or graph for displaying how a fund is allocated. For example, Geographic Breakdown would display data showing the geographic distribution of a fund. Allocations data tables always have 2 columns: a Label column and a corresponding Value column.
Allocations Data items are associated with entity types: Class, Fund, Account or Benchmark and each one has a Property Name (label), Unique Code (code) and Description attached. Not all fields are mandatory. Only Property Name, Unique Code and Description are displayed for Allocations.
Adding Allocations to the Data Dictionary
- Click + to add a new allocation property.
- Select the data type to add. Click Add Allocation Property.
Items in red are mandatory and must be populated, code and label.
- Type in the code – snake case (lowercase with underscores instead of spaces).
- Type in the label – the label can match the code but as semantic English in Title Case.
- Use the dropdown arrow to select the entityType. (Fund, Class, Benchmark or Account)
- You can add a description, but this is not a mandatory field.
- Type in core for group. This is no longer used but still needs to be populated.
- Click + next to extended to add additional columns to your Allocations table if needed.
- Add a label – what the column header will be.
- Add a dataType – string, number, decimal, etc.
- Add a formatCode if needed.
This translates to an additional column header in the Allocations table in Data.
- Click Save. A green successful task pop up bar will display across the bottom of the screen.
Allocation Data is populated in Data.