BW on CRM : Data Source not loading data

[Former Member]

Hi,

I am trying to use the data sources delivered with BI Content, and I want to fill the cube0CRM_C04. I found that it is linked to the infosource 80CRM_C04 . So I tried to import the data from the appropriate data source, but I was stuck( no data is loaded ), because the source system, is the BW server itself (BPP : view attached document) .

What can I do ?

[RamanKorrapati]

Hi jloud,

is this is prod system or dev/ideas system?

Your loading cube to cube data with data marts.

for CRM cubes we need to load data from CRM system.

As my guess this will be your data flow

Data source-->DSO---> Cube

Data sources: 0CRM_OPPT_I and 0CRM_OPPT_H

DSO -  0CRM_OPPH

Cube - 0CRM_C04.

so please install required objects and later try to load data.

Thanks

[Former Member]

Thank you Raman KV, but I want use the same data flow provided by BI Content, so I have not to remap all fields.

[RamanKorrapati]

thats fine, Even standard bi content also will load data from CRM only.

first lets load data to cube 0CRM_C04, later you can export data source as 80CRM_C04 and load where you want.

With out source how can you get the data to 0CRM_C04?.

[Former Member]

no other way to load data without passing by the datasource.