Hi,
I have two Data Sources from two different servers.. Using that i have
created two cubes namely HostCube and Applications Cube..Now i need to
link the two cubes based on host name.. Host name is present in Host
cube and Site name is present in Application cube.. I need to link
these both and get the keywords, referal page, number of applications
running and number of visits.

Am not able to link two cubes and get the result.. I tried using
Virtual Cubes, but it just takes dimensions from both the cubes and
gives the result.. Can anyone help me out in this please.
Thanks in advance..

You need to create a shared dimension representing both host and site name in
both cubes, then you could link those cubes through virtual cube.

"Shruthi" wrote:

Hi Yongli,

Thanks alot for your reply..
Ya I have used shared dimensions and used virtual cube... But here in
virtual am not able to compare... It just displays the datas of two
Cubes..
I need to take Host name from ID from Host cube and compare with Site
ID in Application Cube and should Display Site Type, Keywords and
Referer which is present in Application cube.. Can you help in this...
Can we compare dimensions like this.. Am very new to this and i dont
know properly..Am totally lost here... Any help would be appreciated...
Thanks once again



yongli wrote:

Hi Shruthi,

What is the relationship between Host and Site? which version of AS are you
using?

"Shruthi" wrote:

Hi Yongli,

Am using AS2000.. Hostname in Host is same as SiteName in Site..

yongli wrote: