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 John SAP
88 articles
nAnalyzing code coverage results in SAP Design Studio on top of HANA
To analyze code coverage results in SAP Design Studio on top of HANA, you first need to establish a connection to your SAP HANA system and then visualize the data through Design Studio's reporting capabilities. Setting Up ODBC Connection To consume HANA views, you need to start by creating an ODBC connection to SAP HANA system through odbcad32.exe. This creates the necessary data source connection that Design Studio will use to access your HANA database. Connecting Design Studio to HANA The next step is to open SAP Design ...
Read MoreDifferent ways of loading data to SAP HANA using Information Composer
In SAP HANA system, you can load in following ways using SAP HANA Information Composer −Data from Filesystem − This options is used to upload data using .xls, .csv file directly to HANA database.Data from clipboard − Other way is to copy data to clipboard and copy from there to HANA database.
Read MoreSystem requirement to install SAP HANA Information Composer
You should setup a separate server for HANA Information Composer and it should be set next to your HANA system. Following server, a requirement should be met −Server Requirements −At least 2GB of available RAM is requiredJava 6 (64-bit) must be installed on the server
Read MoreAccessing SAP HANA Information Composer
You can try accessing below link if it is accessible −http://:8080/IC or https://:8443/ICTo access Information Composer, you should have Microsoft Silverlight installed and activated as an add-on to the web browser.
Read MoreRedeploy option in SAP HANA Modeling
Redeploy option is available under SAP HANA Modeler Perspective −
Read MoreActivation modes under SAP HANA Modeler Activate option
This option is used for bulk activation of inactive objects in HANA repository. You have the following Activation modes −Stop activation incase of inconsistencies in affected objectsActivate and ignore the inconsistencies in affected objects
Read MoreChecking status of Auto Documentation in SAP HANA
When you use the Auto documentation feature in SAP HANA, you can navigate to job log → Current tab and select Job-type Auto Documentation and double click.You can see details of Auto Documentation job details and Status- shows a green tick mark as successful.
Read MoreExecution time while running a SQL query in HANA Studio
When a SQL query is executed, you can see the confirmation that the query is executed in time duration and also with server processing time. In this scenario, you can see the time taken by SAP HANA processor to create a new table in the HANA database as below −“Statement 'Create Table Demo_HANA ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) )' successfully executed in 3 ms 117 µs (server processing time − 2 ms 458 µs) - Rows Affected − 0”
Read MoreCreate table SQL query in SAP HANA
In below SQL query, you can see a create table command in SQL editor to create a new table with name-“Demo_HANA” in schema name AA_HANA11 with column names- ID and NAME and corresponding data types. In the below example, we have defined ID as “Primary Key” which means it is unique and not null.Create Table Demo_HANA ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) );
Read MoreViewing data in a table in SAP HANA database
When the data is entered, you can see the data in this row-based table by going to the Data Preview option. To see the data, right-click on table name → Open Data PreviewWhen you run Data Preview of a table, you can see full data under the Raw Data tab. You can also view distinct values and perform some analysis.
Read More