SAP ABAP Expert has Published 141 Articles

Checking transaction list waiting for lock-in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 13-Mar-2020 04:51:54

496 Views

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

Different License types in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 12-Mar-2020 11:13:31

346 Views

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 −

Extended application Service in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 12-Mar-2020 11:08:13

186 Views

XS is a Web server responds to provide a development platform and provides end to end support for web-based applications.XS engine helps external Java and HTML based applications to access HANA system with help of XS client. As SAP HANA system contains a web server which can be used to ... Read More

Generating time data in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 12-Mar-2020 10:50:14

454 Views

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 ... Read More

Checking information about basic I/O operations on I/O subsystems in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 12-Mar-2020 10:31:31

158 Views

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).

Details available under M_LICENSES System View in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 12-Mar-2020 10:25:03

122 Views

Maximum Table name length in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 12-Mar-2020 10:12:19

804 Views

Maximum table name length supported in SAP HANA is 127 characters.

Adding multiple views in SAP HANA Analytic Privilege

SAP ABAP Expert

SAP ABAP Expert

Updated on 12-Mar-2020 08:16:49

232 Views

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.

Different Nodes option in a Calculation view in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 12-Mar-2020 08:10:53

582 Views

In SAP HANA Calculation View, following nodes are available −JoinUnionProjectionAggregationRank

Data compression in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 06-Mar-2020 06:07:38

1K+ Views

In SAP HANA, there are various methods and algorithms that you can use to store data in Column based structure- Dictionary Compressed, Run Length Compressed and many more.In Dictionary Compressed, cells are stored in form of numbers in tables and numeral cells are always performance optimized as compared to characters.In ... Read More

Previous 1 ... 4 5 6 7 8 ... 15 Next
Advertisements