Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by Anil SAP Gupta
Page 9 of 10
Getting data in front-end tools from SAP HANA database
In SAP HANA database, you have different system schema. _SYS_BIC schema in SAP HANA database is used to store column views of all the activated objects in HANA repository. When an object is created and activated (HANA Modeling views, Stored Procedures), run time objects are saved under _SYS_BIC/Column views in database.These column views are used by front-end tools like BusinessObjects to get the data in a query.
Read MoreUpdating configuration property file in SAP HANA Remote source
Note that while modifying or creating the property configuration file, only the property which is different from default value needs to be set. The mistake in property configuration file may result in incorrect action or result of data source.
Read MoreFunctions of Index server in SAP HANA system
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 MoreUsing different Engine types in SAP HANA
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.
Read MoreHandling failed transactions in SAP HANA system
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 Manager is responsible to manage open and closed sessions and to authorize all the transactions executed in HANA db.
Read MoreHandling user requests for applications based on HANA system
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 to different data engines in Index server according to query types.Session and Transaction Manager authorize SQL transactions and keep track of all the transactions either completed or running in the system.
Read MorePerforming text data analysis and Search capability in SAP HANA
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.
Read MoreHow to get some customization done in SAP HR system?
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 the employee like permanent or contract. You can take care of this type by flipping the status of the employee type by some third party service. Once the employee resigns then rehire him as a contractor but create a dummy pay roll so that it does not gets picked up ...
Read MoreHow much size does the VARCHAR takes- the defined size or the size of the content in SAP HANA?
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 data plus number of bytes for header information. So as per your example it will require 9 + 2 (for header) = 11 overall for storage.
Read MoreHow to switch between different views in ALV Grid in SAP ABAP?
You can achieve something similar to your requirement. Firstly, you need to fetch the layout key information from the layout object. You can look for disvariant to get the key information if not able to find. Then use the key information to specify different handles for different data types. So basically you are having different layouts for different inputs or data types. As soon as you change the data type, the handle will do its job and display will change accordingly. Hope it helps!
Read More