Maybe handle it in the datasource...server linking or openquery...
Not really sure that’s an option at the moment.
Currently table is treating the tables as separate entities which all link into one project id table, this is making it impossible to hold all the data within one chart, and even when I split them I am unable to use common filters on the dashboard.
Hey Christopher -
Not sure you're going to be able to get this done in Tableau without using some sort of server linking. Since Tableau isn't an ETL tool, you'll have to rely on the database to do this work for you - which limits your capabilities to writing queries which get the job done.
So, you could:
- Write an SSIS package which dumps all the data from x tables into a single table & run it during your batch window
- Use Linked Servers / Open Query to write a SQL statement which does a UNION on each table on each server
I don't see many other options. Marks idea is probably the best.