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
Articles by SAP ABAP Expert
Page 6 of 12
Checking 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 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 MoreGenerating time data in SAP HANA
To generate time data and replicate your data, follow below steps −In the SAP HANA Studio in the Modeler perspective, on the Quick Launch tab, select the relevant SAP HANA system and choose Generate Time Data.In the field Calendar Type, select Gregorian.Enter the period for which you want to generate data. You should generate time data for all years for which data can occur in your application (Ex: 1999 to 2020).Select Granularity Day → Finish
Read MoreChecking information about basic I/O operations on I/O subsystems in SAP HANA
You can make use of M_VOLUME_IO_TOTAL_STATISTICS System View which shows information about basic I/O operations on I/O subsystems (paths).
Read MoreMaximum Table name length in SAP HANA
Maximum table name length supported in SAP HANA is 127 characters.
Read MoreAdding multiple views in SAP HANA Analytic Privilege
Yes, you can define Analytic Privilege for multiple views in a single object. When you add multiple HANA views, you can find all Attributes: Select attributes to assign analytic privileges.
Read MoreDifferent Nodes option in a Calculation view in SAP HANA
In SAP HANA Calculation View, following nodes are available −JoinUnionProjectionAggregationRank
Read MoreGetting error while running SAP oData service "HTTP Open failed: PLUGIN_NOT_ACTIVE
To fix this, you need to run T-Code: SMICM and this will open ICM Monitor Service Display. You need to maintain port number 80000 for HTTP in SMICM.
Read MoreChecking create time for all users in SAP HANA
This can be found using following SQL command −SELECT * from USERS;
Read More