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 8 of 12
SAP 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 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 MoreDefining validity of initial password in SAP HANA
This can be defined under Password policy → Miscellaneous
Read MoreCreate User SQL in SAP HANA database
You can achieve this by running the below SQL query −>CREATE USER TEST password “Welcome1$$” VALID FROM ‘2017-12-05 11:00:00’ UNTIL ‘2018-12-08 12:00:00’; CREATE USER DUMMY password “Welcome1$$” VALID FROM NOW UNTIL FOREVER;Note that password passed in this SQL should meet password policy of SAP HANA system otherwise user creation will be failed.
Read MoreChecking existing password policy of SAP HANA system
You can check this information under New User in SAP HANA. The below snapshot shows the New User dialog in SAP HANA Studio and the password rule that is displayed when hovering over the password field.
Read MoreSetting password expire notification in SAP HANA
Parameter password_expire_warning_timeDefault Value 14 (days)Parameter definitionNotification is transmitted via the database client (ODBC or JDBC) and it is up to the client application to provide this information to the user.If you enter the value 0, the user does not receive notification that his or her password is due to expire.The system also monitors when user passwords are due to expire and issues a medium priority alert. This may be useful for technical database users since password expiration results in the user being locked, which may affect application availability. It is recommended that you disable the password lifetime check of technical ...
Read More