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 column name length supported in a table in SAP HANA is 127 chars.

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. ... Read More

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 ... 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 ... Read More

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.

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 ... Read More

Note that you can create Graphical Calculation Views using SMART Data access tables and you can also push aggregations to remote database.For more details, you can refer this blog to Smart Data Access: The power of Smart Data Access (SDA) with SAP HANA SP08http://www.saphanacentral.com/2015/03/the-power-of-smart-data-access-sda-with.htmlRead More

It is very simple. You can create a Restricted user with below query −CREATE [RESTRICTED] USER    []    [ ]    [ ]    [ ]    [ ]    [ ]    []In above SQL query, you have to pass following parameters −Specifies a database user in ... Read More