We have several process-heavy data cubes that we warehouse. This works well in general, except when the warehouse job is running, no data is returned on the dashboards. Is there any way to ensure that the warehouse build(s) don’t knock out the entire dashboard while they are running? It would be nice to set it to show cached/old data until the data is refreshed, but I’ve read a few of the support articles, and can’t figure it out.
I believe incremental warehousing won’t work in this case because we need to incorporate data changes as well as new data.
Long term, I would like make the data more streamlined coming from the source to improve performance, however that is not an option at the moment and I am relying heavily on joining and calculated elements in the cube.