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
SAP HANA Articles
Page 38 of 58
Using 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 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 MoreExporting delivery unit based on time filter in SAP HANA
While export a delivery unit, you can restrict the export through “Filter by time” which means Information views, which are updated within the mentioned time interval will only be exported.After selecting Delivery unit from drop down list, you have to select checkbox and then enter the Time interval- From and To date.In below snapshot you can see we have highlighted “Filter by Time” option and user can select this checkbox to use time filter during export.
Read More