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
SAP HANA Articles
Page 16 of 58
Using Where-Used option in SAP HANA Modeling
With use of Where-used functionality you can easily find this information. Right click on object name → Where-Used
Read MoreDeleting inactive objects in SAP HANA
In SAP HANA, you can delete all inactive objects in workspace. In HANA Modeler Perspective → Delete Inactive Objects..You can also revert to last active version if exists.
Read MoreChecking transaction list waiting for lock-in SAP HANA
M_BLOCKED_TRANSACTIONS System View is used to provide a transaction list waiting for locks.You can run the following SQL query in the editor −SELECT * FROM M_BLOCKED_TRANSACTIONS;Details available under M_BLOCKED_TRANSACTIONS System View in SAP HANA
Read More\\nStore data in format of XML string in SAP HANA system
In older SAP HANA versions, no XML functions were provided. With HANA 2.0, these two functions are provided- XMLEXTRACT and XMLEXTRACTVALUE for extracting XML string in SAP HANA.Use of XMLEXTRACTXMLEXTRACT(, [, ])Syntax to use −Specifies an XML document of type CLOB, NCLOB, VARCHAR, or NVARCHAR.Specifies an XPath expression of type VARCHAR or NVARCHAR.Specifies a namespace declaration of type VARCHAR or NVARCHAR.DescriptionReturns the matching XML element. The return value is of type VARCHAR/NVARCHAR or CLOB/NCLOB depending on the type given for .If an XML element is empty (for example, ), then an empty result is returned. If an XML element ...
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 MoreGetting MIN and MAX dates in table in SAP Web Intelligence while using a Break
This can be achieved by creating an Indicator as per condition you are looking for- minimum drawn date time for POST-Test and Maximum drawn date time for PRE-Test. Once you create this indicator, it will show “Y” for the rows highlighted in yellow as per condition and “N” for other rows.=If ([Drawn date] = Min([Drawn date]) In ([Patient ABO/RN]) Where ([PrePost] = "POST") ) Or ([Drawn date] = Max([Drawn date]) In ([Patient ABO/RN]) Where ([PrePost] = "PRE") ) Then "Y" Else "N"You need to apply a filter for rows with indicator value- “Y”.Other option is you can create 3 variables as ...
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