Problems with Multiprovider

Hi Folks,

Items: Cube1, Cube2, Multiprovider

I've 2 cubes and then a Multiprovider on top on these cubes. The common Char is "Doc#". Based on this doc# I'm pulling 15 fields from Cube1 and 2 fields from Cube2.

But when I execute a Query on top of this Multiprovider, its not showing details from Cube2. Please suggest what could be possible workaround so that I can see these details.

The fields I need from Cube2 are Event Name(CHAR) and Date (DATS).

Do I ve to do anything at Report level to see the details from other Cube.

Reddy.