Thursday, March 7, 2013

[TABLEAU] Displaying Different Dimensions For Different Users In Tableau Server




Displaying Different Dimensions for Different Users in Tableau Server

This article explains how to show different users (or group of users) the same graph, sliced by different dimensions. This functionality is useful when you are creating an enterprise-wide business intelligence deployment and want to use one view or dashboard to satisfy the needs of different departments. 

For this example, senior managers need to see the graph shown here with customer segment in rows, and regional employees need to see regions in the rows. The basic view type is shown below; this is the regional employee view.






Create a calculated field

The ISMEMBEROF function returns the group that the user belongs to. You can use this function in a calculated field to decide which dimension is copied into the calculated field named "Swap Dimensions."

In this example, connect to the Superstore sample.


Step 1
From the Dimensions pane, drag Product 1 - Category and Product 2 - 
Sub-Category onto the Columns shelf.


Step 2
From the Measures pane, drag Sales, Customer Segment, and Region onto the Rows shelf, and drag Profit onto the Color shelf on the Marks card.


Step 3
Select Analysis > Create Calculated Field.


Step 4
In the Calculated Field dialog box, make the following selections to create this calculation:


IF ISMEMBEROF("Senior Management") THEN [Customer Segment]
ELSEIF ISMEMBEROF("Sales") THEN [Region]
ELSE "Total Sales"
END


  1. In the Name text box, type Swap Dimensions.
  2. In the Functions list, double-click IF and ISMEMBEROF.
  3. Inside the parentheses, type "Senior Management".
  4. Click outside the closing parenthesis, space, type THEN , and space again.
  5. In the Fields list, double-click Customer Segment, space, type ELSEIF, and space again.
  6. In the Functions list, double-click ISMEMBEROF.
  7. Inside the parentheses, type "Sales".
  8. Click outside the closing parenthesis, space, type THEN , and space again.
  9. In the Fields list, double-click Region, and then space.
  10. Type ELSE "Total Sales" END





Step 5
When finished, click OK.



Use the calculated field in your view.


Step 1
Remove Region and Customer Segment from the Rows shelf; leave Sales in place on the Rows shelf.


Step 2
From the Dimensions pane, drag Swap Dimensions to the Rows shelf.


Step 3
Select Server > Log On.


Step 4
In the Tableau Server Login dialog box, type your Tableau Server address, your username, and your password. Click OK.



Notice that your name now appears in the lower right corner of the Tableau window, just above the system tray.



Step 5
Select a user from this list who is a member of the Senior Management group. If such a group does not exist in Tableau Server, you can create it.


Step 6
When you are satisfied with the results, select Server > Publish Workbook.


Step 7
In the Publish Workbook to Tableau Server dialog box, under View Permissions, select Add.





Step 8
In the Add/Edit Permissions dialog box, under User/Group, select Senior Management, and then click Apply.



Step 9
Select Sales and then click Apply.


Step 10
When finished, click OK.
Both groups now appear in the User/Group list in the Publish Workbook to Tableau Server dialog box.

You added them as viewers, which means that they can see the workbook, but cannot edit it.


Step 11
Under Options, in the Generate Thumbnails As User list, select Sales.
For additional security, select Sales or no view for the thumbnail view.





Step 12
Click Publish.
The Publish Workbook Results window opens, showing a preview.













4 comments:

  1. Tableau online Training, ONLINE TRAINING – IT SUPPORT – CORPORATE TRAINING http://www.21cssindia.com/courses/tableau-online-training-226.html The 21st Century Software Solutions of India offers one of the Largest conglomerations of Software Training, IT Support, Corporate Training institute in India - +919000444287 - +917386622889 - Visakhapatnam,Hyderabad Tableau online Training, Tableau Training, Tableau, Tableau online Training| Tableau Training| Tableau| "Courses at 21st Century Software Solutions
    Talend Online Training -Hyperion Online Training - IBM Unica Online Training - Siteminder Online Training - SharePoint Online Training - Informatica Online Training - SalesForce Online Training - Many more… | Call Us +917386622889 - +919000444287 - contact@21cssindia.com
    Visit: http://www.21cssindia.com/courses.html"

    ReplyDelete
  2. Thanks for your informative article.Its very helpful to my business intelliegence.thanks a lot. Tableau Training in velachery

    ReplyDelete
  3. This post is much helpful for us. Thanks for this great share. This site is a fantastic resource. Keep up the great work here at Sprint Connection! We are expecting more interesting and useful Topics.
    Determining Hardware and Software needs in Tableau Server

    ReplyDelete
  4. It's Very Nice and Such an ideal piece of blog
    Tableau Online Course

    ReplyDelete