After recreating attribute with lookup value we are unable to delete attribute:
Unable to delete attribute from Investment Object
Error: The selected attributes can't be deleted as they are being used. The error conditions are marked below
Clarity 16.0
Remove the global audit trial (administration > data administration > audit trial) set on the affected attribute and then delete attribute.