Issue
In many cases, your database schema changed if it's by:
- A column that doesn't exist anymore in the DB but exists in the cube schema
- Excel\CSV file that changed a location
- Change in names on the DB side
Unfuthenetly this will create a build failure for the cube you are using this information in.
Solution
Luckily the solution is easy, all you will need to do is to refresh the connectivity for that table
Web ECM
On the Data tab > Click the relevant cube > Select the table you wish to refresh the schema on > Click on the options icon for that table > Refresh Schema.
Once the schema is updated you can rebuild the cube successfully.
Desktop Elasticube Manager
Open the relevant cube > Select ElastiCube > Change Connectivity Settings > Refresh the issued table > Rebuild the cube