This content has been marked as final. Show 1 reply
From a management perspective I would do something similar to the following:
- For Organization A, create a folder with permissions for just that group.
- For Organization B, create a folder with permissions for just that group.
- For workbooks/sheets involving both, use the Default folder. Organization A will see only their folder and the Default folder; vice-versa for Organization B.
- Publish your data source using data source filters for Organization A to the folder for Organization A. This will allow them to see just their data and also to create (with proper licensing) their own workbooks/sheets. I do this by creating a workbook that has nothing in it other than the Data Source and save it to my Data Sources folder in the Tableau Repository. The workbook itself is not published; just the Data Source! The data source workbook is appropriately named as such so there's a distinction between what's a Data Source and what's an actual workbook. Filter Data from Your Data Source - Tableau
- Publish your data source using data source filters for Organization B to the folder for Organization B. This will allow them to see just their data and also to create (with proper licensing) their own workbooks/sheets.
- Where you have a data source that is common between the two, perhaps think about setting up a Test folder for and publish the data source that involves both to that folder only. Develop out the workbook/sheets and then slide it over to the Default folder on completion.
- The real key here is to set up separate Data Sources for each Organization and separately for your own use where there's a need for you to use data for both organizations. You're only publishing the Data Source (if need be with an Extract that updates via scheduled refreshes via Tableau Bridge on a dedicated computer with Admin rights with Tableau Bridge running in either Service Mode (machine is always on) or Application Mode (Bridge will update upon powering machine on)).
- After that point, the development of an actual workbook (at least from my workflow process) is to go to Tableau Online, click the button Create New Workbook, you'll be prompted to connect to a Data Source, connect to the visible/available data source you want to use and then create a workbook. I initially create a workbook with nothing in it other than perhaps a dimension or a measure. Save it. Download it to my local machine. Then do all of my development/changes. Then publish back into the appropriate folder online. Maintenance is significantly reduced at that point. The organizations that need to create their own should be doing the same; either creating solely online with the Data Source available to them and/or downloading a newly created workbook to their local machine, making changes and then publishing back up into Online. Caveat: ensuring organizations have maybe one point of contact for publishing their own content otherwise workbooks could potentially be overwritten by two different personnel working on the same workbook...!
- Insofar as adding an additional field to the database so that it reflects properly in the data source, that's where the maintenance portion of a Data Source comes in, especially if there's an Extract involved. Tableau has a great resource on how to keep data fresh using an Extract here: Best Practices for Published Data Sources - Tableau
- That should help reduce your efforts with how things are being handled now...
Hope that helps...thx, Don