I have an infoobject in my target cube that i have to populate with an attribute of the infoobject in the source cube. However no data is maintained for that attribute in the master data table of the source info object. It is maintained in a seperate table. How do i write a routine to populate the target infoobject from the source info object which is inturn reading the table.
Target Info Object: ZMAT_GRP (ZMAT_GRP is a attribute of ZMATERIAL)
Source Info Object: ZMATERIAL (Master data table/BIC/PZMATERIAL, but no data is maintained for ZMAT_GRP)
Table in which data is maintained for ZMAT_GRP: ZMAT_SUMMARY.
Is the ZMAT_SUMMARY table existing on R/3 side or BW ?
If BW you can have a lookup in start routine or endroutine of your cube to populate the Material group.
select ZMAT_GRP from ZMAT_SUMMARY where MATERIAL EQ ZMATERIAL(of cube).