Hi there Stephen van der Werf,
Apologies for the delay here! Hasn't been much action in this group so I wasn't checking it.
Interesting question - as a side note, do you know why your team is moving from databases to cubes? I find we have abandoned our cubes with tools like Tableau around, since it handles microdata so well.
Tableau certainly works fine with Cubes, though! Are you using SQL Server Analysis services to build them? And is access to the cubes shared widely among other analysts in your organization?