cancel
Showing results for 
Search instead for 
Did you mean: 

crm survey suite extractors into BW

Former Member
0 Kudos

Does anyone know whether there are some Business Content extractors for the survey data in CRM. My CRM colleagues have setup surveys using the CRM_SURVEY_SUITE transaction and it would seem to store at least some of this data in the table CRM_SVY_DB_SVS, but not all. However I cannot find any standard extractors to extract all the survey data.

There are extractors for the web survey stuff but the CRM_SURVEY_SUITE transaction does not appear to be a web survey.

Any help would be much appreciated on this.

We are using CRM 4.0 with BW 3.5

Thanks

David

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hello BW guru,

I am having the same issues with 0SVY_DATA_1 for CRM 7.0 It seems like the extraction is loading XML translated data and it doesn't make sense. Does any know how to extract CRM Survey Suite data?

Any help is appreciatedm,

HarryT

Former Member
0 Kudos

Hi David!

What you will propably see is that the business content for surveys does not allow analysis based on the business partners that are associated to the survey. We use this functionality in CRM3.1 and thought this was a big limitation. A crucial question is of course "who gave what answer on that question?". What you can do to overcome this, is to create a generic datasource based on a view that joins the tables:

CRMD_ORDERADM_H <-> CRMD_LINK <-> CRMD_SURVEY

You can also use the CHANGED_AT field for delta capability.

Kind Regards

Andreas

Ashwin
Active Contributor
0 Kudos

Hi!

you can find survey datasources under RSA5 Root->CRM->0crm_SURVEY. these are some datasources

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

and web survey datasources under PI_BASIS->0CA_SUR

0WS_ANSWER_TEXT Web Survey: Reply

0WS_APPL_TEXT Web Survey: Applications

0WS_KFIGTYP_TEXT Web Survey: Key Figure Types

0WS_QSTNNR_TEXT Web Survey: Questionnaire

0WS_QUEST_TEXT Web Survey: Questions

0WS_STATUS_TEXT Web Survey: Question Status

0WS_SURVEY_TEXT Web Survey: Survey

0WS_TAROBJ_ATTR Web Survey: Recipient

0WS_TAROBJ_TEXT Web Survey: Recipient

hope it helps

with regards

ashwin

former_member184494
Active Contributor
0 Kudos

and also you can explore on the business content side to find out the cubes / ODS you need for the datasources mentioned.

0crm_c09

0crm_cxs

0cust_c1

and a lot more ... This is just a list of cubes I could find ....

You can also go through best practices for more info on the same

service.sap.com/bestpractices

Arun Varadarajan

Former Member
0 Kudos

thanks for the posts. I have found out that the main problem was due to lack of configuration on the CRM side rending the Business content extractors useless!

David

Former Member
0 Kudos

Hi David,

I am facing a problem similar to that of yours for the CRM survey suit extraction.what was the configuration setting missing in CRM that you have mentioned. What were the "Survey Attributes" that you had maintained in the transaction CRM_SURVEY_SUIT ( TAB: Technical Settings) ?

Regards

Manish

> thanks for the posts. I have found out that the main

> problem was due to lack of configuration on the CRM

> side rending the Business content extractors

> useless!

>

> David

Former Member
0 Kudos

Hi Manish

Did you get a reply back from David, i am also looking for the same information. If you know how to configure the 0SVY_DATA_1 Datasource to the CRM survey please let me know. your help is greatly appreciated.

Please send me an e-mail to PTALLURU@YAHOO.COM.

Thanks

Prasad Talluru

Former Member
0 Kudos

Hi Prasad,

I did not get any reply David. For the DataSource 0SVY_DATA_1 you have to configure the transaction CRM_SURVEY_SUITE wherein you have to choose the application for which you are configuring the survey.

Once you have Created/Configured the survey and Maintained Survey Attributes you can test the DataSource via RSA3.

Former Member
0 Kudos

Hello Prasad,

I forgot to mention, If you have got any details about what I asked David please let me know as my question still remains unanswered.

Manish

Former Member
0 Kudos

Hi Prasad,

I am also looking for the configuring the survey. Kindly send me the procedure for configuring the 0SVY_DATA_1 data source. Currently it is giving the error in the crm system in rsa6

Thanks

naveen

former_member184494
Active Contributor
0 Kudos

I do remembver seeing a lot of cockpits and datasources for Web Surveys ... check in Business content and more so in help.sap.com ..

Arun