Question:
To enable BW reporting on survey results from CRM, we have activated ODS 0WS_O01 and Cube 0WS_C01 which are fed from data source 0svy_data_1 on CRM. However, there is a request to display in the report the company that the contact person (survey recipient) works for. The delivered report does not have that. Is there any way to get this information? Data source 0svy_tarobj_attr has 0bpartner attribute, but this is used for the contact person BP code. Any way to get the company BP code for either the infoobject 0ws_tarobj or 0bpartner? We looked at the data source 0BP_RELATIONS_ATTR and found it can have many-to-many relationships, so it can only feed an ODS, not attribute. Any help will be greatly appreciated.
Answer:
I read your question quickly, so I may be missing the point, but as we abandoned surveys in BW at a site due to complexity of extensions to the extractor, it's worth mentioning a couple of OSS notes, one of which may be appropriate for your question.
Note 700317 is about extending the extractor for business partner information and note 744699 is about adding the survey creation date (the standard solution uses the date it is posted from ODS to cube which is pretty hopeless).