SAP Basis Articles - Page 31 of 60

You can use M_LICENSES System View which is used to provide the information on all of the licenses that are installed on this system.

Maximum table name length supported in SAP HANA is 127 characters.

In SAP HANA, a maximum number of tables in a schema are 131072. To create a table, you have to right click on Schema name → New Table

In SAP HANA, you can create a Graphical Calculation view or SQL script based view. The graphical view is easy to develop and you don’t require to be an expert in SQL scripting.When you create a Calculation View, we get an option which type of view we want to create. It is recommended that you should prefer to Graphical Calculation views as you can easily achieve parallel processing and other performance benefits associated with HANA.To create a Calculation view- SQL Script or Graphical view, you have to go to a package and right click → New → Calculation ViewSelect Type ... Read More

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

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.

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.

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: