Data Extraction

Data Extraction (Loading data from OLTP servers to OLAP (BW/BI) servers)
OLTP server stores daily transactions data. For a bank all the transactions related to money debit/credit to any account, loan, employee related data etc will come under transactional data. They are used to support real time business. But for analysis purpose we do not need all data at each transaction level. For this purpose we load data from transactional servers to BW/BI Servers. We extract data/fields which are necessary for the analysis of the business and will help in taking business related decisions.

You may load transactional data to BW/BI servers on daily basis/weekly basis/monthly basis. Frequency of loading or refreshing the data depend on the criticality of the decision taken based on that data. If any decision which is very critical and can impact short term business decisions, we need to refresh the data on daily basis.

Data Extraction Process

Basis of extraction is OLTP extraction tables. So R/3 OLTP source system must be replicated to BW. To replicate the Metadata from a source system into BW for an application component, choose Source System Tree->Required Source System->DataSource Overview ->The user Application Components ->ContextMenu (right mouse click)->Replicate DataSources in the BW Administrator Workbench.

To update all the Metadata of a source system-Choose Source System Tree requires

Source System ->Context Menu (right mouse click)->Replicate DataSources in the BW

Administrator Workbench

• Replicate the data source to BW server
• Go to transaction code RSA3-> Check data is available related to your Data Source.
• If yes-> Go to transaction code LBWG (Delete Setup data) -> Delete the data by entering the application name. 
• Go to transaction SBIW --> Settings for Application Specific Data source --> Logistics --> Managing extract structures --> Initialization --> Filling the Setup table --> Application specific setup of statistical data --> perform setup (relevant application)