Since cube data sources already have aggregated data they're somewhat different to work with. My apologies if you've seen this before but we actually have a good writeup in our Help when using these:
Workbooks using cube data source can be published to Tableau Server, but do not support pass-through connections. This means that you cannot make a connection from Tableau Server using such a data source. It also means you cannot create a workbook using the data source in Tableau Server. For details, see Cube Data Sources in the Tableau Server help.
Publishing a cube data source to Tableau Server gives you the ability to store the data source on the server. However, to use the data source, you must download the data source to Tableau Desktop and use it locally.
Workbooks that use cube data source cannot be published to Tableau Online.
Thank you for the reply.
I will go though this help in detail first.
HI Mark McGhee
From this statement,
Does this mean NONE of view(workbook) on server can connect to this published data source?
Publishing a cube data source to Tableau Server gives you the ability to store the data source on the server. However, to use the data source, you must download the data source to Tableau Desktop and use it locally. To download a published data source you need:
- The Download/Web Save As permission for the data source. For more information, see Set Permissions on Individual Content Resources.
- Correct drivers installed and ports opened on computer running Tableau Desktop.
1 of 1 people found this helpful
In my previous employment we published cube sources to the server. It is true you can't extract them are really blend with any other data sources. However most of the dashboard we had ran off of a server data source that was an analysis services cube.
I believe we needed to grant access to the service account that was running Tableau to have access to our cube data.
Hope this helps you out.
Yes, that's correct. For relational based published data sources you could have say 20 workbooks that tie back to just one published data sources. That's because the "data server" component can interact with these. When the data source is "cube based" data server can't work with these in the same way. But folks can download a "local copy" of this data source, construct their workbook and embed their credentials and then publish it back to Tableau Server. So others who then open that workbook it should populate for them.
Thank you for the reply.
Thank you for the confirmations.
Seems like there is no reasonable reason to publish the cube data source for me now.
Live connection seems enough.