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 TR ISFS
Since the datasource cannot exist in both of these versions simultaneously, you have to choose the form while replicating them to BW.
Replicated 3.x datasources can be used as Emulated datasources in BW for migration purposes.
SAP recommends migration of 3.x datasources if you are using RDA DTPs or Direct Data Access DTPs as emulated datasources does not support these two types of DTPs. Continue reading “Migration of Datasources”
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 must be present in the cube)
Partitioning and re-partitioning can be done even though the cube contains data. This concept was first introduced in SAP Netweaver BW 7.0 as a replacement of partitioning in 3.x
Please note that you do not partition the cube when you create it. Usually it is done at a later point in time when the cube has more than a million records. Continue reading “Repartitioning (Infocube)”
Generic Datasources / Extractors – Cross Application (RSO2, SBIW)
Master data / Attributes extraction/ acquisition from SAP R/3 ECC (OLTP) to SAP BI (OLAP) using generic data sources – cross application
Eg. 1. Using a Database table
T-codes: SBIW, RSO2, SE11, SE16, RSA3, RSA7, RSA11, RSA13, RSA14, RSD1, RSDS, RSMO, RSMON, LISTCUBE, RSPC, RSPC1, RSPCM
Part 1: Data Modeling
Step 1: Logon to SAP R/3 system
Step 2: Check the data in the table
Enter tcode SE11 Continue reading “Generic Datasource extraction in BW from Master Data table in ECC”
Creation of Transaction data table with variable currencies and units of measure
Method: Top down approach
Continue reading “How to create tables in SAP system-II”