Found 8 Articles for SAP Desgin Studio

Functions of Index server in SAP HANA system

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:21
Index Server is heart of SAP HANA system and is responsible for processing all SQL statements sent to HANA database. This server contains SQL/MDX Processing engine that is responsible to process and analyze data in HANA db.Index Server also contains Persistence layer for scalability and restoration of the system. In case of system failure, power failure or database corruption, Persistence layer is responsible for the restoration of HANA system to last save point.When you are running complex and large calculations, and there is a system failure Persistence layer is used to ensure that transactions are either fully executed or complete ... Read More

Replacing/Installing a license in SAP HANA

SAP Expert
Updated on 12-Mar-2020 11:25:33
You can get a permanent license key from SAP Marketplace under Keys and Requests tab. To install a new key, you have to click on Install License key option and then you need to browse the path of license key saved on your system.You can also delete an existing license from there.When you click on Install, you will be prompted to pass the path of HANA license key. You need to browse and then you can setup a new key. When you click on Install, you will be prompted to pass the path of HANA license key. You need to browse ... Read More

Checking all tables and schema in SAP HANA

Updated on 18-Jun-2020 08:00:36
When you add a HANA system in HANA Studio, you can see different tabs under system pane. Each pane has different object types of HANA system.To see the list of all schema and tables, you need to navigate to Catalog tab.Other available tabs in HANA Studio includes:BackupCatalogProvisioningContentSecurityYou can check under table type- if a table is row store or column store. On right top corner, it is mentioned.New tables can be created using the two methods given below −Using SQL editorUsing GUI optionThe new table can be created using SQL Create Table statement −Create column Table Test1 (    ID ... Read More

Index server in SAP HANA system

Anil SAP Gupta
Updated on 18-Jun-2020 07:44:45
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

Checking various details in SAP HANA in multitenant environment

SAP Developer
Updated on 06-Mar-2020 06:13:28
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.

Adding multiple views in SAP HANA Analytic Privilege

Updated on 12-Mar-2020 08:16:49
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.

Analyzing code coverage results in SAP Design Studio on top of HANA

John SAP
Updated on 13-Dec-2019 06:36:46
To consume HANA view, you need to start by creating an ODBC connection to SAP HANA system through odbcad32.exe.Next step is open SAP Design Studio and add a data source by connecting to HANA system and open view as below:This way you can view your SAP HANA view in Design Studio, now to analyze code coverage results, you can refer this SAP blog for step by step process:SAP blog