The best option would be to wait for Tableau 10
use the cross datasource join to produce a single datasource.
this will definitely resolve your issue
but in the meantime I will have a look at this and see if I am able to suggest any workarounds for achieving this.
Yes I am aware of v10 functionality. But we are still using 9.2.
I'm a contractor and currently using 9.2 also. cant wait for my next contract and trying to ensure the next organisation is more up to date with their live versions
I just tried in v10, but am still not able to get it working correctly. I don't want to produce a single datasource out of it, as - (a) the volumes are massive and (b) the user db connection is a live connection
Can you please advise the procedure to implement it.
I was NOT able to implement it using 'cross-data source filtering' concept in v10 as parameters are not dynamically generated. Not sure why Tableau calls this as dynamic parameters as it simply removes the need for parameters.
However I was able to achieve similar thing with - 'cross database joins' (using live sql connection to determine user's region and doing a join of that info with the extract of sales). It is much better in terms of performance too