Hi,

I am really in trouble, I have 2 separate Olap DB on same server.
We have one common Requirement to build the common view from the
different cube and they are in Different DB.

Is there any way to build the Virtual cube from Different Olap DB
on same server ? I tried many different ways but I couldn't find any
solutions.


Thanks for help
Kris Patel.

Hi Kris,

what OLAP DBs are you using?

"Kris" <salotk (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:8a537e5f.0309261104.7caa91c7 (AT) posting (DOT) google.com...

Hi Joerg,

Thanks for your reply.
Sorry I wasn't more specific. Anyway I am using MS Analysis Server
and created DB1 and DB2 on same Olap Server (Microsoft AS).

Thanks for help!

Thanks.
Kris Patel


"Joerg Narr" <n_o_s_p_a_m_joerg_narr (AT) hotmail (DOT) com> wrote

Hi Kris,

look for "linked" cubes (right-click the cube folder on the target db and
choose a cube on the source db).

I hope this helps.

J.
"Kris" <salotk (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:8a537e5f.0309292122.ec8ffe1 (AT) posting (DOT) google.com...

Oddly, it's not possible to join these cubes together using linked cube or
otherwise. Whereas if they were on different servers it would be possible.

tom @ the domain below
www.tomchester.net


"Kris" <salotk (AT) hotmail (DOT) com> wrote