1 of 1 people found this helpful
Hi Jurien -
TabCmd does not allow you change the default value of a parameter when you use it to publish a workbook. The group of customers I work have very similar requirements to yours and generally approach the problem in one of two ways:
- They write their reports using a Data Source which leverages User Filters in other words, they allow Tableau Server to automatically filter out rows based on the identity of the user logging into server.
- In their workbook they hard-code a "token" value for the parameter and/or filter. For example, CustomerId 999999 - a value that will never be used in the "real world" and is obviously "fake"
- They write a little bit of Python / Ruby / <Insert language of your choice> to open up the twb (which is nothing more than an XML file) and replace 999999 with a real customer id.
- The code then saves the file with a different name
- The code optionally calls tabcmd to publish the workbook to Tableau Server
My people generally decide to use technique #1 vs. #2 based on how many users they'll be dealing with and the relative administrative overhead they'd look at to keep all of "their" users inside Tableau.
Keep in mind that Tableau doesn't officially support hacking the XML in a twb, so you'll be on your own in that regard - but it's quite easy to do and anyone with a little bit of technical know-how should have no problems taking this on.
Thanks for pointing out a couple directions. I will start playing with it