My client wants an infocube be enhanced with some fields form the R3 and some from an ODS. but there are no common fields in them. can anyone please reply back the solution in how i can enhance the infocube.
If the data is first loaded from R/3 into your ODS and then from the ODS to your infocube, you have to first add the R/3 fields to your ODS and then add all the fields that you want from the ODS to the Infocube.
This was there will be smooth and standardized flow of the data into your ODS and Infocube.
Without knowing the exact scenario it is hard to give you an answer but I hope the following broad guidelines might help you.
1) There must be some thing in common or it may be a case of wrong architecture/missing buseness requirements. Identify the relationship between these two.
2) Or, do they have a 100% parallel relationship by design? In this casse you need to create a high level common object (dummy) to facilitate the consolidatation process (for example company code or worst scheario sys-id) and enhance both cube as well as ODS.
3) Or, if it is a complex situation: Introduce a new object which can build a bridge between these two. Ask the business about the rules.
If it doesn't help, pl give more details.