Hi,

I am re-posting this question as a last attempt to get the 'real' answer as
to the best course of action to take.
If anyone can offer any suggestions it would be much appreciated.

Hi all,

A question about linking cubes from different databases on the same server.

I understand that virtual cubes can be created based on the current cube,
and that linked cubes allows linking cubes from different servers, but my
question is, can i link cubes on the same server from different databases?

MS suggest not using linked cubes on the same server (publisher /
subscriber), so is there a way that this can be done?

Many thanks
Immy