Index server contains SQL/MDX processor to handle query statements for the database. When SQL or MDX is fired for SAP HANA system, an Index Server takes care of all these requests and processes them. All HANA processing takes place in Index Server.Index Server contains Data engines to handle all SQL/MDX statements that come to HANA database system. It also has Persistence Layer that is responsible for durability of HANA system and ensures HANA system is restored to most recent state when there is a restart of system failure.Index Server also has Session and Transaction Manager, which manage transactions and keep ... Read More

SAP HANA 1.0 can replicate data only from few of data sources and only in few formats using Sybase Replication. You can perform batch loading using SAP Data Services and it is optimized only for Business Object 4.0 for reporting.

In SAP HANA Modeling, Graphical Information Views are faster as compared to SQLScript in almost every scenario and also Graphical Information Views are easier for others to understand, remodel and change.There are scenarios where you need SQLScript, but it shouldn’t be viewed as a general-purpose solution to modeling problems.Note:It is never recommended that you code a Calculation View with SQL Script and use it inside another Calculation View with CE Functions as it results in a very bad performance.

You can check the landscape of HANA system, navigate to Landscape tab in HANA studio. Services show all the services running on HANA system.The following screenshot shows SAP HANA system and all the key services running under system Landscape for the same system.You can see the service name corresponding to each server in HANA system landscape.

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 you run the above SQL command, compression status remains the same. You can also force the database to reevaluate compression using the following SQL status UPDATE "AA_HANA11"."SHOP_FACTS" WITH PARAMETERS ('OPTIMIZE_COMPRESSION' = 'FORCE')

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, 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

In SAP HANA, there are various methods and algorithms that you can use to store data in Column based structure- Dictionary Compressed, Run Length Compressed and many more.In Dictionary Compressed, cells are stored in form of numbers in tables and numeral cells are always performance optimized as compared to characters.In Run length compressed, it saves the multiplier with cell value in numerical format and multiplier shows repetitive value in the table.Compression is calculated using Compression factor. Compression factor refers to the ratio of the uncompressed data size to the compressed data size in SAP HANA.In SAP HANA, Compression is performed ... Read More

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

Yes, you can define Analytic Privilege for multiple views in a single object. When you add multiple HANA views, you can find all Attributes: Select attributes to assign analytic privileges.