CRM to BW; how to established link respondent and survey
I'm new to CRM and I have a question regarding the link between a survey and the respondent in BW using CRM Survey Suite. Our setup is as follows:
1. We are using CRM_Survey_Suite to define our surveys in CRM 7
2. For each survey, the property "Evaluation in Business Information Warehouse" is checked and the surveys are correctly saved in the "CRMD_ORDERADM_H" table.
3. Extraction to BW works perfectly
We are using the following datasources from CRM:
0SVY_ANSWER_TEXT CRM Survey: Answers
0SVY_APPL_TEXT CRM Survey: Applications
0SVY_DATA_1 CRM Survey: Results
0SVY_QSTNNR_TEXT CRM Survey: Survey Header
0SVY_QUEST_TEXT CRM Survey: Questions
0SVY_STATUS_TEXT CRM Survey: Status of Question
0SVY_SURV_TEXT CRM Survey: Campaign Texts
0SVY_TAROBJ_ATTR CRM Survey: Recipient Attributes
0SVY_DATA_1 contains the answers which are given by respondents. This datasource is linked to the DSO "0WS_O01" from business content (in which I have added some extra infoobjects like an infoobject for the Survey value GUID in the DSO to prevent aggregation).
In order to find out which person has given which answer I assumed this was possible by loading the 0SVY_TAROBJ_ATTR and combine this with the results which are loaded in the DSO "0WS_O01", however I cannot find how the data should link these two information source to establish this link.
Therefore I have performed searches on scn.sap.com (ex. "https://scn.sap.com/thread/557643" and "https://scn.sap.com/thread/484848") and found that the link can be established by creating a datasource and link the following tables regarding activities and business partners:
CRMD_ORDERADM_H - GUID = CRMD_LINK - GUID_HI
CRMD_LINK - GUID_SET = CRMD_SURVEY-SET_GUID (where CRMD_LINK - OBJTYPE_SET = "58")
CRMD_LINK - GUID_SET = CRMD_PARTNER - GUID (where CRMD_LINK - OBJTYPE_SET = "07")
CRMD_PARTNER - PARTNER_NO = BUT000-PARTNER_GUID
I can build this datasource but how should I link this in BW such that I know the link between the answer and the person (furthermore I need some extra details to be known for each respondent which I have already loaded in BW).
Other tables which are mentioned are "CRM_SVY_DB*" but I don't know whether these are relevant when I'm already loading "0SVY_DATA_1"
I hope you guys can help!