Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
SAP BW Articles
Found 6 articles
Finding the table from which data is fetched in SAP
You can get the data if it is displayed in a transaction. Here are the steps you need to follow to find the table from which data is fetched in SAP. Method 1: Using F1 Help and Technical Information This is the most straightforward method to identify the source table for any field displayed in SAP − First, point the cursor on the field for which you want to get the data Press F1 for help. This will open a ...
Read MoreDenormalization of dimension tables in InfoCube in SAP BW
In Data Warehouse systems, data load operations occur less frequently compared to data read operations. When using normalized tables, the system requires more joins, which significantly affects performance when running multiple read statements on the DW system. Denormalization is the process of combining normalized tables to reduce the number of joins required during query execution. When you implement denormalized tables, the response time of queries improves significantly, however, this comes with trade-offs including increased load time and higher memory space requirements. Benefits of Denormalizing Dimension Tables in InfoCube ...
Read MoreIn SAP Business One, making HTTP request with SOAP body
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/
Read MoreDemo version of SAP BW
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
Read MoreOpen a Workbook require loading SAPBEX.xla file
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
Read MoreDifference between SAP ECC system and SAP BW system?
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