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.
This can be achieved if you have
Ex: From CUBE 1 u r selecting values for AB, and from CUBE 2 u r selecting chars CD
Values in CUBE 2 should be as follows:
A B C D
1 1 J1 K1
2 2 g r
and so on....
and in the multiprovider you have to make use of ASSIGN CHARACTERISTIC option.
One thing you have to keep in mind, multiprovider works on the concept of unions, where it checks for the common records among the objects which you are using in ASSIGN CHARACTERISTICS option.
If the common fields are not found, then it will display the blank record as you are getting the result at present.
Actually I do have 2 common fields in all the Info cubes. In my report I need to display 4 char and all others are KF. Out of 4 Char, I have 2 char are common in all the infocubes. If I dont add the uncommon fields to the designer My result set is OK. if I add all the 4 char in Rows I am getting the above result.
As to the discussion above, just to put some more light on this.
A MultiProvider can consist of different combinations of the following InfoProviders: InfoCube, ODS object, InfoObject and InfoSet. The data from these objects can be combined in the MultiProvider with a union operation.
The union operation creates a union of the featured tables. That is, all values in these tables are combined. As a comparison: InfoSets are created using joins. These only combine values that appear in both tables. In contrast to a union, joins build the intersection of the featured tables.
Hence there should be some commonality between 2 Infocubes.
Thanks and Regards,
I have tried infoset as well. when I am using Infoset, I am having problem with the values of Key Figures. I am getting 40 times or 50 times of expected result. I have 3 DSO's under my Infoset, and the values in DSO's are same as R/3. any solution for this kind of problem?
Appreciate your help.