3.8 Managing Market Variable Data Mapping
The Market Variable Data Mapping feature allows users to define and manage how market variables are mapped to STSA variables. Use this configuration to define and manage how market variables are mapped to STSA variables.
Market Variable Data Mapping Interface Overview
The Market Variable Data Mapping page provides a structured layout for defining and maintaining variable mappings. It includes:
- Summary Screen Displays all available variables, grouped by
their logical reference and variable name.
Status color indicators help users identify mapping completion status:
- Red: No tables mapped to the logical reference
- Orange: Some tables mapped
- Green: All tables mapped
- Neutral Gray: No tables mapped (but optional)
Mapping Screen – Guided Process
Follow these steps to complete the market variable data mapping using the guided screen:
- On the Mapping Screen, locate the two sections:
- Primary Section
- Non-Primary Section
- In the Primary Section, enter valid values in all required fields.
- In the Non-Primary Section, enter values only if applicable for your configuration.
- Use the Data Catalog screen
to perform dimension mapping and retrieve the appropriate
drop-down values. If a foreign key relationship exists, the
drop-down values will appear automatically. If there is no
foreign key relationship, you must configure the dimension
mapping in the Data Catalog to populate the drop-down
options. Alternatively, you can enter the value
manually.
Note:
When entering a value manually, ensure it is a valid raw value that precisely matches the required format. - After completing each section, click Save
to store your entries.
Note:
Saving is enabled at each step. You must save before proceeding to the next step to avoid data loss.