I'm not sure if this answers your question, but you can use Tableau Server as a "data server", meaning you can configure a data source, edit aliases, add calculated fields, sets, bins, etc. and publish that data source for others to access so they can create workbooks.
If I understand you correctly, if I publish the connection as a data source, users would have to create a workbook every time they wanted to browse the cube? I am not looking to have permanent reports or dashboards, but more of an ad hoc approach (at least for now) where a user can look at the measures important to them, sliced as they want it, and then move on to their other tasks without having their configuration saved (next time they return they have a blank slate again).
Yes, they'd need to create workbooks from the published data source. However, you could publish a blank workbook with a data source setup with all the dimensions/measures needed, and they could access that in order to create their own custom views from that data, but I'm not sure if that is what you are looking to do either. I have no experience working with cubes in Tableau, either, so I'm not sure how that will impact what you're wanting to do.
I have done an implementation of Tableau and SSAS cubes in an organization which has 200+ business users.
As far as my experience Tableau is the best tool to work with Analysis services cubes though you cant use complete features of Tableau with SSAS.
Tableau server got different license levels, you can assign it to users as per your business requirement.
Interactor: Users can edit, create (save as) and dynamically interact with the report/dashboard same like a desktop pro.
Viewer : For users who just need to read the report / print etc
Tableau Server has also got many other flexible security features which you can enforce on user and reports.Please let me know if you have any specific queries.
I think what I need to do is publish a blank workbook/worksheet in a way that the users can pick their own dimensions and measures. For example, I could send out a single URL to all the users that would bring them to a page where they pick the dimensions and measures that they want to see at that particular moment.
Have you done something like this before?
Yes, You can publish a blank workbook or a common template then share the
link with users. They can do the modifications in the worksheets, if you
have granted the "Web edit" role to the user.
Users can Save the modified work book or Save As workbook with another
name. In many cases saving the common workbook after the modifications made
other users confused, So you can disable the "Write/Websave" role and just
enable " Webedit and Download/Web Save As".
On Mon, Oct 7, 2013 at 9:08 PM, Aaron Bates <
That sounds pretty close to what I want to do. However, I must be missing a step. I have only just started working with Tableau. I am creating a blank workbrook in Tableau Desktop that is connected to my SSAS cube (I can see the measures and dimensions in the left pane of Tableau Desktop). However, when I try to publish it to the server, "Publish Workbook" under the Server menu is disabled. It only becomes enabled once I add specific dimensions and measures.
Am I missing a step to publish a blank workbook?
Thank you very much for your help.
You are in right track! we have to use at least 1 dimension or measure
I usually put a current year- month in filter.Appologies, I missed this
On Mon, Oct 7, 2013 at 10:51 PM, Aaron Bates <
This is a great conversation on using Tableau Desktop + Tableau Data server to connect to cubes (adding the phrase multi-dimenional for people searching on that term).
I remember prior to web edit we always had to get crafty using parameters.
Love that with web edit, you can securely allow your organization to explore cubes that are already in place without having to do any ETL.