2 Replies Latest reply on Dec 17, 2016 7:49 PM by Dmitry Chirkov

    Tableau 10 - Use new xDB Joins with Existing (Blended) Dashboard

    Cheri Beckman

      My main reason to upgrade to Tableau 10 is to use the new Cross-Database Join feature.  I have quite a number of dashboards where I am using blending between data sources that wouldn't join in version 9. 

       

      Problem is, I can't figure out a way to convert those rather than having to re-create each worksheet from scratch!  I created the xDB Join and thought I could simply Replace the Data Source, but since the original worksheet uses multiple data sources, that doesn't work.  Is there something I'm missing?  Or is this only a feature for creating new worksheets?

       

      I would HATE to have to re-create everything I've done over the past year!!!!  Can't attach a workbook because it's confidential information.

       

      Thanks,

      Cheri

        • 1. Re: Tableau 10 - Use new xDB Joins with Existing (Blended) Dashboard
          Dan Huff

          Cheri--

           

          Replace datasource, as you seemed to have discovered, really only has an affinity with the single datasource you are trying replace be it a primary or secondary. There isn't a way in the product right now for us to guess or let a user define that a federated connection (xDB join) is an equivalence of a number of blended data sources.

           

          I may be over simplifying this but you could potentially take a more targeted approach to your existing workbooks, one that I took with my own internal workbooks here at Tableau. I went through my workbooks and found the cases where I had worksheets or dashboards that 1) I deemed too slow and 2) used blending. From there, I started experimenting with whether or not switch to a xDB join for my blends helped the performance. If it did, I put in the work to rebuild it. If not, I let it be.

           

          Functionally, there are obviously a lot of differences between blending and xDB joins underneath the UI, but so long as it gets the results you need to see and within an acceptable amount of time, I wouldn't suggest you worry about creating all your work again. Even as you move forward, I would be sure to keep utilizing both scenarios. Sometimes xDB will be faster than blending and other times the reverse will hold.

           

          I hope this helps a bit.

           

          Dan

          1 of 1 people found this helpful
          • 2. Re: Tableau 10 - Use new xDB Joins with Existing (Blended) Dashboard
            Dmitry Chirkov

            Just to be clear - are you replacing blending with xDB?

            If yes - have you tried "replace references" for individual fields?

             

            If you have sheets with blended datasources I'd just join secondary by adding it as new connection to primary. Yes, you'd have to recreate calculations from that secondary datasource in your xDB. Unfortunately, there's no better way at the moment.