We've been looking at schema switching to minimise downtime for users (and it's going reasonably well in testing).
We have a 3-stage load process for the tables and cubes, as follows:-
1) Load the staging tables
2) Load the Dim/Fact tables
3) Update cubes
We've got parts 1 and 2 working reasonably well (downtime for anyone accessing the tables is down to about a minute) but the sticking point is the cubes.
What we want to do is update a set of cubes in the background and then switch them with the visible cubes so the downtime for those comes down as well.
We've been following this guide to update tables in the background and then make them visible to the users.
We want to do something similar with the cubes so we can bring them up to date in the background and then swap them with the cubes from, for example, yesterday.
Is what we want to do possible?