SAP - BI
What is DSO in SAP BW? Why Use It?
What is DSO? A DSO is a two dimensional storage unit which mainly stores consolidated and cleansed...
We will learn the load with the help of a scenario -
Load Master data to InfoObject ZMAT (Material Number) which has the attribute, ZMAT_NM (Material Name. Below are detailed Steps to Load data to Master data Infoobject from Flat file
Step 1) Create source system for flat file.
In the next screen,
In the next screen,
Step 2) Create Application component.
Click Save.
Step 3) Create transformation between Data Source(Source) and InfoObject Attribute(Target).
Right click on the DataSource -> Create Transformation
In the next screen,
The transformation would be created with automatic mapping of the Source fields to the Target fields.
Right-Click on DTP folder and choose the option “Create Data Transfer Process” from the context menu.
Below screen shows the DTP created.
Step 4) Create Infopackage and Schedule dataload to the DataSource(PSA).
Step 5) Load data to the DSO.
What is DSO? A DSO is a two dimensional storage unit which mainly stores consolidated and cleansed...
Go to RSA1 -> Modeling ->Infoobjects Right click on the Infoarea -> Click on Create Infoobject...
A standard DSO has three transparent tables on the database. Activation Queue : Holds the records...
BI Content: BI Content provides selected roles within a company with the information that they...
Before we learn more about SAP BI Architecture, lets learn about Conceptual Layers of Data...
Step 1) Go to transaction code RSA1 to go to the Data Warehouse Workbench. Click the OK button....