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