In a word, "No".
You may be able to write an application to do this by creating a basic .twb file since it's an XML (text) file. Create a couple simple blank reports, look at the resultant XML file that is the report, create a template based on what you find they have in common, and fill in the blank areas with your selected items. Just a thought.
(1) You could build yourself a BI cube in something like SQL Server Analysis Services
or much easier...
(2) Just build a Tableau data-source and publish to Tableau Server (as either a live connection or as a scheduled extract), then connect to the data-source using tableau Desktop and let users build any reports they want (or publish a blank worksheet to and let users use the web design interface).
Do you use Tableau Server? - seems the obvious choice.
Can you please provide some more details on the XML approach or provide some pointers to implement this.According to my understanding you are suggesting to modify the XML source code of tableau report.Is this possible?
Thanks Eric.....I think this will help.
Just one more question Is there any tabcmd to publish a data source.This will help in automating this process,rather then manually publishing the data source everyday.
There probably is a tabcmd option which lets you publish datasources, but it's much easier to do this from Tableau Desktop, The answer I'm getting at is that you build and publish a datasource which includes all possible dimensions and measures. You can publish this with a live connection or as an extract. If you use an extract you can schedule refreshes of the datasources.
Publishing a datasource:
Scheduling data source refreshes:
Using Tableau Server, ask Eric suggests, is what I would recommend as well.
I'm not an XML person but there are others here who are more skilled. The .twb file is an XML file so, yes, you could modify it; others have done so quite successfully. Open the file in any text editor (I use Notepad++) and look at the code. Do remember that messing with the XML for a workbook is unsupported so if Tableau changes how they do things you'll be on your own to make any fixes.
Here's the section on tabcmd in the Admin guide (the correct version):
You will find the tabcmd publish (publish filename.twb(x), filename.tds(x), or filename.tde). That will allow you to publish a data source.