Difference between revisions of "Prepare View for DSA AD"

From DataSelf Knowledge Base
Jump to navigation Jump to search
(Titles That Show the Filters Used)
Line 25: Line 25:
 
# Fix or adjust the URL as required.  Rinse and repeat.
 
# Fix or adjust the URL as required.  Rinse and repeat.
 
# When the URL is ready, copy the first part of the URL to the [[DSA_Analytics_Distribution#URL|URL column]] of the .csv file, and the query string that begins with a ? to the  [[DSA_Analytics_Distribution#URL-Filters|URL- Filters column]] of the .csv file ([[DSA_Analytics_Distribution#Configuring_the_DSA_Commands_Parameter_File|DSA Commands Parameter File]]).
 
# When the URL is ready, copy the first part of the URL to the [[DSA_Analytics_Distribution#URL|URL column]] of the .csv file, and the query string that begins with a ? to the  [[DSA_Analytics_Distribution#URL-Filters|URL- Filters column]] of the .csv file ([[DSA_Analytics_Distribution#Configuring_the_DSA_Commands_Parameter_File|DSA Commands Parameter File]]).
 +
 +
=== Dashboards vs. Normal Views ===
 +
 +
When to use a view or dashboard in DSA AD?
 +
 +
Dashboards: They offer more control of how to layout information on the screen. Dashboards work great when all information can fit in a fixed windows size (such as with charts).  However, dashboards don't dynamically resize themselves. For instance, if you build a dashboard to show 30 lines of a view, but at one point this view has 35 lines, the bottom 5 lines won't show up on its AD's PDF file.
 +
 +
Views: Use views especially when a report has a dynamic number of rows and/or columns. When building views in Desktop, on the icon menu, set the drop-down to "Normal" and change the width of the view columns as needed.
 +
 +
=== Print Out Formatting ===
 +
 +
On Desktop menu: use File > Page Setup to select options such as:
 +
# Portrait or Landscape
 +
# Scaling
 +
# Layout margins and centering
  
  
Line 50: Line 65:
  
 
----------------------------------------
 
----------------------------------------
 
=== Dashboards vs. Normal Views ===
 
 
:When working with Dashboards, we have more control of how to layout information on the screen. So, if we can fit all information in a given dashboard and size of window (such as with charts), then Dashboards offer more ways to format the output.  However dashboards don't dynamically resize themselves to include more information such as when a report contains many detail lines. 
 
 
: When the size of the query is dynamic  not all information will fit in the PDF or PNG export.
 

Revision as of 03:43, 7 November 2015

Using Desktop to Prepare the Workbook for DSA AD

Create the View/worksheet with Tableau Desktop

  1. Prepare a view in a Tableau worksheet using DataSelf Analytics Desktop or Tableau Desktop.
  2. Copy the worksheet into a separate workbook dedicated solely for use by DSA AD. [You want to be sure that no one changes the workbook after it has been configured for use by DSA AD.)
  3. Give the worksheet a unique name - one that will not be confused with any other worksheet or report.
  4. Add a title that shows the value of the filter or filters that are to controlled by DSA AD. (Recommended)
  5. Add the refresh date ("Data current as of:") and the current date ("Run on: "). (Recommended)
  6. Publish the workbook to DataSelf Analytics Web Server or Tableau Server.

Prepare & Test the URL in Tableau web Server

  1. Open the workbook in DataSelf Analytics Web Server or Tableau Server.
  2. Copy the URL from the browser window to a text editor such as NotePad.
  3. Add the URL-Filter (a.k.a. query string) to the end of the URL. The query string is the the section of the URL that begins with a ?).
  4. Copy and paste the full URL back to the web browser.
  5. Press enter or reload.
  6. Evaluate the view displayed by Tableau Server.
  7. Fix or adjust the URL as required. Rinse and repeat.
  8. When the URL is ready, copy the first part of the URL to the URL column of the .csv file, and the query string that begins with a ? to the URL- Filters column of the .csv file (DSA Commands Parameter File).

Dashboards vs. Normal Views

When to use a view or dashboard in DSA AD?

Dashboards: They offer more control of how to layout information on the screen. Dashboards work great when all information can fit in a fixed windows size (such as with charts). However, dashboards don't dynamically resize themselves. For instance, if you build a dashboard to show 30 lines of a view, but at one point this view has 35 lines, the bottom 5 lines won't show up on its AD's PDF file.

Views: Use views especially when a report has a dynamic number of rows and/or columns. When building views in Desktop, on the icon menu, set the drop-down to "Normal" and change the width of the view columns as needed.

Print Out Formatting

On Desktop menu: use File > Page Setup to select options such as:

  1. Portrait or Landscape
  2. Scaling
  3. Layout margins and centering



Titles That Show the Filters Used

We want the title of the view or worksheet to display the value of the filter used. Tableau Server does not create or maintain titles so we have to use DataSelf (Tableau) Desktop.

For instance, if a report is designed for SalesPerson ID 123 then we might want the title to read:

Monthly Sales Report for SalesPerson 123.
  • NOTE: The corresponding query string for this report might read ?SalesPerson%20ID=123


Configuring a worksheet's Title with DataSelf (Tableau) Desktop

  1. Be sure that the Desktop view is using the dimensions and measures that you want to include in the query's title. For instance, drag and drop System Info > DataRefreshedAsOf to the Tooltip shelf so you can post that refresh date/time to the view's title.
  2. On Desktop menu: Worksheet > Show Title.
  3. Right click on sheet title > Edit Title.
  4. Click Insert drop down and choose the dimension being used for filtering.
  5. Feel free to insert regular description to make the title easy to understand.


Example: Code to enter into the Edit Title window
<Sheet Name> for Rep ID=<Rep ID>, data refresh at <DataRefreshedAsOf>