You can use web services wrapper provided by SAP which allow programmer to use the services provided by DIS. To perform an easy integration, it is possible to use SoapUI in open source version. The connection is performed using login service and with reference of its wsdl, login request can be created and XML definition of message san be seen.                        192.168.90.118          DB_TestConnection          dst_MSSQL2008          manager          Kuldip          ln_English          192.168.90.118:30000           To connect SAP Business One to a program, there are various options that you can try. For more details you can refer this link −https://blogs.sap.com/2014/07/28/connecting-an-add-on-to-sap-business-one/

Note that SAP doesn’t provide demo version of BI tool. Only trial available is for SAP Basis and Java Stack and these doesn’t include any ERP modules. Without availability of any ERP module, it hardly makes sense to use SAP BW demo version as there won’t be any sensible scenario to be used in BI.I would suggest you to use IDES which comes with fully configured business scenarios and BW functionality for demo.To know more about SAP BI 7.0 IDES system, you can refer this SAP thread −SAP Thread

SAP ECC stands for SAP ERP Central Component (ECC). It is a standout amongst the most perceived resources that SAP has developed. It is an ERP software which comprises in a few modules that give the association’s awesome control over their key business forms.Various modules can speak with each other to make a completely coordinated application particular to any client inside an extensive variety of industry areas. It can be customized to serve the individual needs as well.SAP ECC executions are a major test for any client due to the hazard that speaks to changing the way they oversee fundamental ... Read More

Copy the below code in PERSONAL.XLSM module of your workbook and then refresh −Private WithEvents App As Application Private Sub Workbook_Open()    Set App = Application End Sub Try adding below code, in your module: Private Sub App_WorkbookOpen(ByVal Wb As Workbook)    MsgBox "New Workbook: " & Wb.Name End Sub

You can get the data if it is displayed in a transaction. Here are the steps you need to follow.a) First point the cursor on the field for which you want to get the data.b) Press F1 for help. This will open a dialog with heading “Performance assistant”c) Click on the “Technical information” button. This will open up another dialog boxd) You will be able to find “Table name” and “Field name”Generally, this will tell you the table in the database .If you are not able to get the required information, run a trace using ST05. In SAP system, SQL trace ... Read More

Note that In Data Warehouse, data load is less frequent as compared to data read. If you use normalized tables that result more number of joins and hence when you run multiple read statements on DW system, it effects the performance considerably.When you are not using normalized tables, the response time of queries are improved however load time and memory space is increased.You can refer below link to get advantages of denormalization in database and comparison with normalized tables.http://searchdatamanagement.techtarget.com/definition/denormalization