Using TimeXtender with Tableau - which endpoint

Hi all,

We recently started developing a new data platform using TimeXtender with Tableau as a visualization tool. We are currently determining how to setup our endpoint in TimeXtender for Tableau as we have several options, each with their pro's and con's. Im wondering what choice others made and if maybe there's something we haven't thought about yet while trying to make this choice.

As we see it now we have three main options:

- Multiple .tds files, one for each fact table. As Tableau requires all tables to have a relation with eachother it is not possible to have a .tds file endpoint with all facts as not all facts relate to all dimensions. Pro's: smaller, efficient sources with good manageable security. Cons: Can become difficult to maintain with lots of .tds which share dimensions, for example when an attribute is added to a dimension this has to be done multiple times. When using multiple .tds sources in a Tableau sheet there's no way to link shared dimensions and thus fltering becomes difficult and unclear to users.

- Single .tds file for all facts and dimensions using a linktable with all possible dimension key combinations from all fact tables. Using a link table we can ovecome the issue where we cannot have all fact tables in one endpoint. Pro's: Single endpoint so easy to maintain. Cons: We expect performance to become an issue when the link table gets too large, unclear for dashboard builders what dimensions can be used with which facts.

- SSAS tabular model, as it is possible with Tableau desktop to connect with a tabular model we also want to look at this option. Pro's: one endpoint so efficient to maintain, makes us more flexible with dashboarding tool because a possible switch to Power BI will be easy as custom measures will already be in DAX. Cons: Not possible to connect via Tableau server, meaning builders will have to download datasource to desktop, build dashboard and republish, not the most efficient way. 

Our own preference with above pro's and cons in mind is using a tabular model, but we do find it a big con that this will not work with Tableau server. However, the cons of the first two options using .tds files seem to have a higher impact as this can become more and more difficult as the data warehouse grows, whereas the con for a tabular model will stay the same regardless of model size. 

We're curious if there are others having made the same decision and if our pro and con list is complete. Looking forward to any input, thanks in advance.

Bart