To open a Tableau workbook with Tableau Reader the data source must be a local file. This file is typically a flat file (Excel or .csv) or if using a relational data source connection, an extract (.tde) of the data source is created to save the data locally. The flat file or extract is saved with the workbook as a packaged workbook (.twbx) and can be opened by Tableau Reader.
Because the MSAS data being used is referencing an external data source (it is not a flat file or an extract) the workbook cannot be opened in Tableau Reader. Currently it is not possible to create an extract when working with cubes like MSAS. To work around this, one option is to use a local cube file (.cub) instead of connecting to a remote cube file on a server.
- Create a local CUB file
- Connect to the local CUB file with Tableau Desktop (see step 1.1 here http://onlinehelp.tableau.com/current/pro/desktop/en-us/help.htm#examples_msas.html)
- Build your workbook and save as a packaged workbook
If connecting to a local cube file, you should be able to save the packaged workbook and open it in Tableau Reader.
I found an open idea to allow Tableau extracts for cube data sources. You can add your vote here: https://community.tableau.com/ideas/2272
Hope this helps!
For the Tableau Reader to read the Tableau file, it should be a packaged workbook (twbx). So below are high level steps
1. Create an extract of the Data source (If the file is huge, ensure to hide the unused Dimensions/fields or put filters when extract the data as this will reduce the extract size)
2. After designing the workbook with all visualizations, save the file as package workbook with .twbx extension
Hi Rekha and Sarah,
Thank you very much for your responses. The strange thing is that it worked in Tableau Reader version 9 just fine and stopped working when version 10 came out. I got in touch with Tableau Support and they said the same thing you told me but when I submitted an evidence that it used to work they got surprised and said they will look into it more closely. Meanwhile I will try your suggestions and see it will work for us. Thank you again for your help.