Loading of hierarchy from CRM-BW
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
December 2, 2004 7:05 AM
UPDATED:
December 3, 2004 7:41 AM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
