2.5.2.1.2 Expression

The Expression Mapping tab allows users to view and manage expression-based mappings between business terms from the Primary Catalog Business Terms (PBSM) and the Mapped Catalog Business Terms (FSDF).

1. Navigate to the Expression Mapping screen.
2. Use the search bar to filter terms by name from the Primary Catalog. This helps quickly locate a specific business term. The screen displays the Mapping Table. The main section displays a list of mappings in a table format:
   • Primary Catalog Business Terms (PBSM): Original terms from the primary data source.
   • Mapped Catalog Business Terms (FSDF): Target terms from the mapped data catalog.
   • Expression: Shows a View button to inspect transformation logic.
3. On the Mapping Table, click View to display the View Expression Details pane.
4. On the Expression Details pane, the Expression Name and Expression logic is displayed. The View Expression Details pane displays detailed information about a selected expression used in business term mappings.

   Note:

   Example:

   • Expression Name: Account Age In Months
   • Expression Logic: TRUNC(MONTHS_BETWEEN([As Of Date], [Value Date]))

     This formula calculates the difference in months between two dates, rounded down to the nearest month.