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

When you click on Data Preview, you can see these optionsAnalysisDistinct ValueRaw DataWhen you use an Analytic view, under Analysis tab you can see both Attributes and Measures under Available objects and it can be dragged to Label and Value axis.Similar way you can “Distinct value” tab to see the ... Read More

This can be easily checked in Details pane. You need to select column name for which you want to check Properties of a column → right click → Properties

Following are the key points about using Derived view in SAP HANAThe derived attribute view will be similar in all the characteristics as the base view (except the name) It is not possible to edit any semantic/data foundation design in the derived attribute view. When there is any change in the base ... Read More

In SAP HANA system, you can see all the packages under Content tab in HANA studio. All HANA modeling objects are created inside packages. Packages can be used for migrating modeling views in HANA system.You can also create a sub-package, and different HANA modeling views- Attribute view, Analytic View and ... Read More

In SAP HANA Administration Perspective, you can select your HANA system in Studio and navigate to Administration option at the top.When you go to Alerts tab, you can see all the current alert. You can see Description of alerts, date and time when an alert is raised and priority of ... Read More

It is also possible to compress a table in SAP HANA system manually by executing the following SQL statement.UPDATE "table_name" WITH PARAMETERS ('OPTIMIZE_COMPRESSION' = 'YES')This results in deciding whether a compression is required or an existing compression can be optimized. In this scenario, HANA system uses most suitable compression algorithm.When ... Read More

Common system schema are −_SYS_BIC_SYS_REPO_SYS_BI_SYS_XS_SYS_STATISTICS and many more

In SAP HANA SPS07, it has been extended to MSSQL server and Oracle database and write operation was permitted to perform on remote data sources.Following remote systems are allowed under Smart Data Access with Write operation in SAP HANA SPS07 −SAP HANASybase ASESAP Sybase IQTeradata 13.0 or higherApache Hadoop 2.3MSSQL ... Read More

In below table, you can see the list of remote data sources that are supported under SAP HANA Smart Data Access for SPS06 and SPS07 and the operations supported −SAP HANA VersionsSPS06SPS07 or higherSupported Data Sources under Smart Data AccessSybase ASE, SAP Sybase IQ 15.4 ESD 3 and Version 16.0 Apache ... Read More