Hello,
I would like to be able to use some informations that are kept in the XML file to generate automatically a documentation of a workbook, but for every workbook that is published in the server.
I think I can use some tables from the PostgreSQL database of the Tableau Server repository, https://tableau.github.io/tableau-data-dictionary/2022.3/data_dictionary.htm, but I am lost there.
I would like to retrieve from the PostgreSQL database, for every published view, of every workbook, a list of:
- data sources used, with their URL and the URL of the flux that creates them
- list of fields (calculated or from the sources) used as filters (and the selected values)
- List of fields that are used in rows, columns, etc
- If it is a calculated field, get the formula. If it is a field from a source, get the description
- List of parameters, groups or sets used
- List of actions
Can it be done?
Thank you very much for any contribution.
I use ExportCalculatedFields (you can google it) that does a lot of this automatically if you upload a workbook file. It extracts all calculated fields with their formulas and shows which fields and worksheets are actually in use. Could save you a ton of manual XML digging if you just need the field inventory.
