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.
Dimension 1 - A1, A2, A3, A4, A5
Key Figures - K1, K2
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?