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 Expert
Page 7 of 12
Checking Compression ratio of a table in SAP HANA
To check the Compression ratio for a table, you can navigate to Table Definition. Go to Runtime Information.To see Compression Ratio, go to Columns tab. You can see the compression ratio in the Main Size Compression Ratio [%] column.
Read MoreChecking data disk, log disk and Trace disk in SAP HANA
In SAP HANA Studio, you can use System Monitor to view details of your SAP HANA system at a glance. It tells about Data Disk, Log disk, Trace Disk, Alerts on resource usage with priority.To open System Monitor, select HANA system in System pane and click on the icon as shown below −Once you scroll on the right side, you can see all the information of your HANA system as you mentioned including CPU% and used memory.
Read MoreConsuming Graphical calculation view via SDA
Note that you can create Graphical Calculation Views using SMART Data access tables and you can also push aggregations to remote database.
Read MoreSQL statement to create a Restricted user in SAP HANA
It is very simple. You can create a Restricted user with below query −CREATE [RESTRICTED] USER [] [ ] [ ] [ ] [ ] [ ] []In above SQL query, you have to pass following parameters −Specifies a database user in another tenant database as the remote identity of the database user being created.Specifies the user password of the user being created.Defines an external identification mechanism.Defines an external identity that is used to authenticate the user.
Read MoreSteps in installing SAP HANA Studio
SAP HANA studio runs on the Eclipse platform 3.6. To install SAP HANA Studio, it is two-step process.First to install Eclipse as per Operating SystemSecond is to install HANA software plugin in Eclipse
Read MoreInstalling SAP HANA software plugins for Eclipse
Once Eclipse installation is done, open software and Navigate to Help → Install New SoftwareWhen you click on Install New Software, a new window will open and you can perform HANA plugin installation.
Read MoreNavigation in SAP HANA Studio client
When you login to SAP HANA Studio first time, it doesn’t have any system added to it. You can add multiple local/remote HANA systems to Studio and manage them.On left side, you have system pane where you can add multiple systems in Studio. When you add a system in HANA Studio, it consists of different folders. Each folder in HANA system performs different functions. We will cover the details later in this tutorial. At bottom you have Properties pane and Job Log pane. In Job Log pane you can check the status of each action that you perform in HANA ...
Read MoreSAP HANA Modeling Perspective in HANA Studio
On right side you have Modeling Perspectives, under which you can see multiple options inside it. In SAP HANA Studio you have the options to access different perspectives that can be used to perform variety of different functions.You can see HANA Modeler Perspective in below pic −You can also perform a search on different options in Perspective by typing in search bar below Quick View.
Read MoreConfiguring SAP HANA Perspective shortcuts
This can be done using the Shortcuts tab of the Customize Perspective dialog. To configure shortcuts: Switch to the perspective that you want to configure.Select Window → Perspective → Customize Perspective →Open the Shortcuts tab and choose the sub menu whose shortcuts you want to edit.Use the Categories tree to turn groups of related shortcuts on or off, or select categories to work with individual menu items in the Shortcuts list.Click OK to cause the changes to take effect.
Read MoreTCP/IP port in SAP HANA to access Index server
For Index Server Instance No: 03Port # 30315Standard format: 3NN15 These port numbers are used for index server for SQL/MDX access port for standard database access. You should enable the access on these ports for all database clients. By default Index server Port no is 30015.The standard port number format for different instances 3NN15, NN- represents the instance number of HANA system to be used in client tools.Port 3615 should be open to connect to DatabasePort 31015 Instance No 10Port 30015 Instance No 00SSh port should also be opened.
Read More