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.