Wednesday, August 22, 2012

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

Labels: , , , , , , ,

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home