Tableau Data Blend Performance + Level of Detail

0 votes

I have two blended sources where the source A has 500,000 rows and source B has 20,000. The problem is that when I use source A as the primary source, any computation in the dashboard takes far too long to be useful. When I use B as my primary source, performance is much improved.

The level of detail I need is in source A. When source B is primary I am left with the dreadful asterisk where there is a one-to-many relationship. For example, this is what I get:

Source A primary:

Event(from source B)  Occurred_On(from source A)
    ABC                      1/1/2000
    ABC                      5/10/2000
    XYZ                      9/9/2002
    XYZ                      4/5/2002

Source B primary:

Event(from source B)  Occurred_On(from source A)
    ABC                            *
    XYZ                            *

Data must be blended-- source A is an Oracle database and source B is a text file so a join is out of the question.

Is there any workaround?

Aug 24, 2018 in Tableau by Naruto
• 710 points
61 views

1 answer to this question.

0 votes

If you are able to upgrade to version 10, you would be able to take advantage of joining two different data sources. If not, you can try importing the data from the text file into your Oracle database. Or you can follow these steps:

--> Cross database joins [a link] (http://www.tableau.com/about/blog/2016/7/integrate-your-data-cross-database-joins-56724)

--> Create a lookup table of the text file and apply a join a link

--> To improve the performance, create a data extract file of the combined dataset which will be the primary data source for the report [a link] (http://onlinehelp.tableau.com/current/pro/desktop/en-us/help.htm#extracting_data.html)

Also just 500K record should not cause the performance drag but it will be a good idea to recheck the server configuration and see if there are any bottlenecks present there.

answered Aug 24, 2018 by AwesomeSauce
• 860 points

Related Questions In Tableau

0 votes
1 answer
+2 votes
1 answer
0 votes
1 answer

How to use tableau to searh for text within entire data

You can use a pivot table in ...READ MORE

answered Apr 4, 2018 in Tableau by xyz
• 1,550 points
67 views
0 votes
0 answers

How can I sort date field in presence of another date field in Tableau?

Goal: Sort the new ship date in ...READ MORE

Apr 10, 2018 in Tableau by ghost
• 1,790 points
161 views
+1 vote
2 answers

How to join tables based on “Calculated Fields” in Tableau?

You absolutely can join to a calculated ...READ MORE

answered May 29 in Tableau by anonymous
1,685 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
2,253 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
103 views
0 votes
1 answer

Want to hide the Bar for Grand Total in the bar chart in Tableau

Tableau treats the whole visualization uniformly.  If you ...READ MORE

answered Aug 10, 2018 in Tableau by AwesomeSauce
• 860 points
690 views
0 votes
1 answer

How to Split a Measure in Tableau?

Have you tried using an IF statement: IF ...READ MORE

answered Aug 14, 2018 in Tableau by AwesomeSauce
• 860 points
138 views