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 Articles
Page 46 of 91
Multidimensional Expression and its use in SAP BPC
MDX is a query language developed by Microsoft to query OLAP cubes. In OLAP cubes, data is structured as multidimensional. You have a fact table in middle and dimension tables surrounding fact tables. MDX is used to query STAR schema cubes like this and generate results for different purposes.MDX query language is bit similar to SQL with few fundamental differences like:In MDX queries, it can have 0, 1, 2, 3, 4…up to 128 query axes in the SELECT statement. Each axis behaves in exactly the same way, unlike SQL where there are significant differences between how the rows and the ...
Read MoreHow to call RFC in SAP using an ETL job?
You need to expose RFC as Web Service in SAP system. To create a Web Service, you have to open Transaction SE80 and this will open ABAP Workbench.You can define Web Service for −RFC Capable function modulesFunction GroupsBAPIsMessage InterfacesIn Web Service Wizard, enter the name and short text and select Function Module as Endpoint TypeWhen you navigate to configure service, you need to select SOAP profile from drop down as below −
Read MoreIntegrate node.js with SAP HANA system
You can insert data into HANA database using node.js. You can also connect to SAP HANA database via JDBC driver.To connect via JDBC, you need to install JDBC driver ngdbc.jar. This driver is installed as part of SAP HANA client installation. Ngdbc.jar file is available at this location −C:\Program Files\sap\hdbclient\ on Windows platforms /usr/sap/hdbclient/ on Linux and UNIX platformsNext is to add ngdb.jar to the classpath and write a Java program to connect to a database and execute SQL command.jdbc:sap://myServer:30015/?autocommit=falseYou can also add one or more failover servers by adding additional hosts.ExampleFollowing is an example of connecting SAP HANA Server ...
Read MoreSuppressing duplicate entries in classical and ALV report in SAP ABAP
To delete adjacent duplicate entries in an internal table, you can use the below command −DELETE ADJACENT DUPLICATE ENTRIES FROM [COMPARING ... |ALL FIELDS].Also, consider the below points −The system deletes all adjacent duplicate entries from the internal table . Entries are duplicate if they fulfill one of the following compare criteria:Without the COMPARING addition, the contents of the key fields of the table must be identical in both lines.If you use the addition COMPARING ...
Read MoreLoading External Libraries in SAP UI5
External libraries can be inserted using a file in a normal script tag. SAP UI5 also supports JQuery so it can be done by extending your heading from the controller.var s = document.createElement("script"); s.type = "text/javascript"; s.src = "http://domainname.com/somescript"; $("head").append(s);You can also add any external file using the following command −jQuery.sap.registerModulePath("ModuleName","http://Domainname.com"); jQuery.sap.require("ModuleName.jsFileName");You can navigate to the following path for more details−https://blogs.sap.com/2016/04/22/include-external-javascript-library-in-sapui5/
Read MoreConnecting SAP in Ruby on Rails
Try downloading nwrfcsdk library from sap and follow instructions mentioned in Readme to perform the installation. Use function Module like ENQUEUE_READ to perform remote call as below −#!/usr/bin/env ruby require 'sapnwrfc' require 'rubygems' conn = SAPNW::Base.rfc_connect(:client => '800', :sysnr => '01', :lang => 'EN', :ashost => 'hostname', ...
Read MoreActivating an Attribute view in SAP HANA
This can be checked by looking at view name in a package. If there is a Grey diamond mark on the name it means View is not activated.
Read MoreAdding columns to output in an Attribute view in SAP HANA
This can be done in 2 waysYou can directly click on round circle in front of the column name in Details PaneYou can add a column to output by right click on the column and select → Add to OutputWhen you add a column to output pane, it is added in Output pane on the right side under columns list.
Read MoreDefining a primary key in an Attribute view in SAP HANA
This can be done by selecting column name from the list of columns under Output pane.
Read MoreDifferent License types in SAP HANA
HANA Support two types of license −Temporary License KeyPermanent License KeyTo check your system license, you have to select HANA system in Studio → right click → PropertiesThis will open Properties of your HANA system. Navigate to License option and there you can check license type in use −
Read More