regarding bw crm extraction

[Former Member]

Hello Guys,

I need to know what are the steps for BW CRM extraction. I know this has been asked for a lot of times, and I have read some threads before I am posting this question.

I know that we have to activate the BW meta data for the CRM to for the extractors to work, but somehow the steps mentioned on the various thread do not seem to be adequate.

Can we have one thread where we talk all about BW CRM extraction ? Right from step 1. Can someone please post it please ? Also, if we can talk the implications (of what goes in side when we execute each step) it would be great. Its also good to get a technical understanding of the thing works.

[Former Member]

Hi,

Refer these links..

also pls check BI Best Practice ?

http://help.sap.com/bp_biv335/BI_EN/html/bw.htm

'Customer Relationship Management'

e.g

http://help.sap.com/bp_biv335/BI_EN/html/BW/SalesAnalysis.htm

regards.

raj

[Former Member]

HI Mukund,

Steps for Extracting data from CRM:

Configuration Steps

1.Click on ->Assign Dialog RFC destination

If your default RFC destination is not a dialog RFC destination, you need to create an additional dialog RFC destination in addition and then assign it to your default RFC destination

2.Execute Transaction SBIW in CRM

3.Open BC DataSources.

4.Click on Transfer Application Component Hierarchy

Application Component hierarchy is transferred.

5.SPRO in CRM .Go to CRM->CRM Analytics

6.Go to transaction SBIW-> Settings for Application specific Data Source ->Settings for BW adapter

7.Click on Activate BW Adapter Metadata

Select the relevant data sources for CRM sales

8.Click on Copy data sources

Say yes and proceed

9.Logon to BW system and execute transaction RSA1.

Create a source system to establish connectivity with CRM Server

A source system is created. (LSYSCRM200)(Prerequisites: Both BW and CRM should have defined Back ground, RFC users and logical systems)

10.Business content activation for CRM sales area is done

11.Click on source system and choose replicate datasources.

Which Datasource using....?

Hope this Help

Regards,

Raj

[Former Member]

Hi,

Check OSS note 692195

raj

[Former Member]

Click on ->Assign Dialog RFC destination

If your default RFC destination is not a dialog RFC destination, you need to create an additional dialog RFC destination in addition and then assign it to your default RFC destination

2.Execute Transaction SBIW in CRM

3.Open BC DataSources.

4.Click on Transfer Application Component Hierarchy

i didnt understand this 4 steps , where can i find Click on ->Assign Dialog RFC destination and what can i do in sbiw and what is bc data source and why click on transfer application component hiercjhies.

ple clarify, its will be great advantage.

Thanking u

suneel.