The multivalue control stores values as a string.

Therefore in the datawarehouse each value different user selection is present.
Ex: "Approved", "Investigate" is one value and "Investigate" is another.

Does anyone know how we could report each selected value to appear only as once value in the datawarehouse.