So I made a ticket a while ago and they gave me instructions:
1) Go to Sisense server:
Run the command:
kubectl -n sisense exec sisense-mongodb-xxxxxxxxxx -it -- bash
(where sisense-mongodb-xxxxxxxx is the name of your mongo pod, you may
type the command out and after ‘sisense-mongodb’ press Tab button, it should complete
the name. If this is not working you may find the mongo pod name by using command
kubectl -n sisense get pods | grep mongo )
2) You should see ‘>’ sign in the beginning of command line. Type
use prismWebDB
And hit Enter
3) In order to re-name duplicated columns type the following commands one by one, hit
Enter between each of them (in my case there were 3 columns)
db.getSiblingDB('prismWebDB').getCollection('datasetTables').updateOne({oid:
"[INSERT_CORRECT_OID]"}, { "$set": { "columns.YY.name": "[NEW_NAME_1]"}});
db.getSiblingDB('prismWebDB').getCollection('datasetTables').updateOne({oid:
"[INSERT_CORRECT_OID]"}, { "$set": { "columns.YY.name": "[NEW_NAME_2]"}});
db.getSiblingDB('prismWebDB').getCollection('datasetTables').updateOne({oid:
"[INSERT_CORRECT_OID]"}, { "$set": { "columns.YY.name": "[NEW_NAME_3]"}});
in which YY is the column number (e.g. 57).
4) After that cube should be available to open in UI