Joining Cubes

[מיטל]

Hellow!

I need to create report in reporting services that his data was joining
between 2 cubes.
the cubes in One database.

somebody can to help me?

Thanks,
Meital

[Dejan Sarka]

Post by מיטל
I need to create report in reporting services that his data was joining
between 2 cubes.
the cubes in One database.

In Analysis Services, you could create a linked cube from both cubes in
question, and then browse the linked cube. In SQL Server, you could create
linked server to Analysis Services, and then couple of views based on both
cubes, and query the views.