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
SAP HANA Articles
Page 54 of 58
Default location for installation of SAP HANA Studio
You can install SAP HANA studio on Linux platform without Root user. In Windows platform, you can perform the installation without administration rights but it will be available only to the user who has installed it.Default Location on Window Platform: C:\Program Files\sap\hdbstudioDefault installation Location under MAC OS: /Applications/sap/hdbstudio (old) or /Applications/sap/hdbstudio.app (new)Default installation Linux x86 64 bit: /usr/sap/hdbstudio
Read MoreUsing TCP/IP ports for accessing SAP HANA database
To access HANA system on client tools, you need to open different ports to database for these clients. These ports refer to different servers and application service in HANA system.
Read MoreSQL Operation supported in SAP HANA SPS06 SDA
With use of SAP HANA SPS06 Smart Data Access, you can only perform SELECT operation on virtual tables moved using new remote data source.
Read MoreSQL Operation supported in SAP HANA SPS07 SDA
With use of SAP HANA SPS06 Smart Data Access, you can only perform Select, Insert, Update and Delete operation on virtual tables moved using new remote data source.
Read MoreGetting 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 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 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 MoreExecuting a SQL query in SAP HANA Studio
To run the query, click on green arrow button on top right corner or press F8.
Read More