Hello Yeok Song,
I feel I'm missing some context to really answer this question. Where are you creating the data sources - are they materialised tables in your database? extracts created in Tableau Desktop? Flows created in Tableau Prep? Something else?
At any rate, if they are all based on the same underlying data, then they should all update whenever the underlying data changes, exception being that an extract would need to be refreshed or a flow re-run to get that data updated.
My base data are stored in Oracle. Everyday Datasource A will query Oracle. Datasource A is an extract.
What i need is to have new calculated fields, dimension/measures automatically appear when the datasource layer below is updated.
For example, if a new field is created in Datasource A, it should automatically appear in Datasource B. Is it possible?
1 of 1 people found this helpful
Thanks for the additional info.
So, all data sources will be based on the base data source (the Oracle data).
If new data/new fields are added to the Oracle data, it will appear in any of the data sources based on this data.
Calculated fields however are based on the individual data source they are created for, so they do not copy over to other extracts, for example.
Right now there is not a way in Tableau to have data sources dependent on each other in the way you describe, or automatically copy calculated fields from one extract into another one. You can submit an idea in our ideas forum for other folks to vote up: Ideas
our Product Managers review these ideas from time to time in order to consider what features to add to future releases.
Thank you Amber. Thats what i need to know.
Someone gave me the impression the tableau can automatically update new fields over from another datasource via some dependency mechanism. Thanks for clarifying that this feature is currently not available.