SAP HANA Articles - Page 28 of 58

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.

You have the following Operators that can be used to define restrictions

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.

Yes, when an Analytic Privilege is defined you have an option of using it for a specific time period. You have an option of defining Privilege validity where you can pass validity details.You can also opt for SQL Editor or Dynamic where you can pass different validity conditions. When you use SQL option you can pass a SQL query and it will be set as per SQL queryFor Dynamic option, you can pass Stored Procedure to define validity.

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

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.

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.

In SAP HANA Calculation View, following nodes are available −JoinUnionProjectionAggregationRank

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: