0
0
Tableaubi_tool~10 mins

Publishing to Tableau Server - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
Sample Data

This data represents the key details and command used to publish a Tableau workbook to Tableau Server.

CellValue
A1Workbook Name
B1SalesDashboard
A2Server URL
B2https://tableau.company.com
A3Project Name
B3Marketing Reports
A4Username
B4user@example.com
A5Password
B5********
A6Publish Command
B6tabcmd publish SalesDashboard.twbx --project "Marketing Reports" --name "Sales Dashboard" --overwrite
Formula Trace
tabcmd publish SalesDashboard.twbx --project "Marketing Reports" --name "Sales Dashboard" --overwrite
Step 1: Identify workbook file to publish
Step 2: Specify project on Tableau Server
Step 3: Set the published workbook name
Step 4: Add overwrite flag
Step 5: Combine all parts into publish command
Cell Reference Map
    A                 B
1 | Workbook Name    | SalesDashboard
2 | Server URL      | https://tableau.company.com
3 | Project Name    | Marketing Reports
4 | Username       | user@example.com
5 | Password       | ********
6 | Publish Command | tabcmd publish SalesDashboard.twbx --project "Marketing Reports" --name "Sales Dashboard" --overwrite

References:
- Workbook file from B1
- Project name from B3
- Workbook name from B1
- Command constructed in B6
This map shows the cells containing the workbook name, server URL, project name, user credentials, and the final publish command that uses these values.
Result
    A                 B
1 | Workbook Name    | SalesDashboard
2 | Server URL      | https://tableau.company.com
3 | Project Name    | Marketing Reports
4 | Username       | user@example.com
5 | Password       | ********
6 | Publish Command | tabcmd publish SalesDashboard.twbx --project "Marketing Reports" --name "Sales Dashboard" --overwrite

Result:
The command in B6 is ready to be executed in a command line to publish the workbook to Tableau Server.
The final result is the full command line instruction to publish the Tableau workbook to the specified project on Tableau Server, overwriting any existing workbook with the same name.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the --overwrite option do in the publish command?
AIt replaces an existing workbook with the same name on the server.
BIt creates a backup of the workbook before publishing.
CIt publishes the workbook without requiring a project name.
DIt changes the workbook file format.
Key Result
The publish command combines workbook file, project name, workbook name, and overwrite flag to publish to Tableau Server.