Anil SAP Gupta has Published 115 Articles

Using different Engine types in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 30-Jul-2019 22:30:21

127 Views

It will use both OLAP and Join engine. The join between the FACT and DIM will be executed in the OLAP engine and joins inside the attribute views will be executed in the JOIN engine so both the engines will be used.

Handling failed transactions in SAP HANA system

Anil SAP Gupta

Anil SAP Gupta

Updated on 30-Jul-2019 22:30:21

143 Views

In SAP HANA system, Session and Transaction Manager is responsible to keep track of all the executed transactions in HANA database. It includes both running transactions and closed transaction. When a transaction in HANA system is failed due to any reason, Transaction Manager informs corresponding engine to handle the error.Session ... Read More

Handling user requests for applications based on HANA system

Anil SAP Gupta

Anil SAP Gupta

Updated on 30-Jul-2019 22:30:21

87 Views

It consists of various components as mentioned above for processing of SQL statements from application users hosted on the top of HANA system.User requests via user interface/web browsers are sent to Web server hosting application which is communicated to SQL/MDX Processor in form of SQL queries. These are further segregated ... Read More

Handling system failure, database corruption in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 30-Jul-2019 22:30:21

307 Views

Persistence layer is used in case of system failure, database corruption or power failure to restore the database to most recent save point in HANA. Persistence Layer is responsible for data and transaction log backup and also to store configuration of HANA system.Backup of data and transaction log files are ... Read More

Performing text data analysis and Search capability in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 30-Jul-2019 22:30:21

75 Views

Preprocessor server provides text data analysis and search capabilities in HANA system. Preprocessor server is used by Index search to analyze the text data and to perform any search on the text data. This server is used to extract the information based on text search capabilities in HANA system.

Performance data of servers in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 30-Jul-2019 22:30:21

119 Views

Statistics server is used to manage health of your HANA system. You can take information related to status, performance consumption of resources from all the servers in your system landscape. You can also pull the reports related to performance of server components for analysis.

Data Compression in SAP HANA system

Anil SAP Gupta

Anil SAP Gupta

Updated on 30-Jul-2019 22:30:21

294 Views

SAP HANA system combines OLAP and OLTP processing into a single in-memory database and it removes the disk bottlenecks and offering groundbreaking performance. This ACID-compliant, in-memory columnar database stores provides data compression up to 11 times as compared to other conventional database, parallel processing across multiprocessor cores, and supports single ... Read More

How to get some customization done in SAP HR system?

Anil SAP Gupta

Anil SAP Gupta

Updated on 30-Jul-2019 22:30:20

100 Views

I am not sure that there exists something in SAP HR in pure form which supports your use case. But you can handle the scenario as mentioned by you by making some changes here and there.There exists an infotype ‘Contracts’ with SAP HR which stores the type of employment of ... Read More

Pull a list of Functional Location from SAP using BAPI

Anil SAP Gupta

Anil SAP Gupta

Updated on 30-Jul-2019 22:30:20

194 Views

After you set objRfcFunc, try this before you call this and this will include these parameters.With objRfcFunc.tables("funcloc_ra")    If .RowCount < 1 Then .Rows.Add    .cell(1, 1) = "I"    .cell(1, 2) = "EQ"    .cell(1, 3) = "Your Func Loc"End With

How much size does the VARCHAR takes- the defined size or the size of the content in SAP HANA?

Anil SAP Gupta

Anil SAP Gupta

Updated on 30-Jul-2019 22:30:20

81 Views

I am not sure whether someone can get you exact answer, SAP is not open source and implementation details and bits are not known to many except the creators and few others. If I go with the standard definition, for storage you will require the size of length of the ... Read More

Advertisements