I have two cubes of identitical structure, but on two different data
sources. Is it possible to create a virtual cube to combine them,
having the structure of the underneath cube?

yes you can
but you'll don't have any shared dimensions
and you'll have a lot of MDX formula to apply to "merge" these cubes.
its a long and complex solution.

I recommand to load your 2 tables into 1 and use 1 cube only.
maybe you can use views and linked servers to do this:
select * from table1
union all select * from linkedserver.database.dbo.table2

partitions can also be used.
If AS is installed on 2 servers, you can partition a cube and setup the
second partition to use the second AS server. (Enterprise edition required;
see the BOL for more info)

"Frank" <clarissa_wu (AT) kindermorgan (DOT) com> wrote