Currently, this capability is not possible. It is a good one for the Ideas section though!
as you alread have mutlple workbooks for each country why not create an extract for each workbook, publish those together and get those to refresh every morning?
Or create a number of datamarts from the master extract on the server, save those to the server , get them to refresh after the master has refreshsed and serve the data to the workbooks.
I often add calculated fields or change metadata (ex: alias) and do not want to repeat that process for every single workbook. So using a Tableau Data Server is ideal: I only need to change metadata/calculated fields once and all workbooks using the connection are updated as well.
My post was sent when I encountered a bug (confirmed by support) in which I could not create an extract of a Tableau Data Server if the data source contained some complicated calculated field (for some reasons the data source got corrupted upon publishing).
I haven't yet tried with other workbooks but I suppose that I could:
- Create a Tableau Data Server
- Connect all my workbooks to that Tableau Data source
- Create extracts at each workbook level that would be filtered based on my "Country" dimension
- Schedule refresh of my Tableau Data source
- Schedule refresh of each workbook (with lower priority than my Tableau Data source and in sequential order).
Would that work?
Thats the approach that i was thinking off. I would imagine that if you then changed a calculation or added more metadata to the master source, the "country" sources would see those changes too. Rather like a view on a database table.
Not tried it myself though.
Thanks Matt. If it works it would then solve a lot of issues: I could still download workbooks and open them in Reader (since they are extracts) and I would only need to change metadata at the Tableau Server data source to have them be reflected everywhere else.
I'll give it a try.