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 19 of 58
Adding multiple views in SAP HANA Analytic Privilege
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.
Read MoreConsuming Attribute/Analytic view in a Calculation view in SAP HANA
You can use Calculation View without Star Join to consume Attribute and Analytic view in SAP HANA. To use these views, you can add Projection node and add the views to the projections.In this, you can see how to create a Calculation view without Star Join. To add Project node, you can simply drag it from the right side.
Read MoreUsing different Projection options in Calculation view in SAP HANA
When you set data category as CUBE, the default node is aggregation. When you set data category as Dimension, default node is Projection.You can change the Default node by selecting Star Join checkbox.When you finish selection for data category, you get a default node under Scenario pane. Check the below snapshot:
Read MoreHiding specific data in HANA Modeling View
Analytic Privileges are used to limit access to HANA Information views. You can assign different types of right to different users on a different component of a View in Analytic Privileges.When it is required that data in the same view should not be accessible to other users who do not have any relevant requirement for that data. This can be performed using Analytic Privileges in HANA.
Read MoreDifferent Nodes option in a Calculation view in SAP HANA
In SAP HANA Calculation View, following nodes are available −JoinUnionProjectionAggregationRank
Read MoreChecking various details in SAP HANA in multitenant environment
You can check the landscape of HANA system, navigate to Landscape tab in HANA studio. Services show all the services running on HANA system.The following screenshot shows SAP HANA system and all the key services running under system Landscape for the same system.You can see the service name corresponding to each server in HANA system landscape.
Read MoreFunctional difference of using row vs column store in SAP HANA
The following table explains few points about the use of row vs column store tablesTo know more about row and column store tables, refer the below link: SAP HANA is optimized for column storage.https://help.sap.com/doc/6b94445c94ae495c83a19646e7c3fd56/2.0.00/en-US/bd2e9b88bb571014b5b7a628fca2a132.html
Read MoreChecking 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 More