Wednesday, 19 August 2015

Parts of the Dataview

  • The parts of a view can be categorized as either table components, which are part of every view, or optional components, which can be turned on or off.
  • Data views are displayed in a table on every worksheet. A table is a collection of rows and columns, and consists of the following components: 
           Headers, Axes, Panes, Cells, and Marks.
           In addition to these, you can optionally show Titles, Captions, Field Labels, and                                                  Legends.
          They are shown as below.


Thanks Guru's,
Prazval.ks





Saturday, 15 August 2015

Export/Import Site in Tableau Server

Exporting a Site:-

In Tableau Server it is possible to take the backup of a specific site using exportsite command of the TAB ADMIN.If we Exports a Tableau Server site, including its users, workbooks, projects, extracts, and data connections  will be  placed  in a file with a .zip file extension.

Note:-
Tableau Server will lock the site being exported during the export process.

Syntax:-
tabadmin exportsite <site ID> --file <PATH>

For Example,
 In the Command Prompt Enter,
   tabadmin exportsite Aim1 --file "c:\users\Aimtech\Desktop\Backup\Aim_export"


 After successful Exporting It'l unlock the site as shown below

Importing a Site:-

We use importsite command  to import a site into Tableau Server.
Requirements:-
To perform import we need
1)An exported site file
2)The site ID for the target site.

Note:-
The site ID for Tableau Server's default site is "" (double quotes, no space).

Syntax:-
tabadmin importsite <site ID> --file <PATH>
For Example,
 In the Command Prompt Enter,
   tabadmin importsite Aim --file "c:\users\Aimtech\Desktop\Backup\Aim1_export.zip"


Note:-
When you run the importsite command, the command creates a temporary directory
containing mapping files in comma-separated-value (CSV) format that define how the
exported site's assets (users, workbooks, projects, extracts, and data sources) will be mapped
when the site has been imported. It is important that you verify these details

To verify it use imporsite_verified command,which is the second part of the import process
Syntax:-
tabadmin importsite_verified <target site ID> --importjobdir <PATH>

Finally import will be sucessfully completed as below if we dont have any errors.


Note:-
During the import process, Tableau Server locks the site receiving the import.

Thanks Guru's,
Prazval.ks





Friday, 14 August 2015

Tableau Server Architecture

Tableau has a highly scalable, n-tier client-server architecture that serves mobile clients, web clients and desktop-installed software.Tableau Server architecture supports fast and flexible deployments.

The following diagram shows Tableau Server’s architecture:



Tableau Server is internally managed by the multiple server processes.They are

1)Gateway/Load Balancer:-
It acts as an Entrygate to the Tableu Server and also balances the load to the Server if multiple Processes are configured.



2)Application Server:-

Application Server processes (wgserver.exe) handle browsing and permissions for the Tableau Server web and mobile interfaces. When a user opens a view in a client device, that user starts a session on Tableau Server. This means that an Application Server thread starts and checks the permissions for that user and that view.



3)Repository:-
Tableau Server Repository is a PostgreSQLdatabase that stores server data. This data includesinformation about Tableau Server users, groups and group assignments, permissions,projects,datasources, and extract metadata and refresh information.


4)VIZQL Server:-
Once a view is opened, the client sends a request to the VizQL process (vizqlserver.exe). The VizQL process then sends queries directly to the data source, returning a result set that is rendered as images and presented to the user. Each VizQL Server has its own cache that can be shared across multiple users

5)Data Engine:-
It Stores data  extracts and answers queries


6)Backgrounder:-
The backgrounder Executes server tasks which includes refreshes scheduled extracts,tasks initiated from tabcmd and manages other background tasks.


7)DataServer:-
DataServer Manages connections to Tableau Server data sources
It also maintains metadata from Tableau Desktop, such as calculations, definitions, and groups.



Thanks Guru's,
Prazval.ks




Wednesday, 12 August 2015

Configuring Autostart for Tableau Server

Using TAB ADMIN  we can configure the Tableau Server starts at system start-up time.
By default, Tableau Server
starts when the computer on which it's installed starts. If autostart is set to off, you will
need to start Tableau Server either using tabadmin start or the Start menu

To Display Tableau Server's auto-start status,In the Command Prompt Enter,
 tabadmin autostart


It will display the status as below.

To Disable  Tableau Server's auto-start behaviour,In the Command Prompt Enter,
 tabadmin autostart off

 It will display the status as below,
To Enable  Tableau Server's autostart behaviour,In theCommandPrompt 
Enter tabadmin autostart on



Tuesday, 11 August 2015

Customizing the Tableau Server

                                   

Using TABADMIN it is possible to customize(change) the name and logo used by the Tableau Server.

To change the name,In the Command Prompt Enter
Tabadmin customize name <Required.Name>
Ex:-
Tabadmin customize name "Aim Technologies Server" and Click on Enter.

Note:-
To Reflect the changes we need to restart the server,using
  Tabadmin restart


Once open the Server,it will changes the name as below 



To change the logo,In the Command Prompt Enter,

Tabadmin customize logo  <Required.logo>
Ex:-
Tabadmin customize logo "C:\Users\AimTech\aim.jpg"  and Click on Enter.

Note:-
To Reflect the changes we need to restart the server,using
  Tabadmin restart


 Once open the Server,it will changes the logo as below 

Thanks Guru's,
Prazval.ks

Monday, 10 August 2015

Restoring the Tableau Server

Hi Gurus,
    Let's see how to Restore Tableau Server to its previous state using a backup file.

Syntax:-
Tabadmin restore <backupfile-name/location> <options>

<Options>:-      Description:-

--restart             --Restart the service when the restore process has completed.
--no-config        --Restore the Tableau Server backup file including the data but excluding the                                  server's  configuration.

Note:-
When we run the restore command, the contents of the Tableau PostgreSQL database, data extracts, and configuration files are overwritten with the content in the backup file.
 Using the --no-config option restores everything Except the server's configuration settings.

Step1:-

In the command prompt Enter,

     tabadmin restore  <backupfile_location> [Options] and Click on Enter
    
     For Example,
              Tabadmin restore  aim_batch17.tsbak


It is going to start the restoration Process by stopping multiple processes



If restoration process is successfully completed,then it will restarts the service

Step2:-
After Restoration,once login into the server and checks the content.


Performing restoration without restoring the configuration settings:-

In the command prompt Enter,

     tabadmin restore  <backupfile_location> --no-config and Click on Enter
    
     For Example,
              Tabadmin restore  aim_batch17.tsbak --no-config

Thanks Guru's,
Prazval.ks










Sunday, 9 August 2015

Tableau Version History



TABLEAU Version History


        
·       

Tableau 7

Tableau 6

Tableau 5

Tableau 4

             
Thanks Guru's,
Prazval.ks


Count of A's in Each Customer’s Name

How many A's does each Customer have in their name(On Superstore Data)? Step 1: Create  3  calculated fields  “Cust Name Wi...