SAP - BI
How to Create an InfoObject with Characteristics in SAP BI/BW
Step 1) Go to transaction code RSA1 to go to the Data Warehouse Workbench. Click the OK button....
Step 1) Creating a Generic Data Source for Text InfoObject
Right click on the BI Source System -> Customizing Extractors.
In next screen, click on Maintain Generic DataSources.
In next screen,
In next screen,
Press the Enter button. The below screen is displayed.
Now,
In next screen,
Next, from the datasource ZGR24CC_TEXT, right click Replicate Metadata as shown below. Activate the DataSource.
Step 2) Create transformation between Data Source(Source) and InfoObject Text(Target).
In next screen, right click on the DataSource -> Create Transformation
In next screen,
The transformation would be created with automatic mapping of the Source fields to the Target fields.
Step 3) Create Infopackage and Schedule Dataload to the DataSource(PSA).
Step 4) Create Data Transfer Process.
Right-Click on DTP folder and choose the option “Create Data Transfer Process” from the context menu.
The below shows the DTP created.
Step 5) Load Data to the InfoObject Text.
Step 1) Go to transaction code RSA1 to go to the Data Warehouse Workbench. Click the OK button....
We will learn the load with the help of a scenario - Load Master data to InfoObject ZMAT (Material...
What is Process Chain? A process chain is a sequence of processes that wait in the background for an...
What is Schema ? In database management system (DBMS), the schema represents relational database. It...
What is Infocube? Infocube is data storage area in which we maintain data which we are extracting from...
Following are the steps to perform the data extraction from ECC into BW systems. We will take...