SAP - BI
Overview of SAP BI Architecture
Before we learn more about SAP BI Architecture, lets learn about Conceptual Layers of Data...
We will learn how to load transactional data from a Flat File with the help of a scenario.
Scenario: Load data to the DSO named “DEMO_DSO”. The DSO has the following fields.
Key Fields:
ZCUST - Customer
ZMAT – Material
Data Fields:
ZPRICE – Material Price
ZQTY - Quantity
Lets look into the Steps to Load data to DSO from Flat file
Step 1) Create source system for flat file.
In the next screen,
In the next screen,
Step 2) Create Application component.
Step 3) Create Data Source.
Step 4) Create transformation between Data Source(Source) and DSO(Target).
Below screen shows the transformation created with automatic mapping of the Source fields to the Target fields.
Step 5) Create Data Transfer Process.
Right-Click on DTP folder and choose the option “Create Data Transfer Process” from the context menu.
Below screen shows the DTP created.
Step 6) Create Infopackage and Schedule dataload to the DataSource(PSA).
Step 7) Load data to the DSO.
Before we learn more about SAP BI Architecture, lets learn about Conceptual Layers of Data...
What is Write Optimized DSO? Write Optimized DSO is used when a Data storage object is required for...
What is DSO? A DSO is a two dimensional storage unit which mainly stores consolidated and cleansed...
$20.20 $9.99 for today 4.6 (115 ratings) Key Highlights of SAP BI PDF 196+ pages eBook Designed for...
Infoset is a special kind of Infoprovider which does not store data physically. In other words,...
What is Process Chain? A process chain is a sequence of processes that wait in the background for an...