Hi, we have many different projects and dashboards managed by different squads of developers, etc. One thing we’d like to do is allow for non-admins ad-hoc clearing of data cache for Cubes and Hierarchies after the database is updated. Currently, the we login to the server and flush the app pools, a very crude method. Ideally, there are two scenarios I’d like advise on…1) building a Dundas report or dashboard that I can allow access to that clears the cache using a button or something, and 2) a script that calls the Dundas API at the end of a data load to flush cache.
On top of that, ideally, it would be even better if the solution could isolate the cubes and hierarchies that need their cache flushed instead of doing the entire application disrupting all active users for a moment. I confess my scripting skills are not great so a real life example would be awesome.