APD Simplifies Marketing Attribute Updates from SAP BI to SAP CRM

  • by Ankur Shah, Consultant, Capgemini
  • June 15, 2008
See how you can update SAP CRM marketing attributes, such as customer lifetime value and student education level, using Analysis Process Designer (APD). The technique includes how to prepare your data, map it from SAP NetWeaver Business Intelligence to SAP CRM, and then use APD to process it.
Key Concept

Analysis Process Designer (APD) provides an intuitive graphical interface that enables you to visualize, transform, and deploy data. It simplifies how you update marketing attributes for business partners by combining all the steps in the process, such as calculating the marketing attribute values. APD then feeds the updated data from SAP NetWeaver Business Intelligence to SAP CRM in a single data pass.

I recently completed a project for a rapidly growing mid-sized company that provides courses and tools that help you learn a new language online. The compa­­ny embarked on an ambitious SAP project to achieve operational scalability by replac­ing its legacy business systems with SAP-enabled processes.

With this process in place, the company creates the business partners and contracts in SAP CRM 2005. When a customer places an order, the system replicates the sales order for billing in SAP ERP 6.0 using CRM Middleware. SAP ERP then extracts the order information to SAP NetWeaver Business Intelligence (SAP NetWeaver BI) to calculate the student education level (SEL) and customer lifetime value (CLTV) ratings.

I developed a technique in which I use Analysis Process Designer (APD) to help me update these attributes. APD has a graphical user interface, which makes setting up the data transfers easier. Let me walk you through the steps to prepare your system to use APD for this purpose. Then I’ll show you how to set up the data transfers in your system. When you complete the process, you’ll have created an interface between SAP CRM and SAP NetWeaver BI to update the business partner marketing attributes, CLTV, and SEL.

You can implement this APD technique to update any marketing attributes. In fact, you can update not only the marketing attribute data, but also customized d

Ankur Shah

Ankur Shah is a certified SAP NetWeaver BI 7.0 consultant with Capgemini US LLC and is based out of Cupertino (CA). He has been part of end-to-end implementations for SAP NetWeaver BI 7.0 and SAP BW 3.x at various clients. Before working on SAP NetWeaver BI implementations, Ankur started his career with TCS in India.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.