SAP Desgin Studio Articles

Found 6 articles

Index server in SAP HANA system

Anil SAP Gupta
Anil SAP Gupta
Updated on 18-Jun-2020 2K+ Views

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

Adding multiple views in SAP HANA Analytic Privilege

SAP ABAP Expert
SAP ABAP Expert
Updated on 12-Mar-2020 412 Views

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.

Read More

Checking various details in SAP HANA in multitenant environment

SAP Developer
SAP Developer
Updated on 06-Mar-2020 158 Views

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.

Read More

\\nAnalyzing code coverage results in SAP Design Studio on top of HANA\\n

John SAP
John SAP
Updated on 13-Dec-2019 123 Views

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

Read More

Functions of Index server in SAP HANA system

Anil SAP Gupta
Anil SAP Gupta
Updated on 30-Jul-2019 600 Views

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
Showing 1–6 of 6 articles
« Prev 1 Next »
Advertisements