Add a mapped variable to the configuration

1. In the left navigation pane, click the Settings icon ().
2. In the Configure System section, click Manage Configurations.
3. Click the Row Action menu () for the data configuration, and then click Edit.
4. On the Modify Configuration page, click the Add New Variable link.
5. In the Name field, enter the name of the variable.

   Variable names display throughout the application, including when users select criteria for viewing data mining results, defining queries, or creating report definitions. For example, a column might be named SYMPTOM in the Oracle table, but renamed to appear as Event in the application.

6. In the Description field, type a description of the variable.
7. Next to the Table field, click Select Table/Column.
8. As the Column of source data, select the drug or event variable containing values that you want to map. The source column must be a text value.
9. In the Prefix field, enter a prefix.
10. From the Variable Type drop-down list, select Event or Drug.
11. Do not check Use as subset variable or Use as stratification variable.
12. Optionally, set up the mapped variable to use a hierarchy.
13. Set Hide From Query Wizard to Yes. (Even if this setting is set to No, the mapped variable is not available in the Query Wizard.)
14. In the Data Transformation section, click Text mapping, and then click Upload Table.
15. From the Upload Text Map CSV File dialog box, next to the File to Upload field, click Browse.
16. Select the mapping file and click Open. The mapping file must be in the format described in Map text values.
17. Click Upload.
18. To make sure the mappings are correct, click View Current Mapping.
19. Click Save.
20. Validate the configuration.

    Note:

    If you map a variable in a configuration for which there are existing runs that use the variable, users cannot drill down correctly in the run results until the runs are re-executed.