) for the data configuration, then click Edit.1. Click Settings.
The Settings page appears.
2. In the Configure System section, click Manage Configurations.
The Manage Configurations page appears.
3. Click the row menu () for the data configuration, then click Edit.
The Modify Configuration page appears.
4. Click the Add New Variable link.
The Edit Variable page appears.
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.
The Select Table and Column dialog box appears.
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.
The application displays the Choose File to Upload dialog box, providing access to your documents.
16. Select the mapping file and click Open. The mapping file must be in the format described in Mapping text values.
17. Click Upload.
The Edit Variable page appears.
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.