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.

SAP HANA studio is an Eclipse-based tool and provides a central development environment and an administration tool for HANA database. These are the features of HANA Studio client −HANA Studio is a client tool, which can be used to access local or remote HANA system. You can use HANA Studio for performing HANA Administration, HANA Information Modeling and Data Provisioning.You can use SAP HANA Studio on Microsoft Windows 32 and 64-bit versions of Windows XP, Windows Vista, Windows 7 platforms.SAP HANA Studio provides perspectives to work on the following HANA features. You can choose Perspective in HANA Studio from the following ... Read More

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

SAP HANA is a combination of HANA Database, Data Modeling, HANA Administration and Data Provisioning in one single suite. Following are key features of SAP HANA −SAP HANA is a combination of software and hardware innovation to process a huge amount of real-time data. Based on multi-core architecture in the distributed system environment. Based on column type of data-storage in the database and hence facilitates data compression, and on the fly aggregation.Storing Data in Columnar based table has following benefits −Data CompressionFaster read and write access to tables as compared to conventional Row based storageFlexibility & parallel processingPerform Aggregations and Calculations at ... Read More

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:

When you use Calculation view with Star Join, you have the following benefits:It simplifies the design process.You need not create Analytical views and Attribute Views and directly Fact tables can be used as Projections.3NF is possible with Star Join.

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.

The fact table contains measure values and primary key for Dimension tables. Dim tables contain master data. Fact and dimension table are joined in HANA Modeling to achieve some business logic.Example of Measures − Number of unit sold, Total Price, Average Delay time, etc.Dimension Table contains master data and is joined with one or more fact tables to make some business logic. Dimension tables are used to create schemas with fact tables and can be normalized.Example of Dimension Table − Customer, Product, etc.Suppose a company sells products to customers. Every sale is a fact that happens within the company and ... Read More