Wednesday, April 25, 2012

Writing quick lookup transformation code for SAP BW.

When working with data in BW you will often need to do a lookup in the masterdata to be able to add the corresponding attribute coming from the communication structure during the transformations in SAP BW. Logically you want to have a lookup which is fast during runtime. In the following example we will give you a basic description how this code should look like, to ensure the performance of the transformation during the ETL process within BW.
This blog also explains the difference in types of internal tables which is important during coding to improve the performance even more.

Wednesday, April 18, 2012

Smart Value Help (SVH) in SAP CRM

As of CRM 7.0, we can use the Smart Value Help in SAP CRM. Standard SAP uses this on for instance the country and language fields.

This article describes how you can use this functionality on other fields like for instance your custom fields, how it works and what you should be aware of (performance wise for instance).

Wednesday, April 11, 2012

How to install SSO between CRM and BW

Within the SAP CRM WEB UI you are able to create direct links to BW reports with are running on a separate BI system. Normally a direct url link is made to access these BW reports, which can be a Query or Web Template. To avoid to logon to the BI system at the moment you access the BW reports, you can create an SSO (Single Sign On) connection between the CRM and BW systems. A prerequisite to this SSO is that the user names on the CRM and BW system are the same, it is not necessary that the passwords are the same.

Wednesday, April 4, 2012

Data Extraction from CRM to BW with BDOCs

This blog focuses on the concept of data extraction from SAP CRM 7.0 as an OLTP database to SAP BW as a OLAP database. CRM BW Analytics offered by SAP is an extensive and tight integration between the two SAP Business applications. Because the extraction of data works in a very specific way in CRM, it is easily overlooked. Other BW extractions of SAP OLTP work in a more generic way, different from how it is done in SAP CRM 7.0.
There are quite a lot of articles that describe in detail how it is done, this blog gathers that information. By describing it in a simple way it may be easier to understand the basic steps involved in configuring and implementing this CRM BW Adapter framework. The BW adapter (BWA) is built within the CRM environment so that unlike in ECC, no additional installation of a plug-in is necessary.

In a future blog about Data Extraction for CRM, I will explain “How to enhance a BW adapter based data source”.