My data source is Oracle. I usually have 2 schema, one for development and the other for production. They both have the same structure.
I want be able to switch them freely in a workbook. However when I used 'Edit Connection' and changed database user, all tables were removed, and I had to add the tables and join them again. What even worse is Tableau makes new alias for many of the table fields. So any calculation using original field name will have error. According to this forum, 'Editing Connection' should keep all Tableau information as long as both schema have the same structure. Did I do something wrong? Please help.