Issue#14: Tableau - Tableau Automated Extractions Update Tool

  • Good night folks,

     

    Because of the needs of a project, i am implementing a tool whose purpose is to update extractions indicated in .TWB files or .TWBX packages exported from Tableau Desktop, in scenarios where there is no Tableau Server.

     

    I know there is a similar function called RefreshExtraction in Tableau.exe, however unlike this feature, my implementation is intended to not rely on a Tableau Server, acting directly in .TWB / .TWBX files to automate the updating of data published to users that have only Tableau Reader.

     

    The main goal is to enable an upgrade process as self-sufficient as possible, through a command-line utility (TDEGen.exe), requiring only the following parameters:

     

    TDEGen.exe [-u [USER]] p [PASSWORD] -a [NAME FILE .TWB / .TWBX] d [NAME OF DATA SOURCE] -v [VEBOSE LEVEL] - l [ROWS LIMIT (TEST ONLY)]

     

    In this way, users could schedule its execution, for example, through the Windows Task Scheduler, establishing desired update frequency for each extraction, without worring about changes in panels / spreadsheets, schema defined data sources, filters sets, etc...

     

    So from the .TWBX / .TWB informed file, the application identifies the data source and the associated extraction, automatically identifies the schema required for related .TDE reassembly, connects to the data source, and prepare the necessary queries for its update. Connects to the Data Source using the informed credentials, and proceeds with information update, reassembling the original file (when pointed a .TWBX package) and its associated .TDE.

     

    Currently, im already using the tool with SQLServer Data Sources, but before provisioning other Data Sources Type, would like to share this initiative to get some feedback from forum members, regarding its usefulness in other scenarios.

     

    Thanks in advance !!!

    0 Answers

    Sorry, your answer is too short !

  • Issue#12: Tableau - update to primary server IP

    Over this past w/e, the IP of our primary Tableau server was updated to a new VM cluster within the network.  I followed instructions in the admin guide which states when this occurs, run a tabadmin stop, tabadmin config, tabadmin start in order to update communication throughout the cluster.  None of the commands worked (including "tabadmin stop").  Anybody have any ideas as to why or what to do?  For now, we rolled back the IP change. ORD-TBL107 (primary):        Status: RUNNINGORD-TBL104 (worker):        Connection error contacting worker 1ORD-TBL105 (worker):        Connection error contacting worker 2ORD-TBL106 (worker):        Connection error contacting worker 3

  • Issue#20: Tableau - Aggregation issue

        Hello all, I just want to begin by saying how much this forum has saved my job! Thanks everyone! I am having an issue getting my values to aggregate properly. I have attached two pictures below to help explain:BEFOREAFTERThe problem is that when I remove a dimension, the values are not aggregating properly. Each Facility and Cost Center should have 1 App attached to it and taking away Summary Pay type should not aggregate those Apps. Once I take away Cost Center, then they should begin to aggregate. I can use MAX() but then it keeps the same value when I get rid of cost center and I would want that to be Summed. The end goal of this is to track Dollars/App By facility and able to drilldown to cost center, then summary pay type and another layer of fidelity that I may add in. Thanks!

  • Issue#67: Tableau - Spell-Check for Tool Tips, Titles, All Text Boxes & Storyboards.

    I just assumed the tool tip edit box performed spell check. Just discovered (the hard way) this isn't the case. Rather hard to believe, but I'm sure they'll add it some day. If you vote this one up, maybe it'll get a little higher on their radar. And all of us bad spellers (and typo-typers) will git soem relive!  --Shawn Edited per Alex's request.

  • Issue#109: Tableau - Show Tool Tip for multiple entries in a map

    I have a question that I feel silly for not being able to answer.  I dataset that is shown only at the state level.  However, some states have multiple entries.  When mouse or click on the tooltip I would like the ability to switch between the entries, and display how many entries this state has.  Right now, it only shows the first entry, or shows asterisks.  This is not quantitative data, it's more like information about events within each state.  But I can only go to the state level.  Apologies for the basic nature of the question, but I've been searching the forum for a bit, with no luck.

  • Issue#56211: Tableau - Unable to update workbook with a DB2 extract on Tableau server

    Hi Guys, I have a question regarding the extract refresh and workbook update on Tableau server.I have a published workbook using 2 embedded data sources extracts, one coming from SQL server and other coming from DB2. When I schedule the extract for refresh, the extract from SQL server refreshes and updates the respective sheets but the same doesn't happen for the ones coming from DB2. I have a password embedded for the DB2 extract and I tested it successfully. Also tried editing connection, wiping out everything on server and posting again, and no filters on worksheets that would stop the workbooks from loading with new data. I see the timestamp for "last refreshed" as the time when schedule ran, but no changes to the worksheets. When I go on server -> <Workbook Name> -> Data Sources, and try to do a full refresh manually, it gives me an an alert as below: I would really appreciate if someone could tell me what am I missing out or is there any issue with DB2

  • Issue#78085: Tableau - Why does the Backgrounder fail though there seems no memory issue ?

    Hi All, I have Tableau Server version 9.2. Data sources are extracts and MySql data connection. I have 3 backgrounders. The system is of very high configuration (64bit, 32 Gb RAM, 7.5 TB memory). MySql Db is on different server than Tableau (which is also with good config) Sometimes there seems error as Lost Connection-com.tableausoftware.nativeapi.dll.TableauException: [MySQL][ODBC 5.3(w) Driver][mysqld-5.5.39]Lost connection to MySQL server during queryin background status of extracts although the refresh extract query is not heavy and executes in seconds. When I look at show processlist there was no memory issue/lock or anything during the execution. Also the system memory on both the servers seem fine too during the error time. I have seen in some threads where it is mentioned that the backgrounder restart itself in some interval.Is that true?  I am getting this issue in this version only. Din't get in previous version. Also, not every time same extract gets fai

  • Issue#94630: Tableau - Sizing issue

    HiNeed help with server sizing issue.30~ datasourcesAll datasources are liveDB is Hive/Hadoop100~ users – means 10~ concurrent usersA lot of data – 500~ Tara

  • Issue#126310: Tableau - Parameter Issue

    Hi All, I got issue with parameter where iam trying to find 'sales' of Sub-category for Last >15days,>30days,>45days from today date. So i created a parameter for 15days,30days and 45days and i wrote calc like if [Days] = "15 days" and DATEDIFF('day',TODAY(),[Order Date])< 15 then "Show"elseif [Days] = "30 days" and DATEDIFF('day',TODAY(),[Order Date])< 30 then "Show"ELSEIF  [Days] = "45 days" and DATEDIFF('day',TODAY(),[Order Date])< 45 then "Show"ELSE "Hide" END  but above calc is not affecting view and i attached twbx file so can someone pls look into my issue and correct me where iam making erro (twbx file is in 9.1version)  Thanks

  • Issue#129584: Tableau - I am trying to create a URL action and edit Tool tips.

    I am trying to create an interactive dashboard that will allow the user to "click on the arrow" and be directed to the Wikipedia site.  I would also like the user to be able to hover over the planet and see the "planet name. distance from the sun, etc.." (I have attached the workbook and Excel spreadsheet)  

  • Issue#131748: Tableau - Aggregation Issue (Part II)

    Hello all, Some time ago I was having an issue with my data due to the level of fidelity it was being joined on. I've since gotten a solution for it which can be seen in my attached work book's calculated field. I have an incremental ask to this issue now. Now, I am able to aggregate properly by pay period but When I try to sum up the year, it is aggregating only the values that are there instead of by the cost center. Example attached. When you remove the Pay Period pill, each value on the stage should be the same as long as it's in the same cost center, regardless of the pay type or job class. QA: The sum of A Cost Center 6000 should be the ball park of 8563. Thank you!

  • Issue#165499: Tableau - Is it possible to update my database with any preprocessings made in Tableau?

    Hello, is it possible to update my database with any preprocessings made in Tableau? For example that a calculated field gets added as a new row to my database table. What about saving my tableau table to an entirly new table in my database? Wouldn't that be helpful to use the same data between multiple different software systems? I can't find that option. Kind Regards,Jakob

  • Issue#174951: Tableau - Rank calculation issue

    Hello Friends,Quick question here- On the attached, I'm trying to display the top N customers based off my parameter "Top Customers 1". Everything seems to work correctly until I begin to filter my view. For instance, if I select "STS" instead of "All" on the Business Segment quick filter, Tableau doesn't display the specified number of customers based off my Top Customers 1 parameter. Any idea how to resolve? Regards,Mikey

  • Issue#177599: Tableau - Correct Calculated Field for Graphs to Update when Using Different Filters?

    Hi all, I have encountered a roadblock and was wondering if anyone here could help me. Using Tableau Public, I have been working on the following visual: https://public.tableau.com/views/HeatStressVisibleNDVIRadishesFebruary242016batchplantedFebruary122016_0/Dashboard1?:emb…  As you can see, I have two comparison "images" that have been processed differently. I have selected and made sets to act as plots for each image, and I want to see how the histograms above change when I use the filter to look at a specific area. My issue is that while I am able to get the histograms and calculations above to update when I was working with one image, when I have two images the method does not work any more. This makes sense as the underlying data, the RGB values of each pixel with respect to its parent image, are different. The issue presents itself if you were to deselect all "NDVI" and toggle "Visible" selector—nothing happens in terms of the graphs.

  • Issue#180108: Tableau - Issue of Adding Reference Line...

    Is anyone aware of an issue when using Adding Reference Line...(and selecting Line, Per Cell, Total, Value)? I would like to show the totals, but it turned out it only displayed the "$" -- only when you hover over it, it will show the total values. Does anyone know why the values were cut and how to resolve it? Many thanks!!

  • Issue#185647: Tableau - Dates Issue Aggregate and Non-Aggregate Arguments

    I took over a few reports and have been checking them over.  They used  IF [Cont Begin Date - Formatted]< Date(‘2/1/2016’), that being the date of the source date, which is a manual pull.  I would like something similar to  IF [Cont Begin Date - Formatted]< MAX([Date of Action]), MAX([Date of Action]) would return 2/1/16 as there are actions every day.  Of course this won’t work since it is doing aggregation and non-aggregation.  Any ideas on a work around?   Desktop 9.0 and sample workbook attached.    Thanks

  • Issue#198296: Tableau - SQL Server impersonation issue

    Hi All, I've a small issue with SQL server impersonation configuration. To give the details, I'm using live connection to a MS SQL Server Database in one of my workbooks (published with impersonate via server run as account) and the tableau service account has db owner permissions to that database. When I grant a user access to that database, his access to the tableau workbook on the server works fine. However when I remove his access to that database on SQL Server, he is still able to access the workboook. Pls let me know if this is a limitation or am I missing some setting anywhere. Kindly help me.  Thank you!Surendra

  • Issue#237183: Tableau - Calculate a forecast based on a calculated formula (not the forecast built in tool)

    January 2015: 100February 2015: 101March 2015: 102April 2015: 103 My dataset shows the following 4 dates above. If I wanted to forecast to be +1 the month before. May 2015 as 104 and March 2015 as 105. Is this possible? (Extend this as far out as needed...lets say maybe year 2020) I don't want Tableau to tell me what the forecast line equation will be. I need it to calculate it on my own formula and preferably be able to change it. (Lets say I want to now do +2 the month before or *2 or /2 the month before.) Currently I have set reference lines at the desired months (Dec 2015 calculated field with value of 111) however this means a field and reference line for every month. I can't show the line growing towards December.  Any help would be appreciated.

  • Issue#256851: Tableau - Issue in setting up AD with tableau server

    We are in the Process of Setting up Tableau Server 9.2 with Active Directory Authentication. We have created a generic AD for that as well. Our AD team is not allowing us to provide Admin Privileges to that AD ID. They are asking for specific rights to be given to that ID. In Tableau documentation, it is not clearly mention regarding list of permission to be given to the id. Can anybody please specify that what all privileges / Access rights / Permission / Group an AD ID should have to configure that AD ID as the Administrator of  Tableau while initial setup of Tableau ?

  • Issue#257245: Tableau - Highlight Filter causing issue with rank

    We have a landing page where a supplier is selected via a parmeter. This then highlights the supplier on the subsequent dashboards. When we add a rank via rank formula or index the supplie we originally chose displays as rank 1 even when they are not ranked 1st. How can this be updated so the selection is ranked correctly    

  • Issue#257856: Tableau - Data blending Zip codes performance issue

    I am looking for the best / most efficient way to blend or join a secondary data source which contains a master zip to territory mapping. Primary data source: (live connection tableau online) each row has a zipSecondary data source: (excel) master zip file with ~40k rows (all US zips) - each zip is tied to a territory I am looking to add the territories from the master zip to territory file as a filter. I tried data blending using the zip codes as a common field but I am facing very slow performance. Is there a better way to do this?

  • Issue#276716: Tableau - Data Blending Left Join Issue

    Hi All, We are currently developing a customized usage dashboard for our business users. We are blending data using multiple data sources and both data sources are connecting to PostgreSQL databases. In the second data source we are using custom SQL which basically pulls the users who are in Usage and Admin AD groups. All sites contains corresponding Usage and Admin AD groups accordingly. Our aim is to provide the users logged in with their sites usage data. For example, user X is only part of site A and when he logs in he should be viewing only site A's usage statistics and if user Y is part of site B and C, he should be viewing both sites B and C's usage statistics. For the security piece we are capturing user login information using GetUserName() function. But we have a issue here with the Site Name filter. When a user X logs in, he is able to see only his sites corresponding data getting filtered but the site name filter shows all sites within the environment. we want to

  • Issue#300936: Tableau - One to Many issue

    Hi Every body, I am facing with 1-many logic, I am connecting to a SQL database with multiple tables. One of the joins has a "one-to-many" relationship to the other tables. However, I don't want to duplicate the data in the "one" table based on it's connection to the many table. For example:  This is really urgent, so I would if someone can help me on this.thank you

  • Issue#316127: Tableau - 53 weeks issue

    I have a purchase date field in database. When I use week(purchase date) in my report , I get 53 weeks on x axis. How to trend a measure for 52 weeks only. Kindly let me know what formula should I use to handle this year end issue.

  • Issue#339632: Tableau - issue with CAGR calculation

    Hi All, we have create a CAGR calculation by using Lookup(): (LOOKUP(SUM([Month Totals]),LAST())/LOOKUP(SUM([Month Totals]),FIRST()))^(1/(SIZE()-1))-1 Formula will only work, if all years are visible.Now I am searching for a way, how to adjust the formula to be able to display only a few years.Can I refer to value for 2012 and 2016 and also lookup the specific years instead of using SIze() within formula?  Thank you very much in advance for any hints. Best regardsSabine

  • Issue#361239: Tableau - SAP HANA Connection Issue

    Hi everyone, I am facing issues while connecting Tableau to SAP HANA using native connector. I am getting the below error:  I am using Tableau Desktop 9.2 version. I have installed SAP HANA client and Studio on my system . I am not able to find HANA driver name with Registry Editor (no folder found for ODBCINST.INI ) . Do we need to install drivers separately for SAP HANA?Please advise if anyone knows the resolution. Thanks,Rekha Bathla

  • Issue#401955: Tableau - Data Blending Issue

    Hi All, I am working with two data sources and I need to blend some data fields from both data souses to create some dash boards. I did data blending but it does not give me correct results what I expect. I have attached a sample workbook by enclosing similar example which I faced. For your convenience, I have attached two screen shots of results what I expected and observed 1. This kind of figure I am expecting to have. In my two data sets one have 5 ICUs(A, B, C, D, E) and 3 for other(A, B, D) . But this figure shows 3 ICUs(A, B, D) which are in data set 1. But I need to show rest ICUs though those do not have data (C and E) 2. When I blend Data I observed this figure. This figure shows rest 2 ICUs(C and E) But failed to show discharge type correctly as in figure 1 when dragging discharge type into color shell Can anyone please kindly help me to getting this problem solved. I have attached my tableau workbook as well. I can work upto tableau version 9.2. 

  • Issue#404765: Tableau - What is the difference between Update Now and Automatically Update

    Hi All, Pls help me understand the difference between "Update Now" and "Automatically Update" options while connecting to the data connection. Can anyone help me with the differenrces on this. Pls help me with this, I am new to this. Thanks,Parvinder

  • Issue#428542: Tableau - Update measure with multiple parameters

    Hi, I have a table with a number of products with a measure "Prices".  Is there a way to update this measure (or a substitute measure) using a parameter for each product?  I am using the data in a calculation but I need the end user to be able to update the prices on the dashboard. I am open to any solution that will work for this. Thanks in advance/ Regards,Alexis

  • Issue#441109: Tableau - List of Values in tool tip plus...

    I want to have the  bubble show the product line. then when i hover over it, i want it to display all the products in the product line with corresponding revenue.. possible?