SAP-BI@How to Load MD -ATTR/TEXT from Flat file
How to Load MD -ATTR/TEXT from Flat file?
-----------------------------------------
Steps:-
-------
1) Create Application Component.
2) Create Info Source.
* Info Source will define Communication Structure.
* Communication Structure is specific to SAP BW.
* Communication Structure is grouping of logically related info objects indicating in what structure format the SAP BW takes in the data.
* Info Source will be of 2 types
a) Direct Update
b) Flexible Update
3) Create Source System connection between faltfile and SAP BW.
Types:-
-------
1) SAP Automatic - SAP
2) SAP MAnual - SAP
3) SAP BIW(Myself) - SAP BW to BW
4) Flat file Interface - Flat file
5) DB Connect - RDBMS ( oracle,sql server,msaccess,DB2
6) External System with BAPI - ETL Tools(Informatica,Tipco,Web methodsd) (Hyperion)
BI 7.0
------
1) UD Connect:- runs with J2EE application and can be used to any database.
2) Web services:- To extract from XML files
* when we craete the SS connection the system will configure IDoc's.
* IDoc stands for Intermediate Douument and it is standard for transfering data in SAP environment.
* 2 types of Idocs
a) Data idoc - used to transfer Data
b) Info Idoc - used to transfer information
4) Assign Data Source to Info Source.
* Data Source will define Transfer structure and transfer rules
* Transfer structure is specific to source system.
* Transfer structure is grouping fileds indicating in what structure format data is coming from the SS.
* Mapping B/W Trnasfer Structure and Communication Structure - Trnafer Rules.
Types of Data Source:-
-----------------------
1) Attr
2) Text
3) Hier
4) Transaction Data
5) Create Info Package and run the load.
* Info package is specific to Data source
-----------------------------------------
Steps:-
-------
1) Create Application Component.
2) Create Info Source.
* Info Source will define Communication Structure.
* Communication Structure is specific to SAP BW.
* Communication Structure is grouping of logically related info objects indicating in what structure format the SAP BW takes in the data.
* Info Source will be of 2 types
a) Direct Update
b) Flexible Update
3) Create Source System connection between faltfile and SAP BW.
Types:-
-------
1) SAP Automatic - SAP
2) SAP MAnual - SAP
3) SAP BIW(Myself) - SAP BW to BW
4) Flat file Interface - Flat file
5) DB Connect - RDBMS ( oracle,sql server,msaccess,DB2
6) External System with BAPI - ETL Tools(Informatica,Tipco,Web methodsd) (Hyperion)
BI 7.0
------
1) UD Connect:- runs with J2EE application and can be used to any database.
2) Web services:- To extract from XML files
* when we craete the SS connection the system will configure IDoc's.
* IDoc stands for Intermediate Douument and it is standard for transfering data in SAP environment.
* 2 types of Idocs
a) Data idoc - used to transfer Data
b) Info Idoc - used to transfer information
4) Assign Data Source to Info Source.
* Data Source will define Transfer structure and transfer rules
* Transfer structure is specific to source system.
* Transfer structure is grouping fileds indicating in what structure format data is coming from the SS.
* Mapping B/W Trnasfer Structure and Communication Structure - Trnafer Rules.
Types of Data Source:-
-----------------------
1) Attr
2) Text
3) Hier
4) Transaction Data
5) Create Info Package and run the load.
* Info package is specific to Data source
Labels: Android, Big Data Analytical Skill, FREE SAP BW BI TRAINING, hot News India, IPL, SAP, SAP BI ABAP Course English India Jobs Career, SAP BW Powered by SAP HANA
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home