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.
I do not have common fields in the info cubes. As I have 4 infocubes, some of the fields are available in 2 or 3 infocubes and are not available in others. Is there any other solution when there are no common fields.
Can you explain me in breif the reason why you need to have uncommon fields to be shown together in report?
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.
Hi Anil,
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,
Hi Anil,
I faced the same problem earlier and the solution is to use infoset.
Regards,
Aaradhana.
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.
