Learning BI and Data Analytics Tools

 To find Mount points size on the servers. : df -k To find current directory size : du -sh To find the current subdirectories and file sizes of current directory: du -h To find the current subdirectories and file sizes of current directory with sort: du -h |sort -h

Text Renders As Square Boxes Instead Of Expected Non-English Character Issue: A text in a view becomes full of squares after publishing this view to Tableau Server, and the expected characters that were formatted and displayed correctly and nicely in Tableau Desktop can no longer be seen.  Resolution: Work with the Server Administrator or your IT team to perform the steps below: Install NOTO CJK fonts or another font package that contains the missing glyphs Run [tsm stop] command to shut down Tableau Server. Reboot Linux OS. Run [tsm start] command to start up Tableau Server.

Create Users using Tableau API and Python User file will be in the format of userid, roleof the user. user1,Explorer user2,Creator User3,Viewer import tableauserverclient as TSC import csv userfile= open('C:/Users/myartha/Documents/Python Files/users_06112020.csv') usr = csv.reader(userfile) sourceusers=[] createdusers=[] pat = 'PersonalAccessToken'  #your personal access token created on the UI server = TSC.Server('<servername>') # provide your server URL siteid='siteid'   #yoursiteid from the server. This is not the nameof the site but id of the site tokenName = 'UserGroupScript'  #provide your Token name used when creating personal access Token server.version='3.6' ta = TSC.PersonalAccessTokenAuth(token_name=tokenName, personal_access_token=pat, site_id=siteid) with server.auth.sign_in_with_personal_access_token(ta):     userlist, pagination_item=server.users.get()     for user in userlist:         sourceusers.append(u...

Creating Tableau Projects and child projects with Tableau API and Python Prerequisites: Python on the machine tableauserverclient module API enabled on Tableau server. Permissions to update for the user Projects.csv file . list all groups in a csv file. attached format . Changes to be made in the script for below lines in the script groups = open('<Filepath>/groups.csv') pat='getyourpersonaltoken' server = TSC.Server('http://myserver.tableau.com',use_server_version=True) tokenName = 'mytokenname' Script: import tableauserverclient as TSC import csv Projects = open('filepath/projects.csv') prjt = csv.reader(Projects) projectstobe = list(prjt) sourceprojects =[] createdprjts = [] parentproj_id='' pr_perm = TSC.ProjectItem.ContentPermissions.ManagedByOwner pat = 'personalaccesstoken' server = TSC.Server('http://myserver.tableau.com', use_server_version=True) tokenName = 'mytokenname' ta = TSC.PersonalAccessToke...

 Creating Tableau Groups using Python and API Prerequisites: Python on the machine tableauserverclient module API enabled on Tableau server. Permissions to update for the user Groups.csv file . list all groups in a csv file Changes to be made in the script for below lines in the script groups = open('<Filepath>/groups.csv') pat='getyourpersonaltoken' server = TSC.Server('http://myserver.tableau.com',use_server_version=True) tokenName = 'mytokenname' Script: import tableauserverclient as TSC import csv groups = open('<Filepath>/groups.csv') grp = csv.reader(groups) sourcegroups=[] createdgrps=[] pat='getyourpersonaltoken' server = TSC.Server('http://myserver.tableau.com',use_server_version=True) tokenName = 'mytokenname' ta = TSC.PersonalAccessTokenAuth(token_name=tokenName, personal_access_token=pat) with server.auth.sign_in_with_personal_access_token(ta):    groupslist, pagination_item  = server.groups.get() ...

Synchronize ActiveDirectory groups If you have imported Active directory groups into Tableau Server, You have to periodically sync them to get the users reflected to Tableau Server. Single-site: Click Settings> General.   For Multisite: In the site menu, click Manage All Sites and then click Settings> General. Scroll down the page to Active Directory Synchronization, and then select Synchronize Active Directory groups on a regular schedule. Select the frequency and time of synchronization. Click Save. You can view the results of synchronization jobs in the Background Tasks for Non Extracts administrative view. Queue Active Directory Groups Sync is the task that queues and indicates the number of Sync Active Directory Group tasks to be run. Single-site: Click Status. For Multisite: In the site menu, click Manage All Sites and then click Status. Click the Background Tasks for Non Extracts link. Set the Task filter to include Queue Active Directory Gro...

Steps for performing a dirty restore 1. Install Tableau Server 2019.1.0 on the Dev machine 2. Stop Tableau Server 3. Copy the following folders from the current production: D:\Tableau Server\data\tabsvc\pgsql D:\Tableau Server\data\tabsvc\dataengine 4. Update the pg_hba.conf D:\Tableau Server\data\tabsvc\config\pgsql_0.<version>/pg_hba.conf Change "md5" to "trust" for the user "tblwgadmin" like this: host    all         tblwgadmin         <address>/32          md5 to : host    all         tblwgadmin        <address>/32         trust 5. Regenerate the internal token: tsm security regenerate-internal-tokens [options] [global options] tsm pending-changes apply 6. Re-index tsm maintenance reindex-search 7. Make a proper backup: tsm maintenance backup -f myBackup At this point, we w...