A quick one that took a while to fix the issue, assuming it helps the needy.
The customer was running on EPBCS on version latest version. While running the database refresh it did throw the following error message,
Cube refresh failed with Essbase Cube: Cube Name,
