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 49 of 58
Fetch max date and other field from the same row of a table grouped by other fields in SAP HANA
You have done partially correct but just missed one step further to get the desired result. The case where after grouping you need to pick one of the rows from the results, use rank number or rank function.You need to partition your data based on your requirement, then order them as per your requirement again then pick the desired row.ExampleFor e.g. partition your data by Item Number and Shop Id. Then order them in descending order of Date column. Then pick the row with row number as 1select date, Order_Number from (SELECT *, row_number() over ( partition by ...
Read MoreIs Pivot available in SAP HANA
As per my understanding, for requirement #1 you can do something as below:SELECT Prod.Product_ID, JOB.Job_ID, SUM(J.Time) FROM TABLE_1 Prod INNER JOIN TABLE_2 Job ON Prod.Job_Id = Job.Job_ID GROUP BY Prod.Product_ID, Job.Job_IDSAP HANA does not support Pivot built-in as done by SQL but majorly it looks as a UI requirement. So what you can do is send the entire result to report and apply transformation in the report as per your requirement.
Read MoreGetting error message: Scalar type not allowed in SAP HANA
Few points about your code to create a Stored Procedure, that you can edit and tryPROCEDURE "SLT_DELETE"."HCDW.IT.IT::TO_TIMESTAMP_CALL" (IN IN_DATE DECIMAL(15), OUT OUT_DATE TIMESTAMP) LANGUAGE SQLSCRIPT AS --DEFAULT SCHEMA --READS SQL DATA AS BEGIN select to_timestamp(IN_DATE) into OUT_DATE FROM DUMMY; END;In Line32, you have used below:SELECT: ORGID_ARTIKEL intoHowever correct syntax should be like:SELECT "ORGID_ARTIKEL" into
Read MoreCreating Index in Column based tables in SAP HANA
Note that an index not necessary to be NOT NULL. You can create an Index in SAP HANA database by using below query:CREATE INDEX IDX_MY_INDEX ON TABLE1 (MY_COLUMN);To know more about SAP HANA database, Modeling, and Administration features, you can refer our SAP HANA Text and Video tutorials:https://www.tutorialspoint.com/sap_hana/https://www.tutorialspoint.com/sap_hana_online_training/index.asp
Read MoreExposing employee master data from SAP HR system using Web Service
In a general scenario, when you have ICF configured you can expose SAP system business objects and jobs via BAPI. It is very easy to create and expose BAPI as a web service. As there are only few web services for SAP HR module in SAP system however you can transform a BAPI or ABAP function into a web service. If there is no such function you can create one easily.To find details about BAPI from Function module, use T-Code: SE37 and enter Functional module name for SAP HR module. Below is the list of existing HR function modules in ...
Read MoreExposing xsjs file data through web browser in SAP HANA
Note that you have to ensure that Port number 80+ should be open on network. Also URL you are using should be properly built. Below is correct path:server:port/repository_path/file_nameIn your case, you should be using:host: hanacloud port: 8000 (80 + instance_number) SAP HANA Repository tree: mdo -> sap -> sflight -> test -> test.xsjsSo your URL should be in this format:hanacloud:8000/mdo/sap/sflight/test/test.xsjs
Read MoreRunning T-code me51n again in SAP system throws an error
Try using breakpoint on my include in EXIT_SAPLMEREQ_010 and check if it gets to breakpoint on the second run.It could be possible that error gets stuck due to standard SAP procedure. Try to run this T-code: me51n in different environments and check if it works fine.
Read MoreUsing parallel processing in SAP HANA
With the use of column based storage in HANA, data is available vertically and hence operations on different columns can be easily performed. When there is a requirement to process to process more than one column, it is processed by the different processor.
Read MoreSQL Script vs Graphical Calcualtion views in SAP HANA
In SAP HANA Modeling, Graphical Information Views are faster as compared to SQLScript in almost every scenario and also Graphical Information Views are easier for others to understand, remodel and change.There are scenarios where you need SQLScript, but it shouldn’t be viewed as a general-purpose solution to modeling problems.Note:It is never recommended that you code a Calculation View with SQL Script and use it inside another Calculation View with CE Functions as it results in a very bad performance.
Read MoreLimitations of using SAP HANA 1.0
SAP HANA 1.0 can replicate data only from few of data sources and only in few formats using Sybase Replication. You can perform batch loading using SAP Data Services and it is optimized only for Business Object 4.0 for reporting.
Read More