We’ve all been there: parsing the workbook, changing extracts or copying formulas only to be stuck with the dreaded ‘[Calculation_3400904132723583]’ (or it’s many numeric derivations).
Well, stress no more because of the Tableau M.M.A (Monitor/Maintain/Alert), we’re able to switch that out and replace with the actual name of the calculation. Now, when you re-open the workbook, these won’t error out.
Here’s what we do, remember a while back, I talked about file alerting and triggers? No, well, go read it here, I’ll wait.
Essentially, once someone drops a file (any file: twb, twbx, tds, or tdsx) in the desired directory, the code will immediately parse and spit out the following:
If you’re like us and have mission critical workbooks, then backing up and auditing these is always a good idea. Storing them into a database is also easy and, what’s more, this ties into the performance metrics I’ve mentioned here and here.
Here’s the code for the calculation update.