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 on Trending Technologies
Technical articles with clear explanations and examples
Generating 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 MoreDetails available under M_BLOCKED_TRANSACTIONS System View in SAP HANA
The following information is available under SAP HANA M_BLOCKED_TRANSACTIONS System View
Read MoreM_Expensive statement in SAP HANA
This can be checked using system view M_EXPENSIVE_STATEMENTS.SELECT * FROM M_EXPENSIVE_STATEMENTSIn SAP HANA, the M_EXPENSIVE_STATEMENTS view provides convenient access to the most expensive statements that were executed on the system. A statement is considered being expensive if its runtime exceeds a particular threshold. Please note that the expensive statements trace needs to be activated first in the Performance → Expensive Statements Trace screen in the SAP HANA studio. Click Configure the Trace Configuration dialog
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 MoreDisk utilization and configuration details view in SAP HANA
You can make use of M_DISKS System View which provides information about disk configuration and utilization of the host machine.SELECT * FROM M_DISKS;
Read MoreChecking System limits in SAP HANA
M_SYSTEM_LIMITS is a view to getting SAP HANA system limits. You can query this view to find the limitations of HANA system −SELECT * FROM M_SYSTEM_LIMITS;It will provide you details about Database Limitation Schema Limitations Tables and View Limitation Indexes and Constraints SQL SQL Script
Read MoreDifference between SAP PI/PO and ESB
SAP PI/PO is more relevant to use when your entire landscape is of SAP modules. SAP Process Integration is a part of the SAP NetWeaver platform. It is called SAP NetWeaver Exchange Infrastructure XI in NetWeaver 7.0 ehp2 and older versions. SAP NetWeaver Process Integration is a part of the NetWeaver software component and is used for the exchange of information in company’s internal system or with external parties.SAP PI/XI enables you to set up cross-system communication and integration and allows you to connect SAP and non-SAP systems based on a different programming language like Java and SAP ABAP. It ...
Read MoreMaximum Column name length in SAP HANA
Maximum column name length supported in a table in SAP HANA is 127 chars.
Read More