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 Basis Articles
Page 20 of 50
Different table symbol in SAP HANA database
In SAP HANA Studio, you can check the table type from table symbol under Schema. In below snapshot you can see the different symbol for row table and a column table.TEST_Row − Row store table.SHOPFACT − Column store tableTo change the table type, you can use alter table command.Alter table column table_name;
Read MoreRunning an OLTP query in SAP HANA
When you have to run an OLTP query just to display the specific records, In row based storage, when you run a Select statement all the different datatypes come together so it will be much faster to run a SELECT statement in Row based storage.Select * from FCT_SALES where Country=’US’;When the same query is run in column based storage, you need to find the values of each column in database and it is time consuming so it is not recommended to create a column based storage tables when your queries are not aggregated and required to run simple SELECT statement.
Read MoreRunning OLAP queries in SAP HANA
When you have to run an OLAP query that perform sum of Sales in table with where clause in Country=’US’.Select Sum(Sales) from FCT_SALES where Country=’US’; It storage type is a column based storage in memory cells all the values for Sales will come together in database and when an aggregation ‘Sum’ is performed it will be much faster as compared to an OLTP query.If table is row based storage with values are stored with different data types coming together and a ‘Sum’ aggregation is performed, it will too tough to find values for ‘Sales’ column.In graph, column based tables show the ...
Read MoreSAP HANA Modeling on top of row and column base tables
In SAP HANA, Data modeling can only be performed on Column store tables. You can’t select Row store tables while create data modeling views on top of HANA database. In below pic, you can see it only shows all column store tables to add in Data Foundation layer of a Modeling view.
Read MoreDifferent platforms where SAP HANA Studio can be installed
SAP HANA studio client is available to run on variety of platforms. Following Operating systems can be used to run HANA Studio client tool:Microsoft Windows x32 & x64 versions with availability for −Windows XPWindows VistaWindows 7Windows 8SUSE Linux Enterprise Server SLES 11: x86 64-bit versionRed Hat Enterprise Linux (RHEL) 6.5Mac OS 10.9 or higher
Read MoreValidity of SAP HANA permanent license after expiry
Note that the validity of your permanent License key is till predefined date and when it is expired, a temporary license key is issued, with a validity for only 28 days. During this period, you have to install a permanent License key again.
Read MoreDeleting all license key in SAP HANA
Try the following SQL query −UNSET SYSTEM LICENSE ALL
Read MoreSystem measurement of SAP HANA system in XML file
In a Single-Database system, proceed as follows to perform a system measurement of your SAP HANA system, which includes the system measurement of the SAP HANA database itself as well as of the relevant options and products −In the SAP HANA Studio, select your database in the navigator and choose Properties in the context menu of the system.Click on the "Export System Measurement" button. A File Browser dialog opens up allowing you to store the result of the system measurement, the measurement report, as an XML file to your local file system.Send this XML file to SAP as requestedThe XML ...
Read MoreLicense expired and SAP HANA system is locked
You need to edit nameserver.ini file. Use the operating system user adm to edit the file /usr/sap//global/hdb/custom/config/nameserver.ini in the file system and add the following lines −[trace] licensing = debugOnce you edit the file → Restart the instance.Check the latest nameserver trace file nameserver_...trc, which is to be found under /usr/sap//HDB//trace/Check the end of that trace file to find the installation and system number in lines.Ex −Licensing AbstractLicenseManager.cpp(00063) : Installation # : "XXXX0XX234X"Licensing AbstractLicenseManager.cpp(00063) : System # : "XXXXXXXXXXXX4234523432434”You have to use this installation number and system number to request a new license key for ...
Read MoreExporting SAP HANA system measurement using hdbsql
To export this details you first need to have INIFILE ADMIN system privilege. Following hdbsql command can be used −SELECT ROUND(SUM(INSTANCE_TOTAL_MEMORY_USED_SIZE) / 1024 / 1024 / 1024, 0) AS DATABASE_MEMORY_USED_IN_GIGABYTES FROM M_HOST_RESOURCE_UTILIZATION RU, M_LANDSCAPE_HOST_CONFIGURATION HC WHERE RU.HOST = HC.HOST AND HC.INDEXSERVER_ACTUAL_ROLE IN ('MASTER','SLAVE');You can also run this command in SQL editor to get this details −
Read More