I see the point of what you'd like to do, but in truth I do not believe it would be efficient.
You'd basically want to have Tableau Extracts working as mini databases, which is not really the purpose of Tableau.
The best way to split your data will always to do it at your database level. If you want to try preparing your data, you can also use our new tool Tableau Prep
I would also love to have this functionality. We have a rather complex Oracle extract that joins multiple tables together resulting in a large detailed dataset that we require for a lot of our detailed analysis (the task I believe Tableau was designed for).
I also need to use the same data for more complex summary analysis (lots of LOD calculations) and don't wish to repeat the complex joins and other requirements to get the data from Oracle. Not to mention redefining all my colours, sort orders, aliases and other particulars of the data extract. I just want to be able to summarise the detail data to a new datasource (which I realise won't stay current with the original, but since it's very specific one-off analysis, that doesn't matter). I need a subset of the original data, aggregated to a level that would significantly reduce the number of records I am dealing with.
It would be great if I could create an extract from the published data source and then use that for its own purposes. I tried to do this, and although it appeared that this is what Tableau was doing, it never actually created a separate local extract file, as far as I can tell.
Any help with achieving this would be much appreciated.
Not completely sure I am understanding correctly as I seem to be achieving some of what you seem to need :
I created an extract from Oracle and published it to Tableau Server.
I then connected to this extract from Tableau Desktop, applied a filter and then created an extract from it.
I then republished it with another name and that seems to be working fine. See attached screenshot.
TableauPublished.png 40.4 KB
Ciaran, that's exactly what I tried to do, but haven't managed to get it to work. I will give it another go. We are on 10.5... What version did you use?
Thanks for your time on this...
Hey Kim !
No problem at all !
I just tried this on 2018.1, once you create the second extract, try navigating to a new sheet and it should ask you to create a new local extract file.