One more question: If I have completely same local cubes at each site, is it possible, to join those local cubes into one "supercube" ? If yes, how ?

SpringTownDBA (10/15/2011)

---

Best approach is to combine them into a sql dw first, then load from there into the cube. If you can't do that, then linked severs combined...

No replies ?

Forgot to attach diagram...