Use of SQL/MDX processor in SAP HANA Index server

SQL/MDX processor in HANA system processes all SQL and MDX statements executed in HANA system. SQL statements are generated for all the tables, schemas and MDX statements are raised for OLAP data processing. SQL stands for Structured Query Language and is Relational database language to manage two dimensional objects in HANA db.

MDX stands for Multi Dimension Expression and is an OLAP language for processing MDX statements for multidimensional models.

SQL/MDX Processor directs all the statement to relevant engines for processing and Engine optimization. It is used for authorization management in executing queries and Error handling while processing SQL/MDX statements.

Following functions are performed by SQL/MDX processor under Index Server −

• Efficient processing of SQL/MDX statements and divide all the statements and direct them to correct engines for processing.
• Procedure Calls are handled by Stored Procedure Processor and convert BW OLAP cubes to HANA optimized cubes for performing calculations and aggregations and parallel processing.
• Error handling for efficiently handling all the transactions in HANA db.

Anil SAP Gupta

Published on 21-Feb-2018 18:05:00

• Related Questions & Answers
• Index server in SAP HANA system
• Functions of Index server in SAP HANA system
• Using MDX provider in SAP HANA
• TCP/IP port in SAP HANA to access Index server
• Difference between clustered index and non-clustered index in SQL server
• Difference between Open SQL, Native SQL in SAP HANA
• Sort data in SQL using Dynamic SQL in SAP HANA
• Use of savepoints in SAP HANA
• Use of SAP Host Agent in SAP HANA
• Create table SQL query in SAP HANA
• Create User SQL in SAP HANA database
• Create View SQL in SAP HANA database
• Data Replication from SAP PO to SQL Server
• Use of SAP HANA Live browser
• Opening SQL editor using SAP HANA Studio