I have two cubes, Cube A (Fact table A) and cube B (Fact table B). Cube A
calling cube B using LookupCube function. Untill it is cube level reports
which are working correctly, but when I use Drillthrough query for a report
on cube A, I get blank result. The reason is I try to search Fact Table B
data on Fact Table A. Is there any way I can resolve this problem? The Final
alternative is to merge both Cube (Fact Tables) into one.

Thanks,
Sam

How about combining the 2 cubes in a virtual cube (assuming that these
are AS 2000 cubes)?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thanks Deepak.
I have decided to merge Cube B into Cube A. The reason behind this is Cube A
is quite complex and already developed cube. Please let me know if you know
any solution with the previously posted scenario.
Thanks,
Sam

"Deepak Puri" wrote: