Category: SAP BW for Freshers

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

How to create tables in SAP System-I

There are three ways to create a table in SAP- Using Built in type or pre-defined type Using top-down approach (Table, Table properties, fields, data elements, domains, check fields, currency fields, technical settings,…) Using bottom-up approach (data, domains, data elements, table, table properties, fields with data element assignments, technical settings) Creation of table: Master data…

Read the full article