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 24 of 58
Difference between SAP ERP and SAP S/4 HANA
SAP S/4 HANA stands for SAP Business Suite for SAP HANA and it provides simplified user experience, business processes and data models.SAP S/4 HANA is built on following features −Simplified data modelsFiori User interfaceGuided Configuration
Read MoreVendors for SAP HANA appliance manufacturing
SAP HANA appliance, SAP has partnered with top IT hardware vendors to provide SAP HANA appliance and licensed is provides by SAP. To provide installation and configuration of SAP HANA platform, there are total 11 vendors for HANA appliance manufacturing.IBMDellHPLenovoCiscoFujitsuNECHuaweiUnisysHitachiSGI
Read MoreChecking all alert types in SAP HANA
This can be checked in Alerts tab under SAP HANA Administration. From drop down, you need to select “All Alerts” as shown below −You can also check occurrence of each alert raised in HANA by double click on Alert description. It shows you date and time when alert was previously raised.
Read MoreConfiguring SMTP in SAP HANA for alerting
You can configure SMTP in Alerts tab under SAP HANA Administration. Click on Configure button and you need to enter the below information −Sender EmailSMTP serverSMTP PortRecipient email
Read MoreDefining threshold values for alerting in SAP HANA
You can define this under Configure → Configure Check Thresholds. You have an option to define Low, Medium and High values for these parameters.
Read MoreChecking version of SAP HANA system
In SAP HANA Studio, select HANA system and right click. Select last option Properties from the list as below −In Properties window, navigate to Version history and you can see the version of your SAP HANA system.
Read MoreSAP HANA Release/version with date
From the below table you can match SAP HANA Revision/Version with Release details −
Read MoreDifferent 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 More