Skip to Content
0
Former Member
Jul 30, 2012 at 10:30 AM

MultiProvider Issue

34 Views

Hi,

I have 4 info cubes under my multiprovider. I have designed a report based on that multiprovider. I have taken two char (A,B) and one KF (X) from one infocube, and another 2 char (C,D) and 1 KF (Y) from another infocube to design a query. when I open the analyzer output displays as follows.

A B C D X Y

1 1 # # 12 #

2 2 # # 13 # .

3 1 # # 11 #

# # j1 k1 # 1.5

# # g r # 2.5

# # c v # 3.5

Expected result is:

A B C D X Y

1 1 j1 k1 12 1.5

2 2 g r 13 2.5 .

3 1 c v 11 3.5

How to achieve the above result. Thanks for your help.