i have used standard InfoObjects that provide master data for two InfoCubes which take data from two different source systems. Now the some of the master data is identical in both the source systems (example: 10 stands for "Industrial" in one whereas 10 stands for "Agricultural" in the other). What do i do so that the system(BW) differentiates the two.
Thanks in advance for all the help.
One idea is to add infoobject 0SOURSYSTEM to your InfoCubes as well as compounding 0SOURSYSTEM to all infoobjects where the master data is being fed from different source systems. However, if the master data for some infoobjects are the same in both systems, you may not need to compound 0SOURSYSTEM to those.
Hope this helps,
I tried to include the 0SOURSYSTEM in the compounding of this InfoObject (for master data) but it gives me a list of other objects that use this InfoObject as a reference characteristic and also says that this InfoObject is used in a ODS and data needs to be emptied in the ODS before activating this InfoObject. Please let me know if there is any way out of it.