Create a tool for IRIS BI to test all the pivots and dashboards if they still work after changes made

Sometimes when we make changes in the data classes, in pivots it can influence on the pivots and dashbords and those stop working. And it is very difficult to find the problem in pivots and dashboards especially if there are a lot of them - e.g. hundreds. Now it can/should be tested manually. It'd be great to have a tool that will go through all the pivots in the namespace and dashboards with filter defaults and execute MDX and SQL queries to understand whether it works or generate an error