Category: SAP BW

Transport failed with RC=12 error

Issue- Sometimes while transporting changes from Dev to Quality system or from Quality to Production system, the TR fails with RC 12 error. This is a critical error which does not depend on the contents of the TR. There may be many scenarios leading to this error, I have mentioned one of them in my…

Read the full article

Migration of Datasources

In SAP source system (ECC), the datasource is the relevant object that makes source data available in a flat structure for data transfer into BW. In the source system, the datasource can have the SAP Delivery Version or Active Version. There are two types of datasources in BI: R/3 TR RSDS or 3.x DS R/3…

Read the full article

Repartitioning (Infocube)

Partition of InfoCubes is done to divide the huge data in the fact table into several smaller, independent units. This improves the query performance. InfoCube can only be partitioned using one of the two below criteria- Based on month (0CALMONTH info object must be present in the cube) Based on Fiscal period (0FISCPER info object…

Read the full article

Direct Update DSO and APD

Direct update DSOs are generally used in conjunction with the APDs (Analysis Process Designer). APDs are very helpful in analyzing the hidden patterns in the data coming from various sources. E.g. APO system creates plan data using complex algorithms for certain actual sales data in BW. Both of these can be fed to the APD…

Read the full article