Query: Displaying elements from different cubes using a Multiprovider

Hi Experts,

I am trying to report from 2 cubes joining via a multiprovider. For this case the let's focus on only one dimension as below.

Cube 1

Dimension 1 - A1, A2, A3, A4, A5

Key Figures - K1, K2

Cube 2

Dimension 1 - A1, B1, B2, B3, B4

Key Figures - K1, K3, K4, K5

The only common characteristic and key figure that I have is A1 and K1. Most of the KFs are reported from Cube 2. Whenever i try to query this, I will get A2-A5 showing value 'unassigned'.

It worked fine if the no KF are dragged into the rows/columns. I have also explored the constant selection and this doesn't work.

Is there a method that I can actually report on this apart from using a Infoset?

Thanks,