Does anyone have an experience with auditing workbooks/metadata layers of workbooks vs. the actual data source?
I'm looking to see workbooks that have calculations/sets in the metadata layer of the workbook that are not located in the published data source.
I want to be able to regularly audit all the workbooks that are connected to a data source and verify calculations/sets. If there is a new calculation in a workbook, I want to audit it and add it to the data set if needed.
Often times business users will not request a new field be added if they know that they can always create the calculated field on the fly. I don't want this to be the case however so is there a way I can easily see what is proprietary to the workbook vs the data source?