Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
talend777
Contributor
Contributor

SAP HANA Calculation view extract Data

Hi gurus,

I am trying to extract data from SAP HANA calculation views, where all views have prefixes like prod.fi/view_name

e.g. prod.fi/cv_bseg, prod.md/cv_mseg etc.

SQL Query --select * from prod.fi/cv_bseg (this works great in SAP HANA so i know syntax is right)

 

Not sure if escape characters like  "/" in the calculation view name is causing this.

SAP Connection is built successfully using tsapHANAInput and i have tested this if i query small table directly which works for statement like "select * from BSEG". 

I have also tried playing around sql query tsapHANARow but no success.

(reading other topics i tried something like prod.fi//cv_bseg or prod.fi/\\cv_bseg) for escape characters but its not doing the trick.

 

Any recommendation will be helpful

Thank you

 

 

Labels (2)
0 Replies