Loading of hierarchy from CRM-BW

pts.
Tags:
CRM
Data analysis
1) How to load a User defined hierarchy from CRM to BW without using a flat file? Hierarchy is already created in CRM we are not able to create the datasource for this hierarchy in CRM. 2) In SAP R3 we have a transaction BW10 which is used for creating datasource for custom defined hierarchies,what is the equivalent Transaction in CRM?

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can either create the DataSources with which to extract objects from an sBDoc or enhance the delivered DataSources. You do this in Customizing for CRM under Integration with Other mySAP Components > Data Transfer into SAP Business Information Warehouse > Settings for Application-Specific DataSources (CRM) > Settings for BW Adapter > Maintain DataSource and Enhance BW Adapter Metadata.

Regarding the CRM hierarchy you want to extract to BW , check it is active in BPH and then run T-code SMOX_HIER to actually extract it. Avoid running this transaction in Production during the day as it took most of our system resources, which is surprising considering the small size of a hierarchy. We had many issues with extraction from CRM 3.1 but SAP say improvements have been made in version 4.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following