Wednesday, 9 March 2016

Project Creation and Content Publishing using TABCMD

Using TABCMD
·      Create two  projects for following two departments:
Billing and Facilities.
·      Publish up the following pieces of content found in the directory path: C:\Program Files\Tableau
o  The “InstantRendering” workbook belongs to the Billing department.
o  The “MultivariateAnalysis” workbook belongs to the Facilities department.
o  The “COGS” and “Coffee Chain” data sources belong to the Data Sources project.
·      Link to the list of available Tabcmd Commands: http://onlinehelp.tableau.com/current/server/en-us/tabcmd_cmd.htm


Solution:-

·      Create Billing Project:
o  "C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" createproject -n "Billing Project" -d "This project will hold all of the content related to the Billing department."

·      Create Facilities Project:
o  "C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" createproject -n "Facilities Project" -d "This project will hold all of the content related to the Facilities department.”

·      Publish “InstantRendering” workbook to the Billing Project:
o  "C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" publish "C:\Program Files\Tableau\WORKBOOKS\InstantRendering.twbx" -o -r "Billing Project"

·      Publish “MultivariateAnalysis” workbook to the Facilities Project:
o  "C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" publish "C:\Program Files\Tableau\WORKBOOKS\MultivariateAnalysis.twbx" -o -r "Facilities Project"

·      Publish “COGS” and “Coffee Chain” data sources to the Data Sources Project:
o  "C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" publish "C:\Program Files\Tableau\DATASOURCES\COGS.tds" -o -r "Data Sources Project"

o  "C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" publish "C:\Program Files\Tableau\DATASOURCES\Coffee Chain.tds" -o -r "Data Sources Project"

FULL SCRIPT:
"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" login -s http://localhost:80 -u admin -p admin > installLog.txt

"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" createproject -n "Billing Project" -d "This project will hold all of the content related to the Billing department." >> installLog.txt

"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" createproject -n "Facilities Project" -d "This project will hold all of the content related to the Facilities department." >> installLog.txt

"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" publish "C:\Program Files\Tableau\WORKBOOKS\InstantRendering.twbx" -o -r "Billing Project" >> installLog.txt

"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" publish "C:\Program Files\TableauWORKBOOKS\MultivariateAnalysis.twbx" -o -r "Facilities Project" >> installLog.txt

"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" publish "C:\Program Files\Tableau\DATASOURCES\COGS.tds" -o -r "Data Sources Project" >> installLog.txt

"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" publish "C:\Program Files\Tableau\DATASOURCES\Coffee Chain.tds" -o -r "Data Sources Project" >> installLog.txt


"C:\Program Files (x86)\Tableau\Tableau Server\9.0\bin\tabcmd.exe" logout >> installLog.txt

Thanks Guru's,
Prazval.ks

DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks