6.4.1 Creating Variables

Prerequisites:
  • Ensure that Pipeline Onboarding is completed before creating a variable.
  • Ensure that you configure the dimensions and connect other OFSAA application with STSA.
  • To configure variable metadata, populate the corresponding values in the EST_VAR_DEF_LOGICAL_MAP table.
To create a variable:
  1. Login to STSA.
    The Workspace Summary page is displayed.
  2. In the Workspace Summary, Sandbox tab, launch the required workspace.
  3. Click Building Blocks and then click View in the Variables section.
    The Variables Summary page is displayed.
  4. Click Create New.
    The Create a New Variable page is displayed.
  5. Provide a name and description of the variable.
  6. Select a default or custom variable group from the Variable Groups drop-down menu.
  7. Based on the type of value you want to save in the variable, select the type of a variable.
    • If the variables are numbers, select a Numeric type of variable else select Categorical.
    If you select Numeric type of variable, you have the following sub-type of variables:
    • Interest Rate Curve
    • Direct Ingestion
    • Matrix
    • PD Term Structure
    • CCF Term Structure
    • LGD Term Structure
    • Exchange Rate
    • Other Dependent Granular Variables
    • Micro/Macro Economic Variables

    For more information to create a Direct Ingestion type variable, see Interest Rate Curve.

    For more information to create a Direct Ingestion type variable, see Direct Ingestion Type Variable.

    For more information to create a Matrix type variable, see Matrix Type Variable.

    For more information to create a PD Term Structure type of variable, see, PD Term Structure Type Variable.

    For more information to create a CCF Term Structure type of variable, see, CCF Term Structure Variable Type.

    For more information to create a LGD Term Structure type of variable, see LGD Term Structure Type Variable.

    For more information to create a Exchange Rate type of variable, see Exchange Rate Variable Type.

    For more information to create a Other Dependent Granular type of variable, see Other Dependent Granular Type Variable.

    For more information to create a Micro/Macro Economic type of variable, see Micro/Macro Economic Type Variable.

    If you select Categorical type of variable, you have the following sub-type of variables:
    • Direct Ingestion
    • Nominal
    • Ordinal

    For more information to create a Nominal type of variable, see Nominal Type Variable.

    For more information to create a Ordinal type of variable, see Ordinal Type Variable.

  8. In the Variable Sub Type field, select the Variable Sub-type from the drop down menu.
  9. In the Variable Type field, select the Variable Type from the drop down menu.
  10. In the Input Logical Reference field, select the required logical reference.

    Note:

    Ensure that the input variable mapping aligns exactly with the selections made during the onboarding process.
  11. Click Continue.
    The Map Data Sources screen is displayed.
  12. 12. The system displays logical references and the corresponding stage table mappings. Map or modify data sources as required, then click Continue.
  13. (If Enabled) In the Add Source Filters screen, add any required filters to restrict source data and click Continue.
  14. (If Enabled) In the Add Dimensions screen, configure the required dimensions for the variable. and click Continue.

    Note:

    The Advanced Setup screen has been removed from the guided flow for Matrix (MS) and Term Structure (PD, LGD, CCF) variable sub-types. For all other variable types, the Advanced Setup screen remains available where applicable.
  15. The Review and Validate screen that opens, review all the details of the variable, including profile information, data source mappings, filters, dimensions, and advanced setup configurations.
    • Variable Profile details
    • Data Source mappings
    • Filters Dimensions
    • Advanced setup configurations
  16. (Optional) To add any comments, click the Comments tab and provide your comments and click Add Comment.
  17. (Optional) To add this variable to a tag, click Tags tab and provide the tag name and click Add Tag.
  18. Do either of the following:
    • To save the variable and continue later, click Save.
    • To submit the variable for review, click Submit for Review. and do the following:
      1. Review the Alert section to identify any configuration issues.
      2. If Critical alerts are displayed, click the corresponding Actions icon.
      3. Complete the required mappings on the relevant configuration pages.
      4. Return to the Review & Submit page and verify that all alerts are resolved.

      Note:

      For more information about sending objects for review and approval, see the Workflow for STSA Objects section.

      Note:

      When you are trying to create a new variable that has the same variable sub-type and metadata of an existing variable, then the system detects this and provides a notification about the creation of a duplicate variable. However, you can still continue with creation of this new variable by clicking yes in the confirmation screen.