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
SAP HANA Articles
Page 39 of 58
Using SAP connector 3.0 on an MVC application
Try adding a new row before calling SetValue. Please check the below:employeeHoli.Append(); employeeHoli.SetValue("ColumnName", "0000345");You use a table parameter that can hold multiple lines. You have to append the above lines that will return some structure and you can fill that structure.
Read MoreDenormalization of dimension tables in InfoCube in SAP BW
Note that In Data Warehouse, data load is less frequent as compared to data read. If you use normalized tables that result more number of joins and hence when you run multiple read statements on DW system, it effects the performance considerably.When you are not using normalized tables, the response time of queries are improved however load time and memory space is increased.You can refer below link to get advantages of denormalization in database and comparison with normalized tables.http://searchdatamanagement.techtarget.com/definition/denormalization
Read MoreIdentify SQVI queries formed by a user in SAP project
You need to use the function RSAQ_REMOTE_QUERY_CALL_CATALOG for fetching the list of SQVI queries for a user.
Read MoreSort data in SQL using Dynamic SQL in SAP HANA
In order to execute dynamic SQL in your stored procedure, you need to use the ‘EXECUTE IMMEDIATE’ statement. You can use SQL as shown below to execute it:EXECUTE IMMEDIATE 'SELECT FROM ' || : || ' DESC';Another thing to notice over here is that if you are planning to use the table type in the final select statement with dynamic SQL, it will not work. Dynamic SQL does not support table type in select. What you can try as a work around is that you can dump the data in a temporary table before using it in the ...
Read MoreNegation logic in SAP ABAP
You can use BOOLC to sort out your requirement. It should be like thisVarbool= BOOLC( NOT Logical operation)But be clear in your implementation, as ABAP does not have true bool type. It does not store true or false in bool type rather it stores ‘X’ or ‘’ for true and false respectively.You can also try to use XSDBOOL instead of BOOLC.
Read MoreProblem with division as output is either 0 or 1 when using ifthenelse condition in ABAP program
The problem is that your second parameter is 0 which is an integer, so the output always comes as an integer as ifthenelse takes data type from the second parameter. So, in your case, if the answer is less than .5, it is converted to zeroes and in case more than .5, it is converted to 1. You would require to use cast for the second parameter to convert it to decimal data type as follows ifthenelse(Query.Den= 0, cast(0, 'Decimal(16, 02)'), Query.Num / Query.Den)
Read MoreDeleting from temporary table in SAP HANA
The temporary tables are session specific. So you would require to use truncate instead of delete as followstruncate table #temptable;Also, could you please check your release? In the recent releases, delete also works fine. Here is an example:Drop table #temptable; Create local temporary table #temptable(id integer, str nvarchar(30)); Insert into #temptable values (1,'abc'); Insert into #temptable values (2,'xyz'); Select * from #temptable; --> returns 3 rows Delete from #temptable; Select * from #temptable;--> returns 0 rows
Read MoreSetting up a JDBC connection to remote SAP HANA system
You are using the correct Port number for instance number “00”. Port number 300315, here 00 represents instance number of your HANA system.Try using HANA client jar file ngdbc.jar instead of SAP Jar file.try { Class.forName("com.sap.db.jdbc.Driver"); String url ="jdbc:sap://xx.x.x.xxx:30015/DBNAME"; //IP Address of HANAsystem followed by Port number String user ="user"; String password = "password"; Connection cn = java.sql.DriverManager.getConnection(url, user, password); ResultSet rs = cn.createStatement().executeQuery("CALL Test.STORED_PROC"); // ...Enter the action here } catch(Exception e) { e.printStackTrace(); }
Read MoreFinding minimum value across different columns in SAP HANA
You need to use LEAST instead of min as below:“SELECT ID, LEAST(DAY_1, DAY_2, DAY_3) FROM ...” Please make sure that none of the values in your column in “NULL”.
Read MoreCall screen on clicking the button in SAP ABAP
Please follow the steps below to make it functional.First, open the screen painterNow, double click on the button you want to make functionalAbove “Context Menu Form", you will find a field to enter Functional code where you enter the functional code.This will convert your button to functional trigger theOK code which will run the dynpro “PROCESS AFTER INPUT". Now add a PAI module to this dynpro which indicates the screen you want to call when the button is clicked. Below is the examplecase sy-ucomm. " the ok code when 'Functioncode’. call screen screennumber. when others. ...
Read More