cancel
Showing results for 
Search instead for 
Did you mean: 

How to load external data to SAP BW?

Former Member
0 Kudos

Hi All,

I try to load data from external application to SAP ware house using RFC, as i am new to SAP BW, I would like describe my question as below.

1. I have run RFC server in my local machine and resister in the SAP system successfully.

2. In the source system, i click check, connection OK.

3. Create DataSource in the Data Sources.

4. Create InfoSources, it contain two rows. but when i try to create transformation, it always give the message "Source doese not exists".

I am not sure why this happened, could you please give some advices. Besides, where can i get some tutorial document of this operation on SDN?

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

This is such a vast topic. There are multiple ways to load data into BI. It could be through Flat Files, or through Web Services, from R/3 etc..

For XML Services:

http://help.sap.com/saphelp_nw70/helpdata/EN/fe/65d03b3f34d172e10000000a11402f/frameset.htm

For Flat File loading:

http://help.sap.com/saphelp_nw70/helpdata/EN/43/03450525ee517be10000000a1553f6/frameset.htm

General:

http://help.sap.com/saphelp_nw70/helpdata/DE/44/b734ed352056a3e10000000a1553f6/frameset.htm

Transfromations:

http://help.sap.com/saphelp_nw70/helpdata/EN/f8/7913426e48db2ce10000000a1550b0/frameset.htm

Pls search the forum for more details.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Allen,

There is nothing wrong with this. When you are creating new infosource this will ask for if you want to use this infosource for Master data or Transaction Data.

Can you elaborate more which kind of data you are trying to extract through this Info Source.

In BW Masterdata is stands for the data which is not changing very frequetly and through which data you relate your Value fields like cost, volume to identify it in correct group.

Transaction Data is mostly the sale quantity, items many.

So plesae select this option according to your need.

Regards,

Mahesh

Former Member
0 Kudos

Hi Mahesh,

In my enviornment, i can't see the options weather Master data or Transaction Data.

I have take screen snapshot as below link. Would you please take a look?

[screen snapshot|http://picasaweb.google.com/yanminglc/BW#]

Thanks.

rajkumar_kandula
Active Contributor
0 Kudos

Hi,

Master data infosource means infosource with Direct Update

Transaction data infosource means infosource with flexible update

Former Member
0 Kudos

HI, thanks for your information.

1. I use SAP NetWeaver BI 7.0. I read from some document about Creating an Info Source. But when i right click the infoSource. The options are

-


change

delete

create application component

create info source

Additional functions...

-


2. I select "create info source", a windows pop up. The input filed is infoSource and Long Description. But from some other document, It will let me choose master data or Transaction Data.

Is this beacuse product update or something wrong with my configuration?

Former Member
0 Kudos

Hi,

Kindly go through this one also. This is on BI 7.0. This one contains all basic things and pls spend quality time on the forums too. All your doubts will be answered here, if not by reading the documents.

http://help.sap.com/saphelp_nw70/helpdata/en/b2/e50138fede083de10000009b38f8cf/frameset.htm

Hope this helps.