Survey answer score extraction

[Former Member]

I need to extract survey information to BW, but I don't want to use standard datasources because I've developed a custom table for survey results.

I've got everything except the score assigned to each answer in the Survey Suite. This is stored in XML format and I can't get to it. Any ideas? XML functions...anything?

[Former Member]

Hi Joao

I see Andrew's focus !

Anyway you can create a Generic DataSource (RSO2) and use Extraction from FM (Functional Module). If you are not comfortable with ABAP, then seek the help fo an ABAPer.

Hope this suffice.

Ajai

[Former Member]

Further, if you want to use the CRM extractor and enhance the datasource structure, then try using BAdI.

To enhance CRM extractors we enhance the BDoc and then used the BADI CRM_BWA_MFLOW or CRM_BWA_SFLOW whichever is applicable to extract the data for the enhanced fields and fill the data source.

Also we go to transaction RSA6 enhance the datasource structure.

In transaction RSA6 select the datasource structure and choose the menu "Function enhancment". This goes to CMOD transaction and there the user exit "EXIT_SAPLRSAP_001" is enhanced.

Thanks

Ajai

[Former Member]

Hi Joao,

My recommendation is to revert back to standard. Upgradeability is then available plus no development costs.

Cheers

Andrew