Can someone please explain me SAP BI model briefly?

Question

I am trying to get the Microsoft Connector for SAP BW ver 1.1 working in our environment. This is to push data into BW only not extract it. I have put the LibRFC.dll in place on the SQL server and can create a connection to BW. When I test the connection in SSIS it says OK so I know this bit is fine. When I do a test load I get an RFC failure. I have setup my Info cube and any necessary objects in BW. I have even looked on the gateway and can see the attempts but I need to interrogate the error at a lower level to find out what is going on. I am using SQL 2008 R2 with the Sap BW connector version 1.1. Can anybody offer me any help with this issue as its becoming quite critical.

Answer 1

Below are some of the links where you can get useful information on modelling.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/2f5aa43f-0c01-0010-a990-9641d3d4eef7
http://www.sap-press.de/download/dateien/826/sappress_sap_bw_data_modeling.pdf
http://www.pdf4me.net/pdf-data/sap-bi-modelling.php
http://help.sap.com/bp_bw370/documentation/Multi_Dimensional_Modeling.pdf

I hope it helps you

Answer 2

If you are a beginner in this Module then try to learn the basic thing first . I am giving you a link which is very helpful to understand the basic things .

enter link description here
And one more thing that I want to share with you if you are working in any company then try to practice as much as possible with the real time server otherwise practice it in IDES version which is online available.

Answer 3

SAP Business Warehouse (BW) integrates data from different sources, transforms and consolidates the data, does data cleansing, and storing of data as well. It also includes data modeling, administration and staging area.

SAP Business Intelligence (BI) means analyzing and reporting of data from different heterogeneous data sources. It allows you to acquire data from multiple data sources, data staging, which can be further distributed to different BI systems. A SAP Business Intelligence system can work as a target system for data transfer or source system for distribution of data to different BI targets.

Comments

Where is the question asking for the course and training. Anyway I have removed unnecessary information.