The Merge LOVs option can be used when LOVs with similar characteristics can be combined into one LOV, easing the maintenance burden.
For Oracle databases, this action requires single-update mode (SUM), as defined in the Single-Update Mode topic. For Cassandra databases, this action uses Lock-free Schema Change (LFSC) functionality, as defined in the Lock-free Schema Change topic.
Configuration
-
On System Setup, open the Lists of Values / LOVs node and click on each of the LOVs to be merged. Verify the settings within the Dimension Dependencies parameter and the match. For the example below, the two attributes 'ColorLOV' and 'Colour1' have the same value for the Dimension Dependencies parameter.
For this example, prior to merging the LOVs, the values for each of the LOVs can be found in the screenshot below.
-
Select the primary (master) LOV—the LOV that will remain after the merge, right-click and select Merge LOVs.
-
The Merge Value Lists wizard will display. Use the Browse or Search tabs to find and select the LOV to be merged (the LOV that will be deleted) with the primary LOV.
If an LOV with dimension dependency values that are different from the primary LOV is selected, then a warning will display and the Finish button will not be enabled, as shown below.
-
Click the Finish button to complete the merge process. The primary LOV remains with all the values from the two LOVs, and the merged LOV has been deleted.
