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

Analytic Privilege is created inside packages under Content tab.Analytic Privileges are only applied to attributes in an Information View. We cannot add measures to restrict access to Analytic privileges.Analytic Privileges are used to control read access to SAP HANA Information views. You can also hide an information from the specific time period.

SAP HANA Modeler Views can only be created on the top of Column based tables. Storing data in Column tables is not a new thing. Earlier it was assumed that storing data in Columnar based structure takes more memory size and not performance Optimized.With the evolution of SAP HANA, HANA used column-based data storage in Information views and presented the real benefits of columnar tables over Row based tables.Column StoreIn a Column store table, Data is stored vertically. So, similar data types come together as shown in the example above. It provides faster memory read and writes operations with help ... Read More

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