Supergravity description of non-Bogomol'nyi-Prasad-Sommerfield branes