Hi FolksI am trying to use a Graphical calculation view with input parameter inside a SQLScript Procedure . ( Basically I am trying to write an AMDP ) . This works for single value Input parameter but not getting the syntax for multi value parameter...
Hi FolksI am trying to run a query against calculation view ( consumed via XSJS) and trying to pass multiple customers in where clause . What should be my URL ?URL with one customer returns data but unable to generate URL for multiple customers.https...
Requirement :Most of the popular reporting tools can handle cumulative sum or running total , but still there have been lot of posts in SCN about whether it is possible to do it in HANA itself. So, just wanted to see , if it can be easily done via G...
Recently I saw some posts in SCN where people asked "how can we restrict data HANA views dynamically?" Like showing data for "Last 3 months" , "Last 13 Months" or "Last two years" etc . So, thought of listing the steps in a small blog post.
Req...
Hi Ibrahim What we are using for large set of data is Function Module based extractor. It is like same generic extractor for DataSource but instead of using cursor, I am calling same HANA model again and again with set of parameters. For example, le...
For AMDP and ADBC you have no issue with Input Parameter as those essentially send SQL Query. Based on your data volume, you can also try Composite Provider(HPCR) built on top of HANA view. That is is the easiest way to expose HANA models to BW when...
Rajesh - instead of Proxy Procedure you can use either AMDP Class or ADBC interface . AMDP is easy but ADBC gives us better performance .
Regards
Anindya
If you are missing some rows, then check INNER JOIN and WHERE Clause . I am not aware of the complete requirement here , but you can change INNER to LEFT OUTER JOIN and/or drop the WHERE Clause to understand where you are missing records . To filter...
(MIN_STOCK - IN_STOCK)>0 THEN (MIN_STOCK - IN_STOCK)Above statement is basically doing the same . If my understanding is not correct, can you put a table and explain what exactly you want the query to return .CheersAnindya