Issue#50: Tableau - Tableau creating wrong syntaxs when accessing data through ODBC connection

  • Hello ,


    We are accessing data from one of our hive cluster using quboles ODBC connector and for some reason Tableau is not able to recognize the data types ,So we did change the data types from the tableau interface and tableau is trying to send a query with a wrong syntax to the hive server .


    So here is an example of what I am talking about


    set hive.cli.print.header=false;

    explain SELECT 1 AS `column1`, `Tablename`.`column2` AS `xyz`, `Tablename`.`ad` AS `ad_slot`, `Tablename`.`advertisername` AS `advertisername`, CAST(CAST(`Tablename`.`cpm` AS `DOUBLE`) AS `DOUBLE`) AS `cpm`FROM `db`.`Tablename` AS `Tablename` LIMIT 10000



    Here in the above sample query you can see in the highlighted part where Tableau is keeping the data type in the quotes and the underlying data base engines(Hive) are unable to understand the syntax and thus leading queries to fail.


    So the question is how do we get around this problem of the syntax that tableau is sending to the Hive server using the Qubole Hive ODBC .


    Any Help would be appreciated.



    0 Answers

    Sorry, your answer is too short !

  • Issue#31: Tableau - Creating a table calculation that sets goals to be 50% higher than the previous high value in data set

    Calling all Tableau Experts! I have 10 months of data, January thru October. I’m trying to write a table calculation that sets a new goal for First Pass Yield that’s 50% higher than the previous high First Pass Yield monthly aggregate. That’s a bit of a mouthful, so here’s an example to better illustrate what I’m looking for (Reference the below table for the values I’m talking about):   First, obviously, January has no previous lookup value to measure against so I’m setting that Goal value to just be .5 (just so there are no Null values in the table calc). For February’s goal, the calculation should be January’s FPY actual plus 50%, which in this case would be 77.27%.      Goal % Calc = ((1-((Lookup(Previous High Value)))*.5)+(Lookup([Previous High Value)))  Now, because February’s FPY was lower than the first month, the goal would still be set at 77.27%. This trend conti

  • Issue#34505: Tableau - Creating trend line with long form data

    Hi guys, *this might be a super simple fix but my Tableau skills are...lacking So I have data with the following columns: Date, Athlete, Factor, ValueAnd as variables for the "factor" column, there are things like Sleep Hours, Soreness, Stress, etc. What I'm trying to do is build trend lines between things like Sleep Hours and Stress over time - and looking at how these things correlate.  I have measure built for each variable under factors: IF [Factor] = 'Stress' then [Value] ENDBut when I grab two of these measures, stress and sleep hours, the graph returns that I have 250 nulls or however many. I'm assuming this is because when Tableau searches each row it looks for Stress and finds, ok stress = 5, but then in that same row, there is no corresponding value for sleep hours - because of course that value is contained in its own row of data with the factor, "sleep hours" and the corresponding value. These values are of course only linked by the name of the athlete and th

  • Issue#120055: Tableau - creating filtered and unfiltered components of a view through data duplication/ relationsh

    Hello,I am attempting to create a dual axis chart with a filtered and unfiltered component through the method suggested my michel cassie in the following thread: Can i have a Dual axis chart but with a filter applied only on one?  In the attached example workbook, I have attempted to remove the department relationship between the original and duplicate data sets in order to enable filtering the bars (original data) by department while leaving the line representing moving average of profits of all departments (duplicate data) unfiltered. However, filtering still affects the moving average.  Would anyone be able to take a look and offer any suggestions as to why I have not succeeded in producing a moving average line that is not affected by a department filter? Many thanks,Zach

  • Issue#199315: Tableau - Filtering in on Specific Dates on Data Set and Creating buttons on Dashboard

    Hi All, I am creating a dashboard and looking to create a function on my dashboard which allows me to click on a button (eg. Out of date, going out of date next week, out of date in the next 4 weeks.) The purpose of the dashboard is to show all data and then the user is able to filter in on their region and as mentioned above the data which is out of date. Is there a way to create a parameter or calculated field to: 1.) Look at specific date ranges (needs to be by Day Month and Year) by pulling across a calculated filed or parameter2.) Then on the dashboard create buttons which selects the out of date/going out of date etc.3.) This needs to work with other filters created. Thanks in advance! Andy

  • 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#340809: Tableau - ODBC Connection - Token LIMIT was not valid

    I'm trying to connect to our Accounts Payable data through an ODBC connection.  When I try to access the data, I get the following error: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token LIMIT was not valid. Valid tokens: FOR USE SKIP WAIT WITH FETCH ORDER UNION EXCEPT OPTIMIZE. Anyone have an idea what this means?  I'll probably need this explained to me like a 3rd grader.  Thanks!

  • 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#429675: Tableau - Error when creating extract file - Tableau Data Engine Error: 48041: Invalid Command: data

    Hi there, When I was trying to create an extract file, I got this error message: Tableau Data Engine Error: 48041: Invalid Command: database: Path does not exist.  How can I fix this issue? what is the root cause? Thank you, Jason

  • Issue#541903: Tableau - What are the various visualizations we can provide for weather data connection with Tablea

    What are the various visualizations we can provide for weather data connection with Tableau. I have below parameters given by customer.. Please help me with what are the possible visualizations that can be developed?  alertIdcorridorCodecreatedBycreatedDateTimedirectionendMilepostendTimeisNotifiedissueTimemessageoriginalCreatedDateTimeoriginalUpdatedDateTimerawSpeedspeedspeedUnitstartMilepoststartTimestatussubDivCodetypeupdatedDateTimeversion

  • Issue#569564: Tableau - Display Data Connection name in worksheet or dashboard

    I've searched high and low and I've come up empty handed in my attempts to add the Data Connection Name to a worksheet or dashboard.  I'm connecting to an excel spreadsheet as my data source and I need to be able to display the name of the spreadsheet as field on my dashboard.  I'm sure this is an incredibly simple function, but for the life of me, I can't find out how to do it.  I know I could simply add the file name as a field in my spreadsheet, but my spreadsheet source is generated output from an application and while the file name will change, the content won't.  Any help on this would be greatly appreciated.Cheers and thanks in advance

  • Issue#592438: Tableau - Wrong data (actual data x 800) shown when pulling from data connections. WHY?

    I have the following data model feeding the dashboard. The source is an excel spreadsheet with multiple tabs, which are shown connected with 'School Info.' It's working fine, except that for the enrollment data, it is showing the actual number x 800 when pulling from the data model/connections. WHY??? This is the data pulling from a single source - the same excel spreadsheet's enrollment tab, expect it's not connected to any other data.   But when it's connected (as shown on the first image), the numbers are in the thousands! Curiously I noticed it's the actual number x 800. I can't figure out what's happening!  

  • Issue#599488: Tableau - Data blending summation issue

    I am facing one issue while aggregating the data from date to month rollup on data blending of two different sources. When I am rolling up data which is % based from date level to month level, It is not aggregating based on date at month level. See below requirement to get clear idea.  Month of Date opened, Day of Date Opened, Full/Partial & Percent impacted user are coming from EXCEL data source (Primary Data source). The Total User is coming from Google Analytic (Secondary Data Source). Whereas “User impacted by percent” is the calculated field created based on these data source. Here is the formula of User impacted by percent:  if SUM([Percent impacted])=1THEN SUM([GA (GA_Dataset)].[User])ELSE (SUM([GA (GA_Dataset)].[User])*SUM([Percent impacted]))END I tired ATTR in above formula instated of SUM(Percent impact) but didn’t help me. See attached workbook sample for detailed understanding. Data at date & month level:Month of Date Open

  • Issue#622364: Tableau - View Data Issue

    I was using the view data option and when I clicked on underlying, I would see what I wanted to. (The underlying raw data that the summary is referring to). But now it shows the entire worksheet, even if I "keep only" the record I am interested in and then view data If I change that 596 value to 2, then it will just show the first 2 rows, not the rows containing the 2 jobkeys from summary. It's confusing because this was working the way I expected it to like 10 minutes ago, I'm not even sure what I could have changed. Thanks!

  • Issue#669414: Tableau - Data Join - Returning Wrong Data

    I am dealing with tables from the same server. At first, I was blending them, but a popup message recommended to join instead. So that's what I am doing now as you can see below. As far as I am concerned, all the connections are 1:1, in some occasions I had to have 3 join clauses between 2 tables to make the connections unique. However, as you can see on the data table below all the numbers are the same for all the metrics. Something is clearly wrong. What am I missing? 

  • Issue#675876: Tableau - Calculation Issue: Joining Two Data Sets for Calcs

    Hi all -- Can someone please help me with this issue I've been having? I'm currently trying to join two different data sets together, but can't find a good way to do it. Please see below for what my two tables look like: In one table, I have a date and a return In another table, I have a date and expected average return for that date: Ideally, I'm just trying to calculate from the first table, what the Return - Expected Avg Return is for each date, so in theory it would look something like this: Then, from there, I would just do Return - Avg Expected Return, and have an average of that number for each date. I keep running into the issue that I can't mix Aggregate and Non-Aggregate values -- anyone know an easy solution?

  • Issue#813997: Tableau - Creating filters from aggregated data

    I have a data source that has aggregated data that I am unable to figure out how to transform to enable me to create filters. The attached workbook contains three Dimensions: Student Category, Unitid, and Year.The workbook has nine Measures of enrollment data for various demographic groupings (by race/gender). I would like to create worksheets that show enrollment data, but then be able to filter not only on Race and Gender, but also various elements of the Student Category Dimension (such as UG, GR, DS, NDS, Other, Transfer, Continuing, FirstTime). Any thoughts?

  • Issue#898679: Tableau - Creating a Scatter Plot when there is a restriction on source data (re)formatting

    Hi, I have my source data in the following format:    Measure DateInstrumentValue7/1/2016A10.684293327/1/2016B6.7782002987/2/2016A17.883228597/2/2016B0.1750288437/3/2016A24.918378387/3/2016B21.782542957/4/2016A4.5384171067/4/2016B9.7599351247/5/2016A6.2840150037/5/2016B16.478089647/6/2016A16.55047497/6/2016B4.753530046  I want to create a scatter plot with Marks showing a combined X,Y value against each date.I cannot pivot the source data, I believe that somehow I will have to recreate a pivot-like functionality against each row using formulas. Would appreciate any help! (packaged workbook attached)

  • Issue#908462: Tableau - Data quality Issue ?

    Hi all, I don't even know what to call this issue. I created a sample data that i attached with this discussion. When i brought it to  Tableau, its acting weird. I wanted to see the Male, Female emp count. somehow, the each Gender type is getting separated into 2 separate panes. I am attaching the screenshot as well. Please let me know what is the issue here. Thank you,Kalyan Allam

  • Issue#943732: Tableau - Data Blending Help - suspect Dates causing issue

    Hi everyone,  Wanted to see if someone can kindly review my workbook.  I am having trouble Data Blending two different tables to do a Travel Expense budget analysis comparing budget estimates versus Actual results.   In the worksheet tab called 'budget v actual (BLEND)' the values for Values_Actual are way off.  I suspect that this pertains to a blending issue regarding Dates.  In the Budget data source, a date calculation is used whereas the Actual travel expense data sources uses actual dates when the expense occurred. Any help is greatly appreciated as always!! - Dario  Attached is the workbook for your review.

  • Issue#943919: Tableau - Creating totals of dimension data using an SSAS Cube

    I am currently on 9.0 (no control there, thats what they have our server on)My data source is an SSAS Cube, which plays a distinct role in my problem here. What I am trying to create is a few charts that measure how many distinct users have accessed a part of the system each month. I have the data for when each user accesses the system in the cube. However, being a cube I cannot simply count them as I would in a sql database. So far I have found a way to create some charts (currently using a bar and a pie) that will give me size based on the number of distinct users. The problem is, each slice is the actual user and so it has an individual count of 1. I need to add to this, either as a mark or in a tooltip, the total of all of the users that make up that bar. Here is what I have done so far. I am completely open to doing it another way if it gets me what I need, as long as it works with my data source. 1. Create a calculated field (called mine Distinct Count) and then in

  • Issue#976408: Tableau - Accessing Census Data Below State Level

    Hello, I'm a tableau newbie so I'm learning as I go with this wonderful tool. I'm curious if anyone knows how to map Census data below the state level on Tableau. I'm also trying to figure out how to access this data into CSV or Excel format (to manipulate sans mapping) and also Load data into Tableau WITH corresponding geo shape file (correct year, region)

  • Issue#981647: Tableau - In Tableau 9.3 when data blended...Report behaviour issue

    Hi,I'm blending two sources on a key which is fine and while adding fields from secondary source on to rows it worked fine until i added 2 fields..but after 3 field onto row...I see something weird behavior.. It is causing the first two fields in the rows to merge automatically separated by a comma. Not sure why it is happening. If i remove any one of the field from the rows then again the first two fields in the rows shelf which were merged are splitting again back to normal. Not sure why is that. Please let me know your thoughts/suggestions. Thank you.

  • Issue#1011257: Tableau - Has anybody created a live data connection b/w Tableau Dashboard and a Sharepoint Excel?

    My goal is to create a live data connection between a Tableau dashboard and an excel file on Sharepoint (i.e making edits to excel file with update the dashboard automatically). I have read just about every blog on ways to connect through Access, UNC link, etc. and no luck. I am hoping this isn't a server/permission issue with SharePoint. Below are a couple screenshot is of our dashboard when I try publishing it to the server after clicking the checkbox for “Include External Files”, and the second screenshot is of the window with the “Include External Files” checkbox.Thanks!

  • Issue#1145153: Tableau - Underlying data issue

    Hi,I'm showing a data in a Tableau dashboard through a calculated field and it is as expected. I can change the format like in $K, millions and it is changing accordingly.But when I try to export the underlying data then the data mismatches and the reason I guess it is rounding off the values and showing it in millions. Any idea on this? Regards,Ram

  • Issue#17: Tableau - Polygon Creating Rounding Errors

    I am trying to create custom polygons over a background image, but I am finding that Tableau is rounding to the nearest whole number. All of my point locations in Excel have two decimal places, but the points in Tableau all end in ".00". I've formatted my X and Y in Tableau to make sure it shows 2 decimal places, but I'm not sure why it keeps rounding to the nearest integer. Help!

  • 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#29: Tableau - Inconsistent Data

    I have a worksheet setup using two tables left-joined from a database.  If I look at the total number of users using this worksheet, the number of users is over 60 less than is actually in the database.  I have included a screenshot of the results of the joined worksheet as well as one that only uses the one table and gives the proper, higher number.  Can anyone tell me why the join would butcher this number?  Does anyone know how to fix this?