Filter is an effective way to control the amount of data needed for analysis. We have mentioned in our first blog that we had faced another issue which was with the date filter update in Tableau reports. This is a familiar topic in tableau community.
The normal flow of working should be that filters should have been updated automatically keeping in track of the most newly retrieved data. However, we observed that the dashboard was not keeping in sync with the latest data. We worked around this problem and came up with below mentioned solution to automate and fix this issue in its entirety.
Filters/parameters were not updated on regular basis according to latest data. We created a Power shell script which updated the filters/parameters to reflect the new data that was loaded into the Dashboard.
- PowerShell script downloads the dashboard from the server, unpacks it. Edits the xml file (.twb) to search and replace the date value with the latest date captured from Database.
- Selection criteria parameters like date amounts get refreshed to reflect the latest data loaded in Tableau. Will give real time data on the reports.
We would like to discuss another small topic with you on how we handled database locking issue.
Alert Mails for Database locking issue
If a business user is facing issue with slowness in dashboard generation on Tableau platform, the technical team will receive an email where the problem program lies. It will include the exact program which is part of number of programs which is running simultaneously to run one dashboard.
System has been configured to send out a mail to the entire Technical Development/Technical Support team regarding long running queries. This mail will contain details like the host name, Program and the actual query.
The advantage of this mail is that the work is transparent, Technical developers can respond immediately to long running queries that are blocking resources, and if needed the DBA can kill sessions with long running queries to free system resources.
This completes our blog on Tableau reporting platform based on the work we did for some of our clients. Hang on we are not yet finished, next we are going to share our experiences and the issues that came our way on the Data Integration part for few of our large clients. Stay glued for some really cool solutions coming your way.