A hotel and local residents have successfully challenged a decision by Dublin City Council to grant planning permission for a large new outlet for a German discount supermarket group.