Issue#41: Tableau - How does Extract Filters and Data source filters vary the size of the Tableau Extract?

  • In Tableau 8.2 Data Source filters and Extract Filters used to work in the same manner.

    However in Tableau 9.0.4 both filters works differently.

    Extract Filter:

    As the name implies extract filters are used to filter out the data while creating the extract.

    Example: Let’s say we have database with the data for different countries as shown below

    1. USA –                    5000 rows
    2. Canada –             2000 rows
    3. India                      10000 rows
    4. Australia              1500 rows

    If we apply the Extract filters to bring the data only for USA (Country=USA), Tableau creates the Extract (.tde) just for the Country USA and ignore the data for all other countries.

    Size of the Extract is always proportionate the Extract filters.

    #of rows in the extract: 5000 rows for country USA  Size of the extract is smaller

    Data Source Filters:

    In Tableau 9.0.4 applying Data source filters won’t change to the volume data and size of the extract. Instead data source filters applies the filters to the background query when we use any of the dimensions or measures in the visualizations.

    Example:

    If we apply the Data Source filters to bring the data only for USA (Country=USA), Tableau creates the Extract (.tde) with the full volume of the data for all countries (not only for USA) and there won’t be any relationship between the data source filters and the size of the extract.

    #of rows in the extract: 18,500 (for all countries) size of the extract is larger compared to the Extract filters

     

    However there won’t be any change the way we use the dimensions and measures using both the extracts in the Visualization. Both should work as expected and will show the data only for USA.

    Conclusion:

    Extract Filters: Pre condition filters before Extract creation.

    Data Source Filters: Post Condition filters while displaying the data in the Visualizations (applies to the query while pulling the data from extract) and won’t apply during the extract creation.

    Note:

    If you apply Extract filters and Data source filters together, Data source filters overwrite the extract filters and size of the extract will always be larger.

     

    It would be great if you mark this post as helpful or like the post, if the content makes sense and helpful.

     

    --Venu

    0 Answers

    Sorry, your answer is too short !

  • Issue#91546: Tableau - Help with setting filters on my data source.

    There are accounts in my data source that has a TAC value of “60-373,” or “45-011,” and some have both.  How do I set filters to exclude accounts with only a “60-373” value?  I want to only display account that contain a “45-011” value or both.  Thanks.

  • Issue#121355: Tableau - Data Source Filters

    Hi, I have 2 user  groups based on a "Region" field in Tableau. Now I want to set 2 data source filters based on this so that only specific users get to see that region data Group1 ABC Group2 ADE  So I want to use both these groups to create the DS filter so that they have access to specific data. How can this be achieved

  • Issue#477273: Tableau - Question follow up - Cross Data Source Filters.

    At the User Group meeting on Weds 13th April we had a question that I said I'd follow up on - it was about Cross Data Source Filters. I confirmed it is possible to do this in Tableau already and these links will help to explain how:          http://kb.tableau.com/articles/knowledgebase/filter-data-sources          https://community.tableau.com/thread/152155 One of my colleagues also said this:          The answer isn’t quite yes or no, it depends on the scenario. You can filter across both data sources if you’ve linked on the common field, but as soon as you remove the blend key than it doesn’t work. I also learned that this is one of the features that is being improved in Tableau 10 – see here:          https://www.tableau.com/about/blog/2016/4/10-reasons-join-tableau-1

  • Issue#602005: Tableau - Action filters on a source sheet display full data on target sheet instead of the filtered

    Hi, I have created few action filters on my source sheets of a dashboard which should ideally show the data on the target sheet for only the values I am clicking on source sheet. But when I click on a particular value of source sheet table, it shows full data from the extract I am using for the tableau dashboard and not the selected data. I am not sure it is a bug or I am missing something here. I have attached a sample tableau workbook. For example when I click on value most bottom-left value '2'  in Pro-active monitoring tool dashboard, it should direct me to View data dashboard with 2 rows. But instead it is showing me all the rows from the extract I am using for this tableau workbook. To add more info, I can see that the target sheet is getting a filter after clicking on source sheet which includes 4 dimensions in it. But on measure is not included in the filter and may be that's why it is showing full data and not the selected data. Any kind of help is highly a

  • Issue#919658: Tableau - Refresh the data source extract connections in tableau server using SSIS

    Hi, I don't have any knowledge using tabcmd command for SSIS. I have searched the forums and I didn't know which one is useful. Can anyone provide me the basic steps on how to refresh the extracts with SSIS or point me to the right resources. I appreciate your help.  Thank you.

  • Issue#982324: Tableau - Tableau Data source extract refreshes without error!

    I have a SQL query that's published onto the server.Live connection -> Extract -> Publish to server with embed credentials -> Use the TS data source in the workbook, those are the steps i followed. Now due to a sql server upgrade, I have been kicked out of the database for a while (i.e. I am not able to log in to the database with my credentials like before) and hence would expect my extract to not refresh and throw an error/alert.But it works just fine! To my understanding, TS was just automating this process for me. It would talk to my database server as 'me' and get the data.When I myself don't have access how is TS talking to it? :/ So,is it simply refreshing an old extract without adding new data? orit doesn't care about user credentials anymore as the Server address and tables still exist in the database server? You might suggest to check if today's data is updated! but this is a contracts database. So i won't have a daily record for this, at least no

  • Issue#1193975: Tableau - How do I revert from an extract to the original data source?

    I created a workbook with several visualizations, and performance was not great, so I extracted data from the original data source. I used the options to aggregate data for visible dimensions and hide all unused fields. Now I need to make a change to one of the visualizations using a field that was not used previously and was hidden when I created the extract. I tried right-clicking on the extract, and unchecking Use Extract menu item. When I do this, it appears to revert back to the original data source it shows me all the fields. However, all of the fields that were hidden are now grayed out and I can't use them. I tried removing the extract, but that leaves me in the same position. Is there a way to revert back the original data source, adding the new field I need to the viz, and re-creating the extract short of rebuilding my whole viz? Thanks,Bryan Sparks

  • Issue#7851: Tableau - Changing multiple filters before loading data

    Hi All, Currently, I have a few quick filters on my dashboard on Tableau Server. Every time I change a filter, Tableau Server will begin to load and refresh my charts/tables. Is it possible to change multiple filters at once on Tableau Server before it starts refreshing the data on my charts/tables?

  • Issue#12234: Tableau - How to Connect workbook with data extract ?

    Hello Team,I have a data source called A and developed some workbooks named W1 and W2, I have created a data extract for A and Published it to Server, So If I want connect W1 and W2 to the published extract A, How to connect it in Tableau Server. Thanks In Advance Sudha

  • Issue#14475: Tableau - Extract - Can You Filter Out Data?

    Hi All, I am extracting data from salesforce into tableau and am joining the contact object on the lead object with an inner join on the email. The issue I'm encountering is that Tableau is joining null emails to null emails and infinitely expanding my data set size. Is there a way to filter out data to prevent extracting irrelevant data?  Thanks!

  • Issue#140140: Tableau - Data extract keeps updating everytime I return to workbook

    Hello there! I wonder if anyone can help me with this. I have a workbook locally that I open using Tableau Desktop. It is connected to a SQL Server, and the Data Connection is set as to "Extract". Everytime I go to the "Datasources" tab and return to the workbook, Tableau runs an update on the extract and I have to keep waiting for a job that have already been done. It should only update when I click the update button, or am I wrong? How can I avoid this? I hope I have made myself clear, and thank you for your help. Regards, Mateus.

  • Issue#217807: Tableau - New Union Feature in Beta - Appending Files Via Union to Existing Large Data Extract

    Morning, Probably user error here; however figured I would ask. I am using the beta for 9.3 in order to use "union" functionality. In doing so I have created a very large data set that has truly opened up worlds of better investigation for various challenges/questions around the office. Today I tried appending that file by adding a few more files to the large data extract via the 'Union' feature, which went fine; however when moving to a sheet Tableau went through the process of reloading the entire data set rather than just appending the two new files to the existing data set. Any users out there know if this is to be expected(?) or if there is a button/method that I am missing. "New Union" seemed to perform a 'join' not a 'union', but again I may have done that incorrectly. Thanks in advance to the knowledgeable person who answers the quandary,Steve

  • Issue#239104: Tableau - Action Filters: Multiple source sheets for one target sheet

    Hi, On one dashboard, I need to incorporate an Apply button, a clear all from filter button, and a default values filter button.  The Apply button is a worksheet used as the action filter for the dashboard's worksheet view.  I am able to add an Apply button and clear all button by setting the Reset button (whose filters are set to All) as the source sheet to the Apply button, but when I add the second button filter (Default Values) as a source sheet to target sheet Apply (exact same process followed as clear all), I lose functionality of the buttons.   So basically it seems Tableau cannot handle two action filters on the same target sheet (Apply button worksheet for me), and this sheet is used to filter the dashboard. Any ideas? Thanks, Anthony

  • Issue#377118: Tableau - tabcmd - The server is not licensed to connect to 'Tableau Data Extract

    Good day Tableau Community,   I'm new to Tableau 'tabcmd' and I would really appreciate support here.   I have a data source on Tableau Server named "FilterList". The connection type is Text File and it connects to a CSV file as an Extract. This CSV file sits on the same server as the Tableau Server and we used UNC path.   I want to refresh this data source each time the CSV file is updated using 'tabcmd' below:        "C:\Program Files\Tableau\Tableau Server\9.2\bin\tabcmd" refreshextracts --datasource FilterList  --no-certcheck --synchronous   However, I am gated with issue below.     ===== Continuing previous session   =====     Server:   http://111.11.11.11//   =====     Username: RohnJose   ===== Scheduling extracts for datasource 'default/FilterList' to be refreshed now...   ===== com.tableausoftwa

  • Issue#409697: Tableau - Cannot Extract Salesforce Data

    Hi, I am having an issue connecting to Salesforce data.  Whenever I try I get an error message: "Tableau failed to create an extract.  This data source required an extract before you can start analysis. Click edit data source, and then click the sheet tab to create the required extract.Click continue to proceed without creating the required extract."  However, my colleague does not run into the same problem - even though we are using the exact same login details, and the same version of Tableau (9.2). Has anyone come across this problem before and figured out how to fix it?   Thanks, Adam

  • 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#483303: Tableau - Calculated field causing issue while publishing - all filters greyed out.

    I have a calculated field as a filter in my reports. It is working fine in the desktop preview. But when I publish my dashboard online, all my filters are greyed out (look at the picture). Is there any wrong that I am doing. Appreciated your help here. 

  • Issue#593851: Tableau - Issue with the extract file if i add a new column into the extract to append

    Hello Team, I have the existing extracts which I used to build the report. its around 2.5 GB of extract. abnd I have around 30 reports created using this extracts. now the requirement is to add one more new column to the extract. but when I add the new column to append the existing extract the new column not displaying in the column list. please let me know if anybody come across this scenario and how to resolve this. Regards,Raghu

  • Issue#629755: Tableau - Action filters: Use the first filter value of the Source sheet for the Target sheet

    Hi, I have a dashboard tab that has a filter where a user can select multiple values, and I need to use the first value in that filter in another dashboard tab's filter.  As far as I can see with Action Filters, all filter values of the Source sheet get used in the filter for the Target sheet. Any ideas? Thanks,Anthony

  • Issue#659597: Tableau - Call SP to extract data from Sybase ASE

    Hello, I am new for both Sybase as well as Tableau. I was able to connect to the Sybase database and select tables but it doesn't display the stored procedures. Can you please help me with calling Sybase stored procedures from Tableau?  Thanks in advance!

  • Issue#670167: Tableau - Extract Data from Packaged Workbook using Desktop

    Hi I am trying to extract data from a Packaged Workbook using Tableau Desktop. Normally when I extract data from Desktop (not using a packaged workbook) I choose where I want to extract the data to on my computer. When trying to do this using a packaged workbook it runs the extraction but I cannot choose where I want the file to go and I have no idea where it has put it on my computer! Does anyone know where it extracts the file to? Many thanks Kev

  • Issue#714229: Tableau - How to create a date filter that filters data by year, month, date ?

    Hi all,I have a quick question about date filter.I would like to create a date filter that will allow users to change visualizations by year, quarter, month, week, day, etc.So if user select "date" option from this date filter, the visualization will only show date wise data.I worked on this by using this link Changing the Date Level Dynamically | Tableau Software  but here the date  is taking as 1st of every month but i want to view the all the date of each monthHow do I create this filter? please help me out  Thanks in Advance.

  • Issue#755326: Tableau - How to extract excel source filename in Tableau

    Hi All, I have monthly basis data in excel file.In the excel source file, there is no column as Date.The excel source filename will be saved as "Data_mmddyyyy" format (eg: Data1_06012016, Data2_06022016, and so on).Like this every day a source file will be maintained.Since there is no Date column in any source file, therefore is there any way to derive date from the excel source filename? Kindly assist. Thank You.

  • Issue#786092: Tableau - Checking successful completion of data extract on Tableau Server

    Hello all,I have a data extract on Tableau Server that runs once a month.  I’m trying to create a separate tabcmd work-around program that checks if the data extract completed successfully or the last successful completion of the data extract. I want to take conditional action based on this result. (e.g. If data extract completed successfully, send report, else send error message. – I know how to send these messages.  I just need to know how to test for the successful completion) Is this even possible in tabcmd?  If so, how do I do it? Thank you for your help!

  • 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#845480: Tableau - can Excel data extract file be changed by user?

    Hi, I was wondering if this is possible:I've got a Tableau report already that connects to an Excel data extract.  Every so often, the data extract needs to be overwritten - a new file is supplied.  Is there an object I can put on the report that the user can drop their Excel file?  The users and myself do not have a common area to put the file. I'd run the report locally because the user can't update the file that resides on my machine.  I'm hoping to publish the report and with the user being able to change or edit the data extract.

  • Issue#945720: Tableau - Data Extract on Tableau Server

    Hi, I have a tableau workbook with 11 data sources and the workbook is published on the Tableau Server to be viewed by users.The tableau workbook is scheduled for data refresh on monthly basis, in case if the refresh fails i have to manually download the workbook from server and initiate the fresh extract for all 11 data sources from scratch. By Scratch i mean if the report has 24 months data plus last month new data also to be added then i have to extract all 25 months data which takes a lot of time.I wanted to know is there any other way of extracting data in which i can only be able to extract latest months data and append it to the last 24 months existing data. Thankyou for help! \\RegardsAbhishek

  • Issue#970707: Tableau - Data vanishing in extract

    I'm working with a very large dashboard and thus cannot share it, but I'll do my best to describe the problem. I am attempting to extract data in order to share this dashboard it is a map that has the data filtered by cancer type. The list of cancers in the filter is about 28 different types when the source is live. When I extract the data 9 of them vanish. I keep checking the extract and all are selected in the extract so I cannot determine why they are disappearing from the filter list. Thoughts?

  • Issue#24: Tableau - Make Server Extract Path Editable

    Some of our tableau users tend to publish extracts to the server while pointing to a local drive where the original data file reside. They later found that the refresh failed and realized that the path to the data set is the culprit. To remedy it, one has to republish a data source and replace data source. It may break the workbook and dashboard. I would propose to make the server extract path editable so that user can change it to a UNC path. This may save a considerable amount of effort from both users and support personnel.