A dimension can only be deleted if it is not used by a cube and has not been locked by a historical submission process.