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 27 of 58
Using an Aggregate function in SAP HANA
You can use an aggregate function to get the same. Common aggregation functions are −Average() − returns the average of the numeric values in a given columnSelect Average (Sales) from table_name where Column1=’ABC’;
Read MoreExecuting a table creation using UI in SAP HANA Studio
To execute the table creation, click on the green arrow mark on the top right corner. You will get a confirmation as below that a column table has been created in Schema AA_HANA11 with name DEMO_TABLE −Statement 'create column table "AA_HANA11"."DEMO_TABLE"( "CUST ID" INTEGER null, "CUST NAME" VARCHAR (10) null)' successfully executed Affected Rows:0 in 5 ms 884 µs.
Read MoreComponents in SAP HANA multi-system architecture
Each HANA system contains multiple serves inside, which are responsible to perform different functions. Index Server is heart of SAP HANA system which contains SQL/MDX processor for handling SQL statements. Key component includes −Index ServerPreprocessorName ServerStatistics ServerHANA XS EngineSAP Host AgentSAP Solution Manager Diagnostic AgentSAP HANA Studio + RepositorySAP HANA Software Update Manager SUM
Read MoreCreating virtual tables from remote source in SAP HANA
When a remote source is added, you can see all the existing tables under that data source in HANA Studio. Next is to create virtual table mapping to data in the remote data sources in SAP HANA Studio. This can be done using GUI option.To add a table as a virtual table, you need to navigate to remote data source → Schema name → Table name → Right-click and Add as Virtual TableBelow shows how you can add a table as a Virtual Table using HANA Studio.
Read MoreContent of property_orcl.ini file in SAP HANA Smart Data Access
When you create a new remote data source, SAP HANA Smart data access parse the respective property configuration file. With the use of config file- features, function mappings, data type mappings, and other properties will be linked together with the data source. This decides the communication between the SAP HANA and the data source.You can see part of the content of property_orcl.ini shown below −
Read MoreDifferent ODBC connection types under SAP HANA Smart data access SDA
You can check the following example to create a new remote source −CREATE REMOTE SOURCE TEST_11g ADAPTER “odbc” CONFIGURATION FILE ‘property_orcl.ini’ CONFIGURATION ‘DSN=oral11g_lnx’ WITH CREDENTIAL TYPE ‘PASSWORD’ USING ‘user=username;password=password′;In above SQL statement, can be one of − ASEODBC, IQODBC,TDODBC, HIVEODBC,ODBC. Obviously, ASEODBC is for Sybase ASE as data source, IQODBC is for Sybase IQ, TDODBC is for Teradata Database, HIVEODBC is for Hadoop.
Read MoreConnecting to MSSQL, MaxDB using SAP HANA Smart Data Access
In SAP HANA SPS07, following data sources are supported under Smart data access −Sybase ASESAP Sybase IQTeradata 13.0 or higherApache Hadoop 2.3MSSQL 11Oracle 12cWhen you click on the Adapter name while creating a new remote data source, you can see a list of all supported databases.You can also see in the above snapshot that all databases use the ODBC connection for a remote data sources.
Read MoreResetting a customized Perspective in SAP HANA Studio
Yes, if you customize a perspective, and you want to reset it, you can select Reset PerspectiveHere you have an option that allows you to perform following options on a Perspective −Customize PerspectiveSave PerspectiveReset PerspectiveClose PerspectiveClose All Perspective
Read MoreStarting SAP HANA Studio with immediate system logon
Yes, to perform an immediate login you have to navigate to Installation directory and use the following start parameters −-h Host name-n Instance number-u User nameUser name with special characters should be enclosed in double quotations (“”).Windows OShdbstudio.exe -h hanademo -n 03 -u HANAADMINhdbstudio.exe -h hanademo -n 03 -u "&hanatest"Linux OShdbstudio -h hana -n 03 –u HANAADMINhdbstudio -h hana -n 03 -u "&hana"Mac OSopen -a /Applications/sap/hdbstudio.app --args -h hana -n 03 -u HANAADMINopen -a /Applications/sap/hdbstudio.app --args -h hana -n 03 -u "&hana"Once you run above from command line, this will open HANA Studio. If you are prompted to enter password ...
Read MoreExporting list of all SAP HANA systems in XML file
Yes, it is possible to export a list of your SAP HANA systems from the SAP HANA studio as an XML file and then it can be imported to another instance of the SAP HANA studio or use it as a system archive to which other users can link.This can be performed by following below steps −From the main menu, select File Export... .Expand the SAP HANA folder and choose Landscape.Choose Next.Select the systems you want to export and enter a target file location.Choose Finish
Read More