What are the steps to create RFC connection on Business Warehouse?

Step1 :- On the BW side :-
1. Create a logical System. SPRO->ALE-> Sending &Receiving Systems -> Logical System-> New Entries (E.g 800  BWCLNT800) 
2. Assign client to logical System.

Step 2 :- Same Procedure for r/3 on r/3 side to create a logical system.

Step3  :- BW side :- Create RFC Connection in SM59.
RFC destination name - Name should be logical system in r/3.
Connection type:- 3
1st tab technical settings
Target host :- IP address of r/3 server.
Sytem :03
2nd tab Logon/Security 
             Lang-En
             Client-r/3 client no
             user- r/3 user
             Password - r/3 password.

Step 4:- R/3 same procedure SM59
RFC destination name - Name should be logical system in bw.
Connection type:- 0
1st tab technical settings 
Target host :- IP address of r/3 server.
Sytem :03
2nd tab Logon/Security 
             Lang-En
             Client-bw client no
             user- bw user
             Password - bw password.

Step 5 :- spro -> select img -> biw->links to other sytems -> links between r/3 and bw
create ALE user in S.S -> select bwaleremote -> back

Step 6 :- In bw 

su01
username BWREMOTE
profiles S_BI_WHM_RFC
         S_BI_WX_RFC
Save.

Step 7 :- In R/3
su01
username ALEREMOTE
profiles S_BI_WHM_RFC
         S_BI_WX_RFC

Save

Step 8 :- In R/3
Create RFC user
su01
user RFCUser  create
usertype system
pwd 1234
profiles SAP_ALL
SAP_NEW
S_BI_WX_RFC

Step9 :-

RSA1
se16
Table RSAMIN enter default client in the field ?BWMANDT RZ10

Step10 :- In bw

su01
user RFCUser  create
usertype system
pwd 1234
profiles SAP_ALL
SAP_NEW
S_BI_WHM_RFC

Step11 :- In bw

RSA1 - Source system -> create
RFC destination

Target system host name of r/3
SID:
System no
Source system ALEREMOTE
pwd

BAckgroung user :BWREMOTE
PWD:

Get help for your SAP BW problems
SAP BW Forum - Do you have a SAP BW Question?

SAP BW Books
SAP Business Warehouse Certification, Interview Questions and Configuration Reference Books

SAP BW Tips
SAP BW Tips and Business Information Warehouse

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com