To minimize the pain, you can follow these steps. Before replacing, do these:
1.Hold ctrl key to multi-select all calc fields, groups, sets etc (Right click and select Copy)
2.Right click Dimensions or Measures shelf in the new data source, and paste all of them in one shot.
A few notes:
- You can do the above copy-n-paste after replacing data source. Those "!" will disappear after. Some Red pills will turn normal as Green or Blue.
- Parameters are independent of data sources. No need to copy them.
- Quick filters might turn blank after replacing or color legend gets double-over-typed. The remedy is:
1.Click X on the frame to close it.
2.Ctrl-Z to undo the above.
3.The filter will miraculously appear in multi-option form. Set the filter to single value type or whatever type you wish.
PS. Proposed an idea to Tableau to remedy the pain:
Please vote it up.
This comment has been removed by the author.
ReplyDeletePull the new data source in a new twb file.now open it with notepad++.search for the connection key word and you will find something like dbname="newdatasource". Now save your dashboard as twb and edit with notepad ++.again search for connection and you will find dbname="olddatasource" and here paste your new data source "newdatasource".now open your dashboard and data source would have replaced with al the formatting and alias name in place
DeleteWhy go through all that pain. Just duplicate the datasource first and then change the source.
ReplyDelete